https://www.youtube.com/watch?v=yu2Yr_GFC1E

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 nullot null) Primary and foreign keys

HERE ARE THE TABLES: