Let’s use this discussion to demonstrate the connection between data modeling and database design. This discussion is going to help you as your team works on ER modeling and database design phases of your project.

1. Define E-R diagram. What does it represent?
2. What is the purpose of normalization and what is the outcome?
3. What is the relationship between an E-R diagram and a set of normalized relations?
4. What is the purpose of a Primary Key and a Foreign Key?
5. Give an example of a Primary Key and an Foreign Key showing two related tables. Use the following notation:
   • TABLENAME(Primary Key, Attribute 1, Attribute 2, Attribute 3, Foreign Key)

Around 250 words