Create required tables with attributes corresponding to the ERD; specify the primary key and foreign keys
Question:
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).
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last