INF10002Task 5 1Task 5 - Credit Submission Student Number: 102875459 Student Name: Ibrahim Afzal Credit 5a Paste your screen capture(s) for this task here. Credit 5b Paste your screen capture(s) for this task here.
INF10002Task 5 2Credit 5c Paste your screen capture(s) for this task here. CLIENT (ClientID, Name) Primary Key (ClientID) Motorcycle (VIN, Make, Model, YOM, EngCap) Primary Key (VIN) ServiceRecord (ClientID, VIN, Date, ServiceLoc, TotalCost, Task, PartQty, PartPrice) Primary Key (ClientID, VIN) Foreign Key (ClientID) references CLIENT Foreign Key (VIN) references Motorcycle Credit 5d Paste your screen capture(s) for this task here. CREATE TABLE CLIENT ( CLIENTID NUMBER , NAME VARCHAR(30) , PRIMARY KEY (CLIENTID) ); CREATE TABLE MOTORCYCLE ( VIN VARCHAR(30) , MAKE VARCHAR(30) , MODEL VARCHAR(50)
INF10002Task 5 3, YOM YEAR , ENGCAP NUMBER , PRIMARY KEY (VIN) ); CREATE TABLE SERVICERECORD ( CLIENTID NUMBER , VIN VARCHAR(30) , DATE DATE , SERVICELOC VARCHAR(30) , TOTALCOST NUMBER , TASK VARCHAR(50) , PARTQTY VARCHAR(30) , PARTPRICE NUMBER , PRIMARY KEY (CLIENTID, VIN) , FOREIGN KEY (CLIENTID) references CLIENT , FOREIGN KEY (VIN) references MOTORCYCLE ); Credit 5e Paste your screen capture(s) for this task here. CustIdNamePhone 125John Coles0401112233 278Erin Trump0466121455 721Emma Knox0423544117 CarRegoMakeModel 1AU8HKMazda 3 1LM3ABHyundai i30 1KA2CAToyota Camry 1CZ8JKMazda 3
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order Now
Get Online
Assignment Help Services
