Running Head: MICROSOFT SQL SERVER DATABASE DESIGNS 1Microsoft SQL Server database Designs:Party Kids Database System Design[Student Name][University Name]
CUSTOMERCustomer_ID (PK)FullName Addresses City PostalCode phoneNumber BOOKINGSBooking_ID (PK)BookingDate ItemNameBookingDays TotalAmount CustomerFeedback Customer_ID (FK)M: 1M: MPARTYKIDS DATABASE ER DIAGRAMMICROSOFT SQL SERVER DATABASEDESIGNS2TASK 1 PARTYKIDS DATABASE ENTITY RELETIONAL DIAGRAM.(Raghu , 2015).
MICROSOFT SQL SERVER DATABASEDESIGNS3Table of ContentsTASK 1 PARTYKIDS DATABASE ENTITY RELETIONAL DIAGRAM..................................................................2TASK 2 IMPLEMENTING PARTYKIDS DATABASE...........................................................................................4TASK 2A: creating database and tables, inserting, updating and deleting tables records.......................4TASK 2B :Displaying the database records.............................................................................................11Task 3: Purpose of ER Diagram and Techniques to secure databases.......................................................12Purpose of creating ER Diagram before building the database.............................................................12Legal issue and the techniques to use to secure database....................................................................13Legal issues.......................................................................................................................................13Database security techniques............................................................................................................13References.................................................................................................................................................15
MICROSOFT SQL SERVER DATABASEDESIGNS4TASK 2 IMPLEMENTING PARTYKIDS DATABASETASK 2A: creating database and tables, inserting, updating and deleting tables records/*Task 2a*//*Q1: create database PartyKids*/CREATEDATABASE PartyKids;/*Q1: create table customers*/use partykids;CREATETABLE customers(Customer_ID intNOTNULLPRIMARYKEY,FullName varchar(255)NOTNULL,Addresses varchar(255)NOTNULL,City varchar(255)NOTNULL,PostalCode intNOTNULL,phoneNumber intNOTNULL); (Ullman, 2016)./*Q2: insert values in table customers*/insertinto customers(Customer_ID,FullName,Addresses,City, PostalCode, phoneNumber)values('1','John P Smith','12/1 Flinders St','Melbourne','3000','0718895897'),
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Designs Using Microsoft SQL Server: PartyKid Database Systemlg...
|15
|2060
|494
Database design in microsoft SQL serverlg...
|16
|1798
|49
Database Fundamentals: ER Diagram, SQL Queries, Importance of ER Diagram, Legal Issues and Security Techniqueslg...
|20
|2283
|323
Database Design and Legal Issues - Desklib Reportlg...
|18
|2265
|342
ER Diagram, SQL Queries and Database Security for Deskliblg...