BCS 260 Lecture Notes - Functional Dependency, Candidate Key, Multivalued Dependency
Document Summary
Figure 2. 19 sample s t u_d o r m relation and data: identify all the candidate keys of the relation student number, identify all the functional dependencies in the relation dormname. Dormcost: examine the determinants of the functional dependencies. Figure 2. 20 normalized s t u_d o r m and d o r m. Figure 2. 21 sample employee relation and data: identify all the candidate keys of the relation employeenumber, Emailaddress: identify all the functional dependencies in the relation. Departmentphone department: examine the determinants of the functional dependencies. Figure 2. 23 sample meeting relation and data: identify all the candidate keys of the relation no column alone candidate key (attorney, clientnumber) not unique (boxer, 1000) represent two different tuples (attorney, clientname) fails also same reason. Therefore: (attorney, clientnumber, meetingdate) works and (attorney, clientname, meetingdate) Identify all the functional dependencies in the relation. Client name client number: examine the determinants of the functional dependencies.