Database Design and Realization

1. purpose of the experiment

Select an application field, design ER (EER) model according to requirements, and map it to relational mode. Finally, create a database in MySQL and add some initial data.

2. experiment content

Question 1

Find a application field and list its requirements, including at least 10 entities.

Question 2

Use software tools to draw EER model according to the requirements above.

Question 3

The EER model is mapped into relation schemas according to the mapping approach. The primary key and foreign key of each relation should be given. Each one should meet at least 3NF.

Question 4

Create a database in MySQL to realize all the relations, and organize the appropriate initial data. All MySQL scripts related to database implementation should be given.