Database concepts using E-R diagram
mrebel989
s3_wa-3.docxConvert the data model you constructed for the Queen Anne Curiosity Shop in part D at the end of Chapter 4 into a relational database design for the Queen Anne Curiosity Shop. Document your database design as follows.
1. (32 points) Given the provided E-R diagram, specify tables, primary keys, foreign keys, and other column properties. You may find this template to be helpful:
|
Table Name |
|||||
|
Column Name |
Data Type |
Key |
Required |
Default Value |
Remarks (Surrogate?) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. (4 points) Describe how you have represented weak entities, if any exist.
1. (4 points) Describe how you have represented supertype and subtype entities, if any exist.
SALE_ITEM is
ID-Dependent
on SALE
ITEM
ItemID
ItemDescription
ReorderPointQuantity
QuantityOnHand
ItemPrice
SALE_ITEM
SaleID
SaleItemID
Quantity
ItemPrice
ExtentedPrice
SALE
SaleID
SaleDate
SubTotal
Tax
Total
VENDOR
VendorID
CompanyName
ContactLastName
ContactFirstName
Address
City
State
ZIP
Phone
Fax
ORDER
InvoiceNumber
DateOrdered
DateReceived
QuantityOrdered
ItemCost
OrderSubTotal
OrderTax
OrderTotalCost
CUSTOMER
PersonID
CreditCardType
CreditCardNumber
CreditCardExpirationDate
EMPLOYEE
PersonID
DateOfHire
HourlyPayRate
PERSON
PersonID
isEmployee
isCustomer
LastName
FirstName
Address
City
State
ZIP
Phone
