Part B Database Implementation

$(35$ marks$)$

In this part, you should develop a database based on your logical ERD developed in Part A$.$ You must populate the tables with realistic sample data.

Task $3$ Create tables

$[25$ marks$]$

Create the tables in Oracle. ${?}^1$ Write SQL scripts defining each table. The table definitions should include

All attributes with appropriate data types

All appropriate constraints, such as primary key, foreign keys, and check statements $($CHECK constraints$).$

All constraints must be given names. Naming standards must be used.

Task $4$ Populate data

$[10$ marks$]$

Insert a small sample of realistic test data $(5-10$ rows minimum$)$ into each table. All test data must be meaningful to demonstrate your understanding of the data.

After creating all your tables $($Task $3)$ and inserting data $($Task $4),$ run the SQL SELECT statement below:

SELECT table$\_$name FROM user$\_$tables;

The statement will retrieve a list of all tables in your Oracle account $($i$.$e$.,$ all tables you created this semester$).$ Include the results of the SELECT statement in your assignment.

You must also include the following for each table in your database:

SQL table creation script

SQL insert script $($used for inserting sample data$)$

Evidence of Sample data $-$ you must run "SELECT $*$ FROM table$\_$name" $($where table$\_$name is the table's name$)$ for each table in Task $3$ and include results of SELECT statements for each table.