
Deliverables
A
B
C
D
E
F
G
final
| Data Tables | |||||
| Customer | Ship Point | Order | SMethod | OrderDetail | CD |
| CustomerID LastName FirstName CompanyName CEmail Password CardNumber CardType CardExpireMo CardExpireYear BAddress1 BAddress2 BCity BState BPostalCode BCountry BPhone Personal Points DateCreated |
ShipID CustomerID SLastName SFirstName SCompanyName SAddress1 SAddress2 SCity SState SPostalCode SCountry SPhone |
OrderID CustomerID OrderDate |
SCost SalesTax SLastName SFirstName SCompanyName SAddress1 SAddress2 SCity SState SPostalCode SCountry SPhone |
OrderDetailID OrderID ItemID Quantity UnitPrice Discount |
CdID Category ShortDescription (Title) LongDescription GroupName LabelName LabelNumber Price |
|
Is_Assigned |
Track | Product | Review | Survey | SurveyDetail |
| CdID RecordingID TrackNumber |
RecordingID SongName Length |
ProductID Category ShortDescription (Title) LongDescription Price |
ReviewID ItemID Rating |
SurveyID Question |
SurveyQuestionID SurveyID SurveyAnswer AnswerCount |