This assignment will prepare you to implement a web application using a database, based upon the concept you developed in a previous homework. Your task is to design, on paper, the relations that will be needed for your application.
Entity-Relationship Diagram
Begin by drawing a full entity-relationship diagram. Your diagram should display all the relevant entities and relationships that you have chosen to model, with their attributes. The primary key(s) should be underlined. If you make any difficult or unusual decisions here, you should include a side note justifying your choice. Include arrows to indicate the type of relationship (many-many, many-1, or 1-1)
Take your time and draw your diagram neatly. It is likely that you will produce a clearer result if you plan to produce at least two drafts. Make sure that the writing is legible. It is important that your diagram conveys your ideas neatly enough for me to understand them, but of course it is the ideas themselves that are most important.
Schemas
When you have finished your E-R diagram, it is time to turn it into a set of schemas for a relational database. Begin with the entities, then more on to the relationships. Consider whether these deserve their own table or can be merged with one of the existing entity tables. Keep in mind the guidelines we discussed in class, particularly those about avoiding redundancy (and possible anomalies) and achieving fidelity, while seeking all possible simplicity.
Finally, swap your work with someone else in the class and look over the schemas you have each defined for any potential problems. Imagine how the tables will be used in practice, including unlikely but possible hypotheticals (two people with the same name and birthday, etc.). Does this bring any additional problems to light? Include the name(s) of your reviewers with your work. Show any design modifications you made as a result.