Question

I want the create table sql from the below ER Diagram -

Invoice Insurance insurancelD (PK) cyType invoicelD (PK) eck datePaid VehicleType rentalPrice /finalCost make (PK) model (PK) DailyTariff 0..1 1.1 0..1 rs 0.." tariffID (PK) bodh conditions policyNumber Records trim Generated for 1..1 1..1 Tariffs Has a Insures PersonalClient 0.. 1..1 Hired 0 Vehicle 0. HiredVehicle 1 1-1 na ame regNum (PK) date (PK) IName fleetNum cardType title 11 Nominate driversNum Ca Client kilometrage Schedules 0 1.1 days 1.1 1..1 clientiD (PK) 1.1 address KA Represents ScheduledService street pickup at Hires 0.1 date (PK) Keeps Returns To kilometrage CompanyClient ..1 Scheduled For 1-1 ..1 cName 1 1 Has Available Makes (MANDATORY, OR 0..1 Depot Pickup at 0.* 0. depotiD PK) Booking 11 0* ar ServiceHistory startDate (PK) hireDays colour postcode phone [14 date (PK 1.1 Activate Windows Booked fax Serviced at ription Go to Settings to activate W 0

Answer 1

CREATE TABLE VEHICLETYPE(MAKE INT,
                       TYPE VARCHAR(10),
                       PRIMARY KEY(MAKE,TYPE),
                       DOORS INT,
                       BODY VARCHAR(10),
                       TRIM VARCHAR(10));
                      
CREATE TABLE VEHICLE(REGNUM INT PRIMARY KEY,
                   FLEETNUM INT,
                   COLOR VARCHAR(10));
                     
CREATE TABLE SERVICEHISTORY(DATE_OF_SERVICE DATE PRIMARY KEY,
                           COST NUMBER(6,2),
                           DESCRIPTION VARCHAR(20));
                          
CREATE TABLE DAILYTARIFF(TARIFFID INT PRIMARY KEY,
                       CONDITIONS VARCHAR(20));
                      
CREATE TABLE HIREDVEHICLE(DATE_OF_HIRE DATE PRIMARY KEY,
                           CARDTYPE VARCHAR(20),
                           CARDNO INT,
                           KILOMETRAGE INT,
                           DAYS INT);
                          
                          
CREATE TABLE DEPOT(DEPOTID INT PRIMARY KEY,
                   ADDRESS VARCHAR(20),
                   STREET VARCHAR(20),
                   POSTCODE INT,
                   PHONE NUMBER(4),
                   FAX VARCHAR(10));
                  
CREATE TABLE INVOICE(INVOICEID INT PRIMARY KEY,
                   QUALITYCHECK VARCHAR(20),
                   DATEPAID DATE,
                   FINALCOST INT);
                  
                  
CREATE TABLE CLIENT(CLIENTID INT PRIMARY KEY,
                   ADDRESS VARCHAR(20),
                   STREET VARCHAR(20),
                   POSTCODE INT,
                   PHONE NUMBER(4));
                  
CREATE TABLE BOOKING(STARTDATE DATE PRIMARY KEY,
                   HIREDAYS INT,
                   COLOUR VARCHAR(20));
                  
CREATE TABLE INSURANCE(INSURANCID INT PRIMARY KEY,
                       POLICTYPE VARCHAR(10),
                       COST INT);

CREATE TABLE PERSONALCLIENT(NAME VARCHAR(20),
                           FNAME VARCHAR(10),
                           LNAME VARCHAR(10),
                           TITLE VARCHAR(20),
                           DRIVERSNUM INT);

CREATE TABLE COMPANYCLIENT(CNAME VARCHAR(20));     

SQL> CREATE TABLE VEHICLETYPE (MAKE INT, TYPE UARCHAR(10), PRIMARY KEY(MAKE ,TYPE) DOORS INT BODY UARCHAR(10), TRIM UARCHAR(10)); 2 3 Table created SOL> SQL> CREATE TABLE UEHICLE(REGNUM INT PRIMARY KEY, FLEETNUM INT COLOR UARCHAR(10)); 2 Table created SQL> SOL> CREATE TABLE SERVICEHISTORY(DATE_OF_SERUICE DATE PRIMARY KEY, COST NUMBER(6,2), DESCRIPTION UARCHAR(20)); 2 3 Table created SQL> SQL> CREATE TABLE DAILYTARIFF(TARIFFID INT PRIMARY KEv, 2 CONDITIONS UARCHAR(20)); Table created SQL> SQL> CREATE TABLE HIREDUEHICLE(DATE_OF_HIRE DATE PRIMARY KEY, CARDTYPE UARCHAR(20), CARDNO INT KILOMETRAGE INT, DAYS INT) 2 3 Table created

SQL> SQL> CREATE TABLE DEPOT(DEPOTID INT PRIMARY KEY, ADDRESS UARCHAR(20), STREET UARCHAR(20), POSTCODE INT, PHONE NUMBER(4), FAX UARCHAR(10)); 2 3 6 Table created SQL> SQL> CREATE TABLE INUOICE(INUOICEID INT PRIMARY KEY, 2 QUALITYCHECK UARCHAR(20), DATEPAID DATE FINALCOST INT); 3 Table created SQL> SQL> SQL> CREATE TABLE CLIENT(CLIENTID INT PRIMARY KEY, ADDRESS UARCHAR (20) STREET UARCHAR(20), POSTCODE INT, PHONE NUMBER(4)); 2 3 Table created SQL> SQL> CREATE TABLE BOOKING(STARTDATE DATE PRIMARY KEY, 2 HIREDAYS INT, COLOUR UARCHAR(20)); 3 Table created SQL> SQL> CREATE TABLE INSURANCE(INSURANCID INT PRIMARY KEv, POLICTYPE UARCHAR(10), COST INT) 2 3 Table created. Ln N LY

SQL> SQL> CREATE TABLE PERSONALCLIENT(NAME UARCHAR(20), FNAME UARCHAR(10), LNAME UARCHAR(10), TITLE UARCHAR(20), DRIUERSNUM INT); 5 Table created SQL> SOL> CREATE TABLE COMPANYCLIENT (CNAME UARCHAR(20)); Table created. N C Ln