Database Fundamental: Creating and Managing a Party Rental Database

Name Gurpreet singh
student id 40738
Database fundamental

Task 1
Assumptions
A customer can book more than one item in one single booking thus a booking has one or more items.

Task 2
Task 2a
1. Create statemets
/*Gurpreet singh-40738 creating database*/
create database partykids;
/*Gurpreet singh-40738 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
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(1,'John p','Smith','12/1 Flinders St, Melbourne
3000');

/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(2,'Lebron','James','12/1 Flinders St,
Melbourne 2000');
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(3,'Tristan','THompson','12/2 Flinders St,
Melbourne 1000');
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(4,'Peter','Griffin','13/2 Flinders St,
Melbourne 3000');
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(5,'Lois','Griffin','13/2 Flinders St,
Melbourne 3000');
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(6,'Meeg','Griffin','13/2 Flinders St,
Melbourne 3000');
/*Gurpreet singh-40738 Inserting record 1*/
use partykids;
insert into customer VALUES(7,'Brian','Griffin','13/2 Flinders St,
Melbourne 3000');