Your first step is to identify the domain you would like to manage with your database. We suggest that you pick an application that you will enjoy working with, since you'll be stuck with it for the whole quarter! Examples include hobbies, material from another course, a research project, etc. You will get the most out of this part of ICS184.
Try to pick an application that is relatively substantial, but not too enormous.
(20 points) Describe the database application you propose to work with throughout the course. Your description should be brief and relatively informal. In answering the question, specify objects or entities in the domain being modeled, the properties of objects, various constraints, and the examples of 5 queries that you would wish to run on the database. If there are any unique or particularly difficult aspects of your proposed application, please point them out. Your description will be graded only on suitability and conciseness. Your answer should be no more than one page.
(80 pts.) Specify an entity-relationship diagram for your
proposed database. As always, don't forget to underline key attributes,specify weak entity sets, total participation
and include arrowheads indicating the parity of relationships.
NOTE: Don't forget to save a copy of your PDA for reference as you do Step 2 of the PDA.