Hi, I need help with • create required tables with attributes corresponding to t

Question

Hi,

I need help with
• 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
The following additional integrity constraints MUST be implemented:
1. When a record about a customer is removed from the database, the records about orders placed by this customer must also be removed from the database.
2. When a supervisor leaves the company, the corresponding record must be removed from the database, but the records about subordinate employees of this employee must remain in the database.
3. Domain for attribute Rent (Cottage entity set) contains numbers between 100.00 and 1500.00.
4. Domain for attribute Price (Material entity set) contains numbers greater than 0 and less or equal than 50.
5. Domain for attribute Type (Service entity set) contains only three values: 'Cooking', 'Babisitting', ‘Maid_in’.

I HAVE THE ERD BUT I CAN NOT ATTACH IT HERE SO IF U ARE WELLING TO HELP SEND ME YOUR EMAIL ADDRESS SO I CAN EMAIL U THE ERD THX

Explanation / Answer

>>-CREATE--TABLE--table-name------------------------------------> >--+-| element-list |----------------------------+--*-----------> +-OF--type-name1--+-------------------------+-+ | '-| typed-table-options |-' | +-| materialized-query-definition |-----------+ +-| staging-table-definition |----------------+ '-LIKE--+-table-name1-+--+------------------+-' +-view-name---+ '-| copy-options |-' '-nickname----' >--+----------------------------------------------------------------------+--> | .-,-------------------------. | | .-DIMENSIONS-. V | | '-ORGANIZE BY--+-+------------+--(----+-column-name-----------+-+--)-+-' | | .-,-----------. | | | | V | | | | '-(----column-name-+--)-' | '-4 KEY SEQUENCE--4 | sequence-key-spec |-----------------' .-DATA CAPTURE NONE----. >--*--+----------------------+--*-------------------------------> '-DATA CAPTURE CHANGES-' >--+----------------------------------------------+--*----------> '-IN--tablespace-name1--| tablespace-options |-' >--+-------------------------------------------------------+----> | .-,------. | | V | .-USING HASHING-. | +-PARTITIONING KEY--(----column-+--)--+---------------+-+ '-REPLICATED--------------------------------------------' >--*--+-------------------+--*--+-----------------------+-------> '-VALUE COMPRESSION-' '-WITH RESTRICT ON DROP-' >--*--+----------------------+--*--+--------------------+--3 *----> '-NOT LOGGED INITIALLY-' '-3 CCSID--+-3 ASCII---+-' '-3 UNICODE-' >--+----------------------------------------------------------------+->< | .-,-------------------------------------------. | | V .-ADD-. | | '-OPTIONS--(----+-----+--table-option-name--string-constant-+--)-' sequence-key-spec: .-,-----------------------------------------------------------------------. V .-4 AT-. | |--4 (----4 column-name--+------------------------------+--4 ENDING--+----+--4 constant-+--4 )--> | .-4 FROM-. | '-4 STARTING--+------+--4 constant-' >--+-4 ALLOW OVERFLOW----+--+------------------+------------------| '-4 DISALLOW OVERFLOW-' '-4 9 PCTFREE4 --4 9 integer4 -' 4 4 element-list: 4 4 .-,------------------------------. 4 V | 4 |--(----+-| column-definition |------+-+--)---------------------| 4 +-| unique-constraint |------+ 4 +-| referential-constraint |-+ 4 '-| check-constraint |-------' 4 4 typed-table-options: 4 4 |--+---------------------------+--+------------------------+----| 4 +-HIERARCHY--hierarchy-name-+ '-| typed-element-list |-' 4 '-| under-clause |----------' 4 4 under-clause: 4 4 |--UNDER--supertable-name--INHERIT SELECT PRIVILEGES------------| 4 4 typed-element-list: 4 4 .-,-----------------------------. 4 V | 4 |--(----+-| OID-column-definition |-+-+--)----------------------| 4 +-| with-options |----------+ 4 +-| unique-constraint |-----+ 4 '-| check-constraint |------' 4 4 4 materialized-query-definition: |--+-----------------------+--1 AS--1 (--1 fullselect--1 )--------------> | .-,-----------. | | V | | '-1 (----1 column-name-+--1 )-' >--1 | materialized-query-table-options |-------------------------| materialized-query-table-options: |--+-1 WITH NO DATA--+------------------+-+-----------------------| | '-| copy-options |-' | '-| refreshable-table-options |------' copy-options: |--*--+-------------------------------------+--*----------------> | .-COLUMN-. | '-+-INCLUDING-+--+--------+--DEFAULTS-' '-EXCLUDING-' .-COLUMN ATTRIBUTES-. .-EXCLUDING IDENTITY--+-------------------+-. >--+-------------------------------------------+--*-------------| | .-COLUMN ATTRIBUTES-. | '-INCLUDING IDENTITY--+-------------------+-' refreshable-table-options: |--1 *--1 DATA INITIALLY DEFERRED--1 *--1 REFRESH--+-1 DEFERRED--+--1 *-----> '-1 IMMEDIATE-' .-1 ENABLE QUERY OPTIMIZATION--. >--+----------------------------+--1 *----------------------------> '-1 DISABLE QUERY OPTIMIZATION-' >--+-----------------------------------+--1 *---------------------| '-1 MAINTAINED BY--+-1 SYSTEM---------+-' +-1 USER-----------+ '-7 1 FEDERATED_TOOL7 -' 7 7 staging-table-definition: 7 7 |--+-------------------------------+--FOR--table-name2----------> 7 | .-,-------------------. | 7 | V | | 7 '-(----staging-column-name-+--)-' 7 7 >--PROPAGATE IMMEDIATE------------------------------------------| 7

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.