Creating and Modelling a Database for Partykids Business

COVER PAGE

Task 1
Assumptions
A booking consists of one or more items.

Task 2
Task 2a
1. Create database
create database partykids;
--Amandep singh – 40564
Creating customer table
create table customer (
customerID smallint not null primary key,
firstname nvarchar(50) not null,
lastname nvarchar(50) not null,
address nvarchar(50) not null
);
--Amandep singh - 40564

2. Insert statements
insert into customer VALUES(1,'John p','Smith','12/1 Flinders St, Melbourne
2000');
--Amandep singh - 40564