Project Phase III Instructions Convert the ER/EER diagram provided by the instructor into relational schema diagrams using the mapping steps explained in Chapter 9 and concepts discussed in Chapters 3, 4, 5, and SQL DDL.

Project Phase III Instructions

• Convert the ER/EER diagram provided by the instructor into relational schema diagrams using the mapping steps explained in Chapter 9 and concepts discussed in Chapters 3, 4, 5, and SQL DDL.
  • The provided ER/EER Diagram does not contain all the attributes. Look Phase2 and add all the provided attributes to your relational
  • Identify attribute requirements (not null, unique, invalid values, etc.) and data types (integer, varchar 2, date, etc.), keys (primary, composite, foreign), relationships, and other constraints (on delete no action, ).
  • Create Relation Schema Diagram (as shown below) for each entity/relation using Oracle Data Modeler. Capture the possible (Min, Max)
  • Name the relations, attributes, relationships, etc. appropriately. Example Schema Diagram (Using Oracle SQL Data Modeler) see the Demo video posted

• Develop six relational-algebra queries that allow you to retrieve information from the database relational schema diagram. Refer textbook Chapter 8. Use can use http://leap.sourceforge.net to get hands-on
  • For each of the following queries: write the query description in English (similar to the book exercise 8.16. a through j), and the relational algebra expression based on the relational database diagram. Explain what each query is
  • Query 1: A query involving one table to demonstrate select, project, and rename o

• Query 2: A query involving two tables to demonstrate equi-join
• Query 3: A query involving two or more tables to demonstrate aggregation
• Query 4: A query involving two or more tables to demonstrate division
• Query 5: A query involving three or more tables to demonstrate grouping
• Query 6: A query involving three or more tables to demonstrate outer join/outer union

o See chapter 8 examples

• Submission:
  • Upload to Canvas and Print the documents and submit
    • Zip file of the entire project folder created by the Oracle Data Modeler software (make sure to test whether you have zipped the appropriate folder)
    • PDF of the Relational Schema Diagram (e.g., from Oracle Data Modeler, see above)
    • PDF of the Relational Algebra Queries