The database keeps track of how many points is scored by each player during the

The database keeps track of how many points is scored

This preview shows page 7 - 10 out of 12 pages.

The database keeps track of how many points is scored by each player during the season. Each team also has coaches. The coaches are characterized by their name and the date (month, year) they started coaching the team. Based on that information: 1. Define the entities and attributes 2. Define the attribute constrains Then Start a new Model, from MySQL Workbench home page and : 3. Create the tables and column based on your answers for 1 and 2 4. Create an ERD model of the database. Do not forget to save your model under a new *.mwb file.
Image of page 7
E. Practice #3: Now that you are familiar with the MySQL workbench environment, design tables and a normalized ER model based on the following EER diagram: Note that you first have to normalize this table as 3NF and then create the tables and the final EER diagram. Note: The solution indicates a good example of how a supertype/subtype situation is represented in a relational model. You have to define some type of relationship that does make sense to entity relationship. In MySQL diagram, you will also have an “identifying relationship”.
Image of page 8