[Solved]Goal Design Database Sql Plus Project Case Scenario Create Business Case Scenario Delivera Q37203527

Goal: Design a database in SQL PLUS.

Project Case Scenario: Create your own business casescenario.

Deliverables:

i) A one-page summary of your business case scenario inclusiveof the goals of your database solution and mention all businessrules.

ii) ER Diagram: Create at least 6 tables and must identify ALLreferential integrity constraints and cardinality constraints. Useappropriate notation for primary keys and foreign keys. Alsomention assumptions that are critical to justify your ERDdesign.

iii) Relational Schema (using table descriptions): Specifyattributes for each table/entity. Indicate primary key and foreignkey with proper notations including NULL and UNIQUEconstraints.

iv) Table Definition Script (DDL): You must write the actual SQLscript that creates tables in SQL Plus. Make sure the designs ofERD, Relational Schema and Table Definition Script areconsistent.

v) SQL Queries: Develop 10 queries, among which you must use atleast 3 sub queries (one must be correlated), 4 inner joins (onemust be Self-Join), and 3 outer joins (either left, right or full).In your outer joins, there must be at least 2 three-way joins. Yoursub queries must be at least three-layers or above. For inner joinsother than Self-Join, you must use at least three, or more,tables.

Expert Answer

---

Answer to Goal: Design a database in SQL PLUS. Project Case Scenario: Create your own business case scenario. Deliverables: i) A o… . . .