Part 1 - List at least four basic rules for identifying primary keys in a relational database. Mention how you would go about identifying the foreign keys in your design. Briefly discuss foreign key ownership and how to indicate a foreign key in your relational database model.

Part 2 - Describe at least two examples of common errors in entity relationship modeling. If possible, provide a graphical illustration of the problems and solutions. List some questions the designer should consider before designing the models so that these errors can be avoided.