• create required tables with attributes corresponding to the above ERD;

• specify the 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;

• All constraints are to be defined in CREATE TABLE statements.

• When a record about a tour operator is removed from the database, the records about Airlines associated with this tour operator must also be removed from the database.

• When a record about a tour operators representative who supervised other representatives is removed from the database, the records about subordinate representatives must remain in the database.

• Domain of attribute Category (Room entity set) contains only three values: standard, luxury and executive.

• Domain of attribute Fee (Service entity set) contains numbers between 0 and 200.

• Domain of attribute Nbed (Room entity set) contains integer numbers 1, 2, and 3.

Website Category Title Bnum SID Fee Aname BView Phone Building Service Airline V N Has Sdate Deals Rnum Is booked TOID Nbed 1 Room VID Vdate Tour Operator Category Cname 1 Visit Phone Is_accommodated Mtype Employs S GID P 1 Is_served Gname 1 Rname Guest RID Phone Address Restaurant Representative Is_assigned Theme Principal Regular RestID Rtype Rname Credit Card Status Y Reports_to