LU03.A07 - ERD: Reingeneering from the 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: 60 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 to each entity the attributes and the corresponding data-types
3. Put the tables in relation to each other by analysing the primary-keys and the foreign-keys.

Lösung

Volkan Demir