Obtain an EER diagram from a database administrator or system designer. Based on what you have learned
Question:
Obtain an EER diagram from a database administrator or system designer. Based on what you have learned in this book, convert this into a relational schema in 3NF. Now interview the administrator on how they convert the diagram into relations. How do they impose integrity constraints? What was the need for this? How do they identify candidate keys, and is there any usage of surrogate primary keys? Did they face the issue of merging relations? How did they overcome it?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
Question Posted: