Detailed information file attached
PART 1 (3%)– Write a 1-2 page Statement of Work (SOW) to describe the need to create, design and implement the database that you propose for your project.
PART 2 (5%)– Create requirement definition document and use ER Assistant, Visio, or SQL Developer Data Modeler to create Entity Relationship Diagram (ERD) for your project.
PART 3 (6%)– Use SQL DDL statements to create your tables/views/triggers and other required database objects for you project. Also include queries (select statements on database catalog/data dictionary such as user_objects and user_tables) to demonstrate all objects are created successfully.
PART 4 (6%)– Use SQL DML statements to insert sample data into your tables. Use SQL SELECT statements to query your data. This submission should be a final consolidated document which includes Project Part 1, Part 2, Part 3 and Part 4.