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$\mathrm{.}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 $(510$ 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.

$1$ You must use Oracle SQL Developer for Parts B and C$.$