Database Creation and Management for PartyKids

COVER PAGE

Task 1
Assumptions
A booking can have one or more items booked for that single booking.

Task 2
Task 2a
1. Create database
/*Gaurav- st id 40773 creating database */
Create database partykids;
/* Gaurav- st id creating database*/
use partykids;
create table customer (
customerID smallint not null primary key,
firstname nvarchar(50) not null,
lastname nvarchar(50) not null,
address nvarchar(50) not null
);

2. Insert statements
/*Gaurav-st id 40773 Inserting record 1*/
use partykids;
insert into customer VALUES(1,'John p','Smith','12/1 Flinders St, Melbourne
3000');
/*Gaurav-st id 40773 inserting records*/
insert into customer VALUES(2,'Angelina','Jolie','12/1 Flinders St, Melbourne
2000');

--Gaurav-st id 40773 inserting records
use partykids;
insert into customer VALUES(3,'Peter','Parker','12/2 Flinders St,
Melbourne 1000');
--Gaurav-st id 40773 inserting records
use partykids;
insert into customer VALUES(4,'Will','Smith','12/2 Flinders St, Melbourne
1000');

/*Gaurav-st id 40773 inserting records*/
use partykids;
insert into customer VALUES(6,'Jon','Snow','13/2 Flinders St, Melbourne
3000');
--Gaurav-st id 40773 inserting records
insert into customer VALUES(7,'Brianne','Tarth','13/2 Flinders St,
Melbourne 3000');