Page 112 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 6: Relational Language and Database Design

6. Write all full functional dependencies for the ER diagram below. The genus and species of Notes
the plant determine the type of fruit, flower arrangement, leaf arrangement, and leaf
shape.

genus species

plant

Leaf Arrangement
Genus Description Leaf Shape
Flower Arrangement
Fruit Type

Answers: Self Assessment

1. (a) 2. (b)
3. tuple variable 4. DRC
5. database design 6. Rectangles
7. weak entity 8. Overlap constraints
9. Covering constraints 10. Aggregation

6.16 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 105