CIS 300 Lecture Notes - Lecture 5: Fokker E.Ii, Tranche, Data Redundancy
Document Summary
Cis chapter case tutorial a notes: database terminology, database a. i. Related objects saved in one file: object b. i. Table, form, query, report, or macro: table c. i. Two or more fields with unique values c. iv. Object used for data entry: query g. i. Ex: how many emplotees have more than 5 years of service? g. ii. Must be connected tby a join operation g. ii. 1. a. Links tables together on the values in a common feld g. ii. 2. Ex: video store (customers and dvds) (dvd rental and hours worked) a. ii. Definition: one instance of entity a is related to one instance of entity b b. ii. 1. a. i. Definition: one instance of entity a can be related to many instances of entity b b. ii. 2. a. i. Definition: one instance of entity a is related to many instances of entity b while one instance of entity b is also related of entity a b. ii. 3. b. One character in many shows, many characters in one show: attributes c. i.