Answer Happy

Based on the idea you developed in step1, you will design the database and list some interesting queries your database is designed to answer. In this step, you are a designer so you will not use MySQL or Java to implement the database. 1) Draw an ER diagram (3 points) that represents the main aspects of your database (entities, attributes, relationships, mapping cardinalities, etc.) – as we discussed in Unit2. You should have at least 3 entity sets and at least 3 relationship sets (you may have more, but for time constraints these are the minimum requirements). 2) Translate the ER diagram into the appropriate relational schemas (3 points) - as we discussed in Unit3. Make sure you include the data types of the attributes and references between primary and foreign keys. 3) Think of 6 queries (4 points) you find interesting to answer using your database - at least 4 queries need two or more tables to be answered (engage the Join operator). The developed queries are in English (a short query description) and in SQL.