Create required tables with attributes corresponding to the ERD;

• specify the primary key and foreign keys (if such exist) for each table;

• implement additional integrity constraints described below;

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 manager is removed from the database, the records about their subordinate people must remain in the database.

2. When a record about a session is removed from the database, the records about books of papers corresponding to the session must be removed from the database.

3. Domain for attribute Category (Employee entity set) contains four integer numbers: 1, 2, 3, and 4.

4. Domain for attribute Amount (Fee entity set) contains numbers greater than or equal to 100 and less than 900.

5. Domain for attribute Role (Works relationship set) contains only two values: 'chair', and 'member'.

ERD is implemented using Chen notation.

• Assume that the names and addresses are atomic

• Each capital letter (like M, N, etc.) means "many".

•Assign reasonable data types for table attributes (fields).

 

EID M Subordinate PID Name M_tongue Z Reports to Name Employee Presenter Writes Category Participant K Address Manager R Deals with Tnum ConflD D of B Y Title Accompanied Pnum Pays Title Title Topic C Paper P Conference FTID Category Location 1 L Q Fee Sdate SPage Cdate Amount Includes Role Works Description Contains Has Name Snum Occupation Book ISBN O Org_member N MID Format CSession 1 Title Results Year Room