Activity 2.01 – modifying the EER diagram, the model, and the database
Your manager has asked you to include the ability to track Membership Fees in the autoclub database. Take a good long look at the EER diagram to see how you can insert this request into the database. You have decided to perform the following steps in order to implement this:
- Insert a new table named
membershipfees.
The table will have the following columns and datatypes:
Figure 2.78: The membership fees table description
- Save the EER diagram with the changes.
- Synchronize the model with the database.
Note
The solution to this activity can be found in the Appendix section.
You have worked through updating the database via the EER diagram and model. This method is useful for situations where you want to plan a database structure and apply it directly to the SQL database. Often, EER diagrams are an easier way to visualize structures, so being able to directly...