Northern Virginia Community College how To Design a Database Paper

User Generated

xunyvsn20

Business Finance

Northern Virginia Community College

Description

Investigate how to design a Database

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...

Related Tags