LU04.A07 - ERD: Reingineering of an existing database

From time to time, we may need to analyze an existing database in order to optimize the structure, e.g. for the next software version.

• Work type: Peer
• Means of aid: W3Schools-SQL-Editor
• Timeframe: 45 Minutes
• Expected result: ERD as a PDF-File, that describes the content of the given date-base in Crow's Foot Notation.

Go to the W3Schools-Website, to the SQL-Editor, and analyze the existing data-structure. Create furthermore an ERD, that describes the existing data-structure in the Crow's Foot Notation.

1. Identify all enties.
2. Add the attributes and the corresponding data-types to each entity.
3. Relate the tables to each other by analysing the primary keys and the foreign keys.

Lösung

Volkan Demir