1. Objective This lab will help you to learn How to use the CASE tool Oracle Data Modeler for database modeling, in particular creating ERD diagrams and generate relational schemas

2. Tutorials and Notes about Oracle Data Modeler

How to create ERD models using Oracle Data Modeler: https://www.youtube.com/watch?v=yu2Yr_GFC1E

Note: this video uses a standalone Oracle Data Modeler. At the end of this document, there are descriptions about using Oracle Data Modeler embedded inside Oracle SQL Developer.

How to generate relational schemas using Oracle Data Modeler https://docs.oracle.com/cd/E15276_01/doc.20/e13677/tut_data_modeling.htm#insertedID2

3. Tasks to Complete

a. Read/Watch the above tutorials if you dont know how to use Oracle SQL Developer Data Modeler

b. Use Oracle Data Modeler to create the following ERD diagrams in Chapter 2 of Jukics book: Introduction to Database and Data Warehouses.

Page 20, Fig 2.11 (M:N relationship), Fig 2.12 (only the top part, 1:M relationship)

Page 29, Fig 2.29 Example A and Example C (Unary relationship)

Page 32, Fig 2.35 (weak entity with 1:1 identifying relationship)

Page 35, Fig 2.38 (Property Management Database), only these entities and relationships:

o Entities: INSPECTOR, BUILDING, APARTMENT, CORPCLIENT

o Relationships: Inspects, LocatedIn, Leases, Refers

c. Use Oracle Data Modeler to generate the relational schema for the ERD diagrams in Step b.

d. Submit these items:

i. The ERD diagrams created in Oracle Data Modeler (Note: the notations are different from the book)

ii. The relational schemas generated by Oracle Data Modeler

iii. Compare the relational schema from Fig 2.38 auto-generated by Oracle Data Modeler and the one in the book. Write a description of your comparison in terms of these items:

Number of relations

The attributes in each relation

Other domain constraints (such as null/not null) Primary and foreign keys