Choose some facet of real life that you feel needs to be modeled by a database. Then, you must design a relational database schema that adequately represents this information, and demonstrate its efficacy by providing a set of useful queries that your database can support.
In the process, you must use standard relational modeling tools and techniques. In concrete terms, this part of assignment consists of the following steps:
1. Begin by choosing an application, e.g., the database for a local volleyball league or the database for a Society of Roasted-Shrimp Fans. It must be non-trivial, but not huge. As a general guideline, you should probably have about seven to ten entity sets and a similar number of relationships sets.
2. Specify the assumptions about the database in English (informally). Here you talk about attributes, keys, the nature of relationships between entities, etc. Do not discuss something that is obvious (e.g., That a student can take several courses). In addition, don't make too many simplifying assumptions.
3. Give an ER diagram, which will reflect your choice of the entity sets, their relevant attributes, and the relationships among them. Again, make your relationships realistic and meaningful.