Database Exercises
CarsDb

In this exercise you will make a database from the backup-file(carsdb.sql) and then create the model based on the database.

Restore the database
  1. Download the file carsdb.sql
  2. In MySQL Workbench: Server->Data Import
  3. Check the option "Import from Self-Contained File
  4. Click the ellipses-button (...) and choose the file carsdb.sql
  5. Click Start Import
  6. Refresh the Schemas View and check that you have the database with tables: car,carownner, owner

Create the Model
  1. Follow the instructions from previous exercise. Note that the model name should be carsdb.
  2. Create the ER-Diagram. The diagram should look like this
    er diagram



Toggle Menu

Copyright © Pekka Alaluukas / 2023
email