Solution-62003/car.PNG
Solution-62003/customer.PNG
Solution-62003/DMLCar.PNG
Solution-62003/DMLCustomer.PNG
Solution-62003/DMLEmployee.PNG
Solution-62003/DMLShift.PNG
Solution-62003/DMLTransaction.PNG
Solution-62003/Employee.PNG
Solution-62003/Shift.PNG
Solution-62003/SQLServerScript.sql
create table custome
(
cID integer Primary Key identity(1001,1) NOT NULL ,
fName char(10),
lName char(10),
Address char(50),
PostCode varchar(4),
Email varchar(30),
DOB date
);
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values ('Ken','Adams','5 Shipton creek','2064','
[email protected]','1988-04-12');
Insert into Customer(fName,Address,PostCode,Email,DOB)
Values('Ryu','1 Oakwood','3004','
[email protected]','1990-01-18');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Dhal','Sim','8 Ivory lane','5000','
[email protected]','1991-03-07');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Elvis','Honda','2 Bathhouse','2000','
[email protected]','1993-04-17');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Mike','Balrog','9 Club road','3174','
[email protected]','1996-06-21');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Martin','Bison','12 Show Ground','4000','
[email protected]','1990-07-12');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Chun','Li','6 Market street','2000','
[email protected]','1984-09-18');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Zan','Gif','7 Mill View','3010','
[email protected]','1998-02-02');
Insert into Customer(fName,Address,PostCode,Email,DOB)
Values('Sagar','11 Temple wood','3064','
[email protected]','1986-03-01');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Wa
en','Gates','3 Wind Crescent','2000','
[email protected]','1984-09-18');
Insert into Customer(fName,lName,Address,PostCode,Email,DOB)
Values('Jeff','Buffet','9 Chariot...