Second picture is the MC6 from chapter 3 I ule ill . Write CKEAID tables ExoProt

Question

Second picture is the MC6 from chapter 3 I ule ill . Write CKEAID tables ExoProtect Employees' Computers Database den fo relational schema created in mini case MC5 Use INSERT INTO statements to insert no fewer than and no more than 10 records per table in the ExoProtert Employees' Computers Database. for ase MC5 in Chapter 3 depicted by the MC6 Jones Dozers . Write CREATE TABLE statements to create the tables for Jones Dozers Sales and Rentals Database depicted by the relational schema created in mini case MC6 in Chapter 3. Use INSERT INTO statements to insert no fewer than 2 and tect Employee Computers Database. MC7 Midtown Memorial n the tables for

Explanation / Answer

-------MCUSTOMER TABLE

CREATE TABLE MCUSTOMER
(
CUSTID NUMBER NOT NULL
, CUSTNAME VARCHAR2(20 BYTE)
, CUSTCATEGORY VARCHAR2(20 BYTE)
, CONSTRAINT MCUSTOMER_PK PRIMARY KEY
(
CUSTID
)
ENABLE
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

-------------EQUIPMENT table

CREATE TABLE EQUIPMENT
(
SERIALNO NUMBER NOT NULL
, LASTINSPECTDATE DATE
, DATEMADE DATE
, EQUIPDETAILID VARCHAR2(20 BYTE)
, CONSTRAINT EQUIPMENT_PK PRIMARY KEY
(
SERIALNO
)
ENABLE
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

ALTER TABLE EQUIPMENT
ADD CONSTRAINT EQUIPMENTDETAILID FOREIGN KEY
(
SERIALNO
)
REFERENCES EQUIPMENTDETAIL
(
EQUIPDETAILID
)
ENABLE;

-----------EQUIPMENTDETAIL table

CREATE TABLE EQUIPMENTDETAIL
(
EQUIPDETAILID NUMBER NOT NULL
, MAKE VARCHAR2(20 BYTE)
, TYPE VARCHAR2(20 BYTE)
, MODEL VARCHAR2(20 BYTE)
, CONSTRAINT EQUIPMENTDETAIL_PK PRIMARY KEY
(
EQUIPDETAILID
)
ENABLE
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

------------------ SALE table

CREATE TABLE SALE
(
SALETRANID NUMBER NOT NULL
, PRICE VARCHAR2(20 BYTE) NOT NULL
, DATE_T DATE
, CUSTID VARCHAR2(20 BYTE)
, SERIALNO VARCHAR2(20 BYTE)
, SREPID VARCHAR2(20 BYTE)
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

ALTER TABLE SALE
ADD CONSTRAINT CUSTID FOREIGN KEY
(
SALETRANID
)
REFERENCES MCUSTOMER
(
CUSTID
)
ENABLE;

------------------SALESREP table
CREATE TABLE SALESREP
(
SREQID NUMBER NOT NULL
, SREPLNAME VARCHAR2(20 BYTE)
, SREPFNAME VARCHAR2(20 BYTE) NOT NULL
, RANK NUMBER
, MENTORS_SREPID NUMBER NOT NULL
, CONSTRAINT SALESREP_PK PRIMARY KEY
(
SREQID
)
ENABLE
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

ALTER TABLE SALESREP
ADD CONSTRAINT MENTORS_SREPID FOREIGN KEY
(
SREQID
)
REFERENCES SALESREP
(
SREQID
)
ENABLE;

-------------RENTAL table
CREATE TABLE RENTAL
(
RENTTRANSID NUMBER NOT NULL
, " Price" NUMBER NOT NULL
, RDATE DATE NOT NULL
, SERIALNO NUMBER
, CUSTID NUMBER
, SREPID NUMBER
, CONSTRAINT RENTAL_PK PRIMARY KEY
(
RENTTRANSID
)
ENABLE
)
LOGGING
TABLESPACE "SYSTEM"
PCTFREE 10
PCTUSED 40
INITRANS 1
STORAGE
(
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
);

ALTER TABLE RENTAL
ADD CONSTRAINT CUST_ID FOREIGN KEY
(
RENTTRANSID
)
REFERENCES MCUSTOMER
(
CUSTID
)
ENABLE;

ALTER TABLE RENTAL
ADD CONSTRAINT SERIALNO FOREIGN KEY
(
RENTTRANSID
)
REFERENCES EQUIPMENT
(
SERIALNO
)
ENABLE;

ALTER TABLE RENTAL
ADD CONSTRAINT SREPID FOREIGN KEY
(
RENTTRANSID
)
REFERENCES SALESREP
(
SREQID
)
ENABLE;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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