Objectives:
The purpose of this lab is to familiarize you with tables, columns, relationships and constraints as provided to you within the sample database. By the end of this lab you should be able to:
· Produce a relationship diagram of an existing database
· Visualize the sample database provided to you and display the relationships between the tables
· Be familiar with the sample database that we will be using for the remainder of the term
Preface:
During this lab, you will need to create a relationship diagram. There are many free tools available to you for this task. One example would be http://draw.io.
Explore the Database
By navigating through SQL Developer and looking at the Columns, Data and Constraints tabs for each table, you will create a relationship diagram for all the tables in the database.
Your diagram must include:
· All 8 tables
· The names of the entities (tables)
· The attributes (columns) for each table
· Lines representing the relationships between tables
· Crows Foot Symbols on the lines representing the type of relationship (1-1, 1-many)
· Required fields should be bolded
· Primary Key fields should be underlined or indicated with a PK beside it.
· Child fields in the relationships should be indicated with an FK beside it.
