logo

Database design in microsoft SQL server

16 Pages1798 Words49 Views
   

Added on  2021-05-31

Database design in microsoft SQL server

   Added on 2021-05-31

ShareRelated Documents
Running Head: DATABASE DESIGN IN MICROSOFT SQL SERVER 1Designing Database in Microsoft SQL Server:Party-Kids Database System[Student Name][University Name]
Database design in microsoft SQL server_1
DATABASE DESIGN IN MICROSOFT SQLSERVER2Table of Contents1Task 1 Entity relational diagram..........................................................................................................32TASK 2 Database implementation.......................................................................................................42.1Task 2A: Creating database and tables and performing insert, update and delete operations ontables42.2TASK 2B: Retriving various database tables records..................................................................113Task 3: Purpose of ER Diagram and Techniques to secure databases................................................133.1Purpose of creating ER Diagram before building the database..................................................133.2Legal issue and the techniques to use to secure database........................................................143.2.1Legal issues........................................................................................................................143.2.2Security techniques............................................................................................................144References.........................................................................................................................................16
Database design in microsoft SQL server_2
CUSTOMERSCustomerID <PK>Names PostalAddress Town Postal_Code ContactNumberBOOKINGBookingID <PK>Book_Date Item_Name DaysBookedAmount Customer_Feedback CustomerID <FK>1: MM: MTHE DATABSE ENTITY RELETIONAL DIAGRAMDATABASE DESIGN IN MICROSOFT SQLSERVER31Task 1 Entity relational diagram(Abraham, 2013).
Database design in microsoft SQL server_3
DATABASE DESIGN IN MICROSOFT SQLSERVER42TASK 2 Database implementation2.1Task 2A: Creating database and tables and performing insert, update and delete operations on tables/*Task 2a Implementation Solutions*//*Q1: creating database Party-Kids*/CREATEDATABASE Party_Kids;/*Q1: creating table called customers*/use party_kids;CREATETABLE customers (CustomerID intNOTNULLPRIMARYKEY,Names varchar(255)NOTNULL,PostalAddress varchar(255)NOTNULL,Town varchar(255)NOTNULL,Postal_Code intNOTNULL,ContactNumber intNOTNULL);
Database design in microsoft SQL server_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

Microsoft SQL Server Database Designs
|15
|1734
|98

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

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

Database Implementation for PartyKids
|21
|1513
|397

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