Database Fundamentals: ER Diagram, Tables, and Queries

Running head: DATABASE FUNDAMENTALS
ITDA1001 - Database Fundamentals
Name of the Student:
Name of the University:
Author Note

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

2
DATABASE FUNDAMENTALS
PRINT 'Creating table Customer ...';
CREATE TABLE Customer (
CustomerID INTEGER NOT NULL IDENTITY ,
CustomerName VARCHAR(45) ,
CustomerAddress VARCHAR(150) ,
PRIMARY KEY(CustomerID));
GO

3
DATABASE FUNDAMENTALS
2
PRINT 'Populating the Customer table'
SET IDENTITY_INSERT [dbo].[Customer] ON
Insert Into Customer(CustomerID,CustomerName, CustomerAddress)
VALUES
(1, 'Rayan Renolds', '123 denver street'),
(2, 'kevin spacey', '123 lee road'),
(3, 'John P Smith', '12/1 Flinders St, Melbourne 3000'),
(4, 'Phillip Lahm', 'BJ road'),
(5, 'Kevin Owens', '32 centre street'),

4
DATABASE FUNDAMENTALS
(6, 'Robie Fowler', '45 benton street'),
(7, 'Lionel Messi', '56 avenue road');
SET IDENTITY_INSERT [dbo].[Customer] OFF
GO
3
Select * from Customer;

5
DATABASE FUNDAMENTALS
4
Print 'Updating columns';
UPDATE dbo.Customer
SET CustomerAddress = ' 15/1 Flinders Street'
WHERE CustomerName = 'John P Smith'
GO
Select CustomerName, CustomerAddress From Customer;