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?