In Oracle, Generate ERD Diagram for Dreamhome and Paste results in this format/S

Question

In Oracle, Generate ERD Diagram for Dreamhome and Paste results in this format/Style

HR. JOB HISTORY HR. JOBS PF EMPLOYEE ID P START DATE END DATE NUMBER () DATE DATE VARCHAR2 (10 BYTE) JOB ID VARCHAR2 (10 BYTE) JOB TITLE VARCHAR2 (35 BYTE) MIN SALARY NUMBER (8) MAX SALARY NUMBER() JOB ID DEPARTMENT ID NUMBER (4) JHIST EMP ID ST DATE PK JHIST EMPLOYEE IX JOB ID PK JHIST-JOB-IX HR.EMPLOYEES HIST-DEPARTMENT-IX EMPLOYEE ID FIRST NAME LAST-NAME EMAIL PHONE NUMBER VARCHAR2 HIRE DATE NUMBER () VARCHAR2 (20 BYTE VARCHAR2 (25 BYTE) VARCHAR2 (25 BYTE) · HR. DEPARTMENTS DEPARTMENTD DEPARTMENT NAME VARCHAR2 (30 BYTE MANAGER ID LOCATION ID DEPT ID PK DEPTLOCATIONLX NUMBER (4) DATE VARCHAR2 (10 BYTE) NUMBER (8.2) JOB ID NUMBER () NUMBER (4) SALARY COMMISSION PCT NUMBER (2.2) F MANAGER ID NUMBER (6) F DEPARTMENT ID NUMBER (4) - - EMP-EMAIL-UK EMP EMP ID PK EMP DEPARTMENT EMP-JOB-IX EMP-MANAGER-IX EMP-NAME-IX HR.LOCATIONS X P LOCATIONID NUMBER (4) STREET ADDRESS VARCHAR2 (40 BYTE) POSTAL CODE CITY STATE PROVINCE VARCHAR2 (25 BYTE) COUNTRY ID VARCHAR2 (12 BYTE) VARCHAR2 (30 BYTE) CHAR (2 BYTE) LOC ID PK LOC-CITY IX LOC STATE PROVINCE X LOC COUNTRY X HR.COUNTRIES COUNTRY ID CHAR 2 BYTE) COUNTRY NAME VARCHAR2 (40 BYTE) F REGION ID NUMBER HR.REGIONS COUNTRY C ID PK REGION ID REGION NAME VARCHAR2 (25 BYTE REG ID PK NUMBER

Explanation / Answer

CREATE TABLE branch ( branchno char(5) NOT NULL, street varchar(35) DEFAULT NULL, city varchar(10) DEFAULT NULL, postcode varchar(10) DEFAULT NULL, PRIMARY KEY (branchno) ); CREATE TABLE staff ( staffno char(5) NOT NULL, fname varchar(10) DEFAULT NULL, lname varchar(10) DEFAULT NULL, position varchar(10) DEFAULT NULL, sex char(1) DEFAULT NULL, dob date DEFAULT NULL, salary smallint DEFAULT NULL, branchno char(5) DEFAULT NULL, PRIMARY KEY (staffno), FOREIGN KEY(BranchNo) REFERENCES Branch(BranchNo) ON DELETE CASCADE ); CREATE TABLE privateowner ( ownerno char(5) NOT NULL, fname varchar(10) DEFAULT NULL, lname varchar(10) DEFAULT NULL, address varchar(50) DEFAULT NULL, telno char(15) DEFAULT NULL, email varchar(25) DEFAULT NULL, password varchar(12) DEFAULT NULL, PRIMARY KEY (ownerno) ); CREATE TABLE propertyforrent ( propertyno char(5) NOT NULL, street varchar(35) DEFAULT NULL, city varchar(10) DEFAULT NULL, postcode varchar(10) DEFAULT NULL, type varchar(10) DEFAULT NULL, rooms smallint DEFAULT NULL, rent int DEFAULT NULL, ownerno char(5) DEFAULT NULL, staffno char(5) DEFAULT NULL, branchno char(5) DEFAULT NULL, PRIMARY KEY (propertyno), FOREIGN KEY(StaffNo) REFERENCES staff(StaffNo), FOREIGN KEY(OwnerNo) REFERENCES PrivateOwner(OwnerNo) ON DELETE CASCADE, FOREIGN KEY(branchno) REFERENCES branch(branchno) ON DELETE CASCADE ); CREATE TABLE client ( clientno char(5) NOT NULL, fname varchar(10) DEFAULT NULL, lname varchar(10) DEFAULT NULL, telno char(15) DEFAULT NULL, preftype varchar(10) DEFAULT NULL, maxrent int DEFAULT NULL, eMail varchar(25) DEFAULT NULL, PRIMARY KEY (clientno) ); CREATE TABLE registration ( clientNo char(5) NOT NULL, branchNo char(5) NOT NULL, staffNo char(5) DEFAULT NULL, dateJoined date DEFAULT NULL, PRIMARY KEY (clientNo,branchNo), FOREIGN KEY(BranchNo) REFERENCES Branch(BranchNo) ON DELETE CASCADE, FOREIGN KEY(ClientNo) REFERENCES Client(ClientNo) ON DELETE CASCADE ) ; CREATE TABLE viewing ( clientno char(5) NOT NULL, propertyno char(5) NOT NULL, viewdate date DEFAULT NULL, comment1 varchar(15) DEFAULT NULL, PRIMARY KEY (clientno,propertyno), FOREIGN KEY(ClientNo) REFERENCES Client(ClientNo) ON DELETE CASCADE, FOREIGN KEY(PropertyNo) REFERENCES PropertyForRent(PropertyNo) ON DELETE CASCADE ); INSERT INTO branch (branchno, street, city, postcode) VALUES ('B005', '22 Deer Rd', 'London', 'SW1 4EH'); INSERT INTO branch (branchno, street, city, postcode) VALUES ('B007', '16 Argyll St', 'Aberdeen', 'AB2 3SU'); INSERT INTO branch (branchno, street, city, postcode) VALUES ('B003', '163 Main St', 'Glasgow', 'G11 9QX'); INSERT INTO branch (branchno, street, city, postcode) VALUES ('B004', '32 Manse Rd', 'Bristol', 'BS99 1NZ'); INSERT INTO branch (branchno, street, city, postcode) VALUES ('B002', '56 Clover Dr', 'London', 'NW10 6EU'); INSERT INTO client (clientno, fname, lname, telno, preftype, maxrent, eMail) VALUES ('CR76', 'John', 'Kay', '0207-774-5632', 'Flat', 425, 'john.kay@gail.com'); INSERT INTO client (clientno, fname, lname, telno, preftype, maxrent, eMail) VALUES ('CR56', 'Aline', 'Stewart', '0141-848-1825', 'Flat', 350, 'astewart@hotmail.com'); INSERT INTO client (clientno, fname, lname, telno, preftype, maxrent, eMail) VALUES ('CR74', 'Mike', 'Ritchie', '01475-392178', 'House', 750, 'mritchie01@yahoo.co.uk'); INSERT INTO client (clientno, fname, lname, telno, preftype, maxrent, eMail) VALUES ('CR62', 'mary', 'tregear', '01224-196720', 'Flat', 600, 'maryt@hotmail.co.uk');

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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