Page 154 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 8: Normalization

(g) Owner (OwnerSSN, Name, Address, City, State, Zip) Notes
PctOwned (PropertyID, OwnerSSN, PctOwned)
Property (PropertyID, Address, City, State, Zip, Description, Price, OfficeNbr)
(h) PCAccess (PC#, EmpID, AccessType, AccessDescription)

Answers: Self Assessment

1. MVD 2. redundancy

3. Normalization 4. transitive
5. transitive dependency 6. Foreign keys
7. Multivalued 8. Fifth Normal

9. minimum redundancy 10. data inconsistency
8.12 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Martin Gruber, Understanding SQL, BPB Publication, New Delhi
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd Edition,
Tata McGraw Hill.
Silberschatz, Korth, Database System Concepts, 5th Edition, McGraw Hill.
SIlberschatz-Korth-Sudarshan, Database System Concepts, 4th Edition, Tata
McGraw Hill
Vai Occardi, Relational Database: Theory & Practice, BPB Publication, New Delhi

Online links www.en.wikipedia.org

www.webopedia.com
www.web-source.net

LOVELY PROFESSIONAL UNIVERSITY 147