This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: OPERATOR CLIENT VEHICLE ITEM COURIER COURIER ITEM CLIENT OPERATOR VEHICLE CREATE TABLE OPERATOR (COURIERID CHAR(8) PRIMARY KEY, CLIENTID CHAR(8) PRIMARY KEY,); CREATE TABLE ITEM (ITEMID CHAR(8) PRIMARY KEY, WEIGHT VARCHAR(10), SIZE VARCHAR(10), DETAIL VARCHAR(50)); CREATE TABLE VEHICLE (VEHICLEID CHAR(8) PRIMARY KEY, VEHNAME VARCHAR(50), SIZE VARCHAR(10), CAPACITY VARCHAR(10)); Sit 103 COURIERID COURIERID+ CLIENTID ITEMID SURNAME CLIENTID SURNAME WEIGHT GIVENAME TELEPHONE NUMBER SIZE TELEPHONE NUMBER PICKUP ADDRESS DETAIL ADDRESS DELIVERY ADDRESS SEX DATE OF BIRTH DATE OF BIRTH SEX START TIME GIVENAME FINISH TIME CLIENTID ITEMID VEHICLEID VEHICLEID VEHICLE NAME SIZE CAPACITY CREATE TABLE COURIER (COURIERID CHAR(8) PRIMARY KEY, SURN VARCHAR(50), GIVEN VARCHAR(50), TELNUM VARCHAR(50), ADD VARCHAR(50), SEX SEX, DOB DATE, START DATETIME, FINISH DATETIME, CLIENTID CHAR(8), ITEMID CHAR(8), VEHICLEID CHAR(8) FOREIGN KEY (CLIENTID) REFERENCES CLIENT (CLIENTID) FOREIGN KEY (ITEMID) REFERENCES ITEM (ITEMID) FOREIGN KEY (VEHICLEID) REFERENCES VEHICLE (VEHICLEID)); CREATE TABLE CLIENT (CLIENTID CHAR(8) PRIMARY KEY , SURN VARCHAR(50), GIVEN VARCHAR(50), TELNUM VARCHAR(50), PICADD VARCHAR(50), DELADD VARCHAR(50), DOB DATE, SEX SEX); In this diagram, I made five tables. The COURIER relate to ITEM AND VEHICLE. The CLIENT relate to ITEM. The COURIER AND CLIENT was been related by OPERATOR. The duration of time means start time subtract finish time. The courier and client was known each other because the operator. The couriers went to the pickup address and pick up the item form the client and deliver to the delivery address. delivery address....
View Full Document
This note was uploaded on 10/03/2011 for the course SIT 202 taught by Professor Robindoss during the Three '09 term at Deakin.
- Three '09