Ask a question from expert

Ask now

Microsoft SQL Server Database Designs

15 Pages1734 Words98 Views
   

Added on  2021-05-31

Microsoft SQL Server Database Designs

   Added on 2021-05-31

BookmarkShareRelated Documents
Running Head: MICROSOFT SQL SERVER DATABASE DESIGNS 1Microsoft SQL Server database Designs:Party Kids Database System Design[Student Name][University Name]
Microsoft SQL Server Database Designs_1
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 Database Designs_2
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 Database Designs_3
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'),
Microsoft SQL Server Database Designs_4

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 System
|15
|2060
|494

Database design in microsoft SQL server
|16
|1798
|49

Database Fundamentals: ER Diagram, SQL Queries, Importance of ER Diagram, Legal Issues and Security Techniques
|20
|2283
|323

Database Design and Legal Issues - Desklib Report
|18
|2265
|342

ER Diagram, SQL Queries and Database Security for Desklib
|15
|1974
|437

Database Implementation for PartyKids
|21
|1513
|397