Database Designs Using Microsoft SQL Server: PartyKid Database System

Running Head: 1
Database Designs Using Microsoft SQL Server:
PartyKid Database System
[Student’s Name]
[University’s Name]

DATABASE DESIGNS USING MICROSOFT SQL SERVER 2
Table of Contents
Task.1: Entity relational diagram.................................................................................................................3
TASK.2: Database implementations............................................................................................................4
Task 2.A: Create database and tables and perform inserting, updating and deleting operations on
tables.......................................................................................................................................................4
TASK 2.B: Retriving various database tables records.............................................................................10
Task 3: Purposes of E-R-Diagram and Techniques to secure databases....................................................11
The purpose to create an ER Diagram before the database is built.......................................................11
Legal issues and the techniques to use in order to secure databases...................................................12
Legal issues........................................................................................................................................12
Security techniques...........................................................................................................................13
References.................................................................................................................................................15

CUSTOMERS
CustomerIDs <PK>
Full_Names
Postal_Addresses
Town_Name
Postal_Codes
Contacts_Number
BOOKING
Booking_IDs <PK>
Book_Date
Items_Names
Days_Booked
Total_Amount
Customers_Feedbacks
CustomerIDs <FK>
1: M
M: M
THE DATABSES ENTITY RELETION DIAGRAMS
DATABASE DESIGNS USING MICROSOFT SQL SERVER 3
Task.1: Entity relational diagram
(Abraham, 2013).

DATABASE DESIGNS USING MICROSOFT SQL SERVER 4
TASK.2: Database implementations
Task 2.A: Create database and tables and perform inserting, updating and
deleting operations on tables.
/*Tasks 2.a Implementing Solution*/
/*Q.1: create database PartyKid*/
CREATE DATABASE Partykid;
/*Q.1: create table called customer*/
use partykid;
CREATE TABLE customer (
CustomerIDs int NOT NULL PRIMARY KEY,
Full_Names varchar(255) NOT NULL,
Postal_Addresses varchar(255) NOT NULL,
Town_Name varchar(255) NOT NULL,
Postal_Codes int NOT NULL,
Contacts_Number int NOT NULL);