Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --drop tables
- DROP TABLE BIKERECORD;
- DROP TABLE PART;
- DROP TABLE MANUFACTURERPART;
- DROP TABLE MAINTAINANCE;
- DROP TABLE DEALER;
- DROP TABLE MANUFACTURER;
- DROP TABLE RENTAL;
- DROP TABLE RESERVATION;
- DROP TABLE CUSTOMER;
- --Create Tables
- CREATE TABLE CUSTOMER ( --works
- CustomerID NUMBER(9) NOT NULL,
- CustomerName VARCHAR2(30) NOT NULL,
- CustomerAddress VARCHAR2(80) NOT NULL,
- Postcode VARCHAR2(7),
- CustomerNo VARCHAR2(11),
- PRIMARY KEY(CustomerID)
- );
- CREATE TABLE RESERVATION ( -- doesnt work
- ReservationNo NUMBER(9) NOT NULL,
- CustomerID NUMBER(9) NOT NULL,
- BikeNo NUMBER(9) NOT NULL,
- BikeClass VARCHAR2(15) NOT NULL,
- BikeSize VARCHAR2(20) NOT NULL,
- RentDate DATE,
- PRIMARY KEY(ReservationNo),
- FOREIGN KEY(CustomerID) REFERENCES CUSTOMER(CustomerID),
- FOREIGN KEY(BikeNo) REFERENCES BIKERECORD(BikeNo)
- );
- CREATE TABLE RENTAL ( -- doesnt work
- RentID NUMBER(9) NOT NULL,
- BikeNo NUMBER(9) NOT NULL,
- CustomerID NUMBER(9) NOT NULL,
- RentDate DATE,
- CustomerName VARCHAR2 (30) NOT NULL,
- CustomerAddress VARCHAR2(80) NOT NULL,
- PostCode VARCHAR2(7) NOT NULL,
- PhoneNo VARCHAR2(11),
- BikeClass VARCHAR2(9) NOT NULL,
- BikeSize VARCHAR2(15) NOT NULL,
- Price NUMBER(6,2) NOT NULL,
- PRIMARY KEY(RentID),
- FOREIGN KEY(CustomerID) REFERENCES CUSTOMER(CustomerID),
- FOREIGN KEY(BikeNo) REFERENCES BIKERECORD(BikeNo)
- );
- CREATE TABLE MANUFACTURER( -- works
- ManufacturerID NUMBER(9) NOT NULL,
- ManuAddress VARCHAR2(80) NOT NULL,
- ManuPostcode VARCHAR2(7) NOT NULL,
- ManuTelephone VARCHAR2(11) NOT NULL,
- PRIMARY KEY(ManufacturerID)
- );
- CREATE TABLE DEALER( --works
- DealerID NUMBER(9) NOT NULL,
- DealerName VARCHAR2(30) NOT NULL,
- DealerAddress VARCHAR2(80),
- DealerNo VARCHAR2(11) NOT NULL,
- PRIMARY KEY(DealerID)
- );
- CREATE TABLE MAINTAINANCE ( --doesnt work
- MaintainanceID NUMBER(9) NOT NULL,
- BikeNo NUMBER(9) NOT NULL,
- LastService DATE,
- FaultDate DATE,
- FaultDetails VARCHAR2(250) NOT NULL,
- ActionTaken VARCHAR2(250) NOT NULL,
- ActionDate DATE,
- PRIMARY KEY(MaintainanceID),
- FOREIGN KEY(BikeNo) REFERENCES BIKERECORD(BikeNo)
- );
- CREATE TABLE MANUFACTURERPART ( --doesnt work
- ManufacturerID NUMBER(9) NOT NULL,
- PartID NUMBER(9) NOT NULL,
- Price NUMBER(6,2) NOT NULL,
- PRIMARY KEY (ManufacturerID),
- FOREIGN KEY (ManufacturerID) REFERENCES MANUFACTURER(ManufacturerID),
- FOREIGN KEY (PartID) REFERENCES PART(PartID)
- );
- CREATE TABLE PART ( --works
- PartID NUMBER(9) NOT NULL,
- Supplier VARCHAR2(30),
- Quantity NUMBER(3) NOT NULL,
- PartModel VARCHAR2(15) NOT NULL,
- PartClass VARCHAR2(9) NOT NULL,
- PRIMARY KEY(PartID)
- );
- CREATE TABLE BIKERECORD ( --works
- BikeNo NUMBER(9) NOT NULL,
- ModelID NUMBER(9) NOT NULL,
- ManufacturerID NUMBER(9) NOT NULL,
- DatePurchased DATE,
- Price NUMBER(6,2),
- BikeClass VARCHAR2(9),
- BikeSize VARCHAR2 (15),
- DealerID NUMBER(9) NOT NULL,
- PRIMARY KEY(BikeNo),
- FOREIGN KEY(ManufacturerID) REFERENCES MANUFACTURER(ManufacturerID),
- FOREIGN KEY(DealerID) REFERENCES DEALER(DealerID)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement