Database Implementation for PartyKids

Running head: DATABASE IMPLEMENTATION
Database Implementation
Name of the Student:
Name of the University:
Author Note

1
DATABASE IMPLEMENTATION
Task 1
ER Diagram
Task 2
Task 2a
1
PRINT 'Creating database.';
CREATE DATABASE PartyKids;
GO

2
DATABASE IMPLEMENTATION
PRINT 'Creating table Customer ...';
CREATE TABLE Customer (
CustomerID INTEGER NOT NULL IDENTITY ,
CustomerName VARCHAR(45) ,
CustomerAddress VARCHAR(150) ,
PRIMARY KEY(CustomerID));
GO
2
PRINT 'Populating the Customer table'
SET IDENTITY_INSERT [dbo].[Customer] ON
Insert Into Customer(CustomerID,CustomerName, CustomerAddress)
VALUES
(1, 'Cristiano Ronalado', '123 Porto street'),
(2, 'Pedro Rodriguez', 'benson road'),
(3, 'John Smith', '12/1 Flinders St, Melbourne 3000'),
(4, 'Adil Rashid', 'BJ road'),
(5, 'Michael owen', '32 centre street'),

3
DATABASE IMPLEMENTATION
(6, 'Robie Fowler', '45 benton street'),
(7, 'Lionel Messi', '56 avenue road');
SET IDENTITY_INSERT [dbo].[Customer] OFF
GO
3
Select * from Customers;
4
Print 'Updating columns';
UPDATE dbo.Customer
SET CustomerAddress = ' 15/1 Flinders Street'

4
DATABASE IMPLEMENTATION
WHERE CustomerName = 'John P Smith'
GO
Select CustomerName, CustomerAddress From Customer;
5
Select *
From Customer
Where CustomerName LIKE 'J%';

5
DATABASE IMPLEMENTATION
6
Select *
From Customer
Where CustomerAddress LIKE '%3000%';