Create Table diagram from ERD – The database will have between 5 and 7 related entities-Write and run scripts to create tables and define constraints

Assignment Question

TOPIC: FASTFOOD Restaurant Management Objective: Apply SQL concepts to create a functional database appropriate for a small business/hobby.

Part 1: Create Table diagram from ERD – The database will have between 5 and 7 related entities.

Part 2: Write and run scripts to create tables and define constraints. – All tables will have PK/FK defined Part 3: Insert sample data – At least 5 records should exist in each table.

Part 4: Test database

Part 5: Write questions and answer queries to exercise each one of the following concepts:  Sorting data and Restricting Rows (Ch 8)  Joining Data (Ch 9)  Single-row functions (Ch 10)  Group functions (Ch 11)  Subqueries (Ch 12) Part 6: Prepare final project presentation PowerPoint

Part 7: Present your Final Project (5-7 minutes)  Present your business and the ER diagram, explain relationships between tables and all constraints.

Part 8: Turn in the project, include ER diagram, the presentation and script to create the DB and the queries from Part 5 Book: http://www.cherrycreekeducation.com/bbk/b/Cengage_Learning_Oracle_12c_SQL_3rd_Edition_1305251032.pdf

Last Completed Projects