Create a logical schema using Oracle DBMS on SIT Server based on an ERD provided. You

are to:

ï‚· create required tables with attributes corresponding to the ERD;

ï‚· specify primary key and foreign keys (if such exist) for each table;

ï‚· implement additional integrity constraints described below;

ï‚· create a file holding CREATE TABLE statements and execute the statements from the

file using @ SQLPLUS command

ï‚· record your session on Oracle DBMS in Linux using script command

ï‚· You are NOT allowed to use ALTER TABLE statements to add integrity constraints. All

constraints are to be defined in CREATE TABLE statements

The following additional integrity constraints MUST be implemented:

1. When a record about a driver is removed from the database, their driving records must

also be deleted form the database.

2. When a consultant leaves the Gallery, the corresponding records must be removed from

the database, but the records about art objects evaluated by this consultant must remain

in the database.

3. Domain for attribute restoration (Art_object entity set) contains only two values:

‘Yes’ and ‘No’.

4. Domain for attribute Points (Record entity set) contains integer numbers greater or equal

to 0 and less than 8.

5. Domain for attribute P_type (Phone entity set) contains only two values: ‘home’ and

‘cell’.

SUBMIT:

1. Cover page indicating your last name, first name, student number, course code and

section.

2. Printout of your recorded session or sessions on Oracle on SIT Server. The printout is to

demonstrate the execution of your SQL statements from the file.

3. You ARE TO enclose with your assignment the printout of the file holding CREATE

TABLE SQL statements.

4. You ARE NOT allowed to modify script file.