CIS3050 Project Part 2 Oracle Database Development Project II continues developing the database based on your Project 1.

CIS3050 Project Part 2

Oracle Database Development

Project II continues developing the database based on your Project 1. Create the database based on the logical design in Project 1 using Oracle. Run SQL queries to test the database in your Oracle account.

Project 2 would typically go through the following phases:

1. Create the Company database with five constraints in the six appropriate tables and load data into the database via ORACLE SQL*PLUS. 

Submission: Printout of SQL DDL script (Database creation script), database structure (DESC TableName) and database instance (SELECT * FROM TableName)

2.  Test your Company relational database via ORACLE SQL*PLUS, which includes SQL statements, SQL solutions and outputand save them in the MS word file. 

2.1 Your SQL DML statements must include insert, delete, update and view 

2.2 Your SELECT statements must include join tables, subqueries, Group by .... Having and function statements. 

Submission: Printout of Question, corresponding SQL statement and corresponding output for each query. Finalized project table of content, Combined Project 1 and Project 2 in Project 2 online by group

Note: One Select statement per team member

          One SQL DML statement per team member