Description
Investigate how to design a Database
- Read Chapters 3, 4, & 5 of Beginning SQL Server 2012 for Developers
- Watch Lessons 3,4, & 5 in Foundations of Programming: Databases with Simon Allardice
- Read the Data Definition Language from http://www.w3schools.com/sql/. Complete the SQL Create DB through SQL Alter tutorials.
Using the Northwind Database, create an ERD from the database
Explain the create queries that create the database in SQL Server.
Submit the ERD and a document that explains the create queries in a Word Document.
Explanation & Answer
Attached.
Data Masker for SQL Server
Northwind Sample Database - Entity Relationship Diagram
CUSTOMERDEMOGRAPHICS
customertypeid
customerdesc
nchar(10)
ntext
CUSTOMERCUSTOMERDEMO
customerid
customertypeid
nchar(5)
nchar(10)
customerid
companyname
contactname
contacttitle
address
city
region
postalcode
country
phone
fax
SHIPPERS
shipperid
companyname
phone
CUSTOMERS
int
nvarchar(40)
nvarchar(24)
nchar(5)
nvarchar(40)
nvarchar(30)
nvarchar(30)
nvarchar(60)
nvarchar(15)
nvarchar(15)
nvarchar(10)
nvarchar(15)
nvarchar(24)
nvarchar(24)
EMPLOYEES
employeeid
lastname
firstname
title
titleofcourtesy
birthdate
hiredate
address
city
region
postalcode
country
ORDERS
ORDER DETAILS
orderid
productid
unitprice
quantity
discount
int
int
money
smallint
real
orderid
customerid
employeeid
orderdate
requireddate
shipdate
shipvia
freight
shipname
shipaddress
shipcity
shipregion
int
nchar(5)
int
da...