Amazing T-shirts maintains a significant body of client and sales information in
ID: 457513 • Letter: A
Question
Amazing T-shirts maintains a significant body of client and sales information in its eCommerce system to support it transactional, managerial, and business innovation needs. Complete the following table concerning the design of that database. [1 point]
Data Table
Name
Primary Key (PK) for this Table
2 Other Data Elements – Not the PK - found in this table
Provide
Metadata Definitions for each of these two Data Elements
client table
order table
product
table
graphic design table
Data Table
Name
Primary Key (PK) for this Table
2 Other Data Elements – Not the PK - found in this table
Provide
Metadata Definitions for each of these two Data Elements
client table
order table
product
table
graphic design table
Explanation / Answer
Primary Key (PK) for this Table 2 Other Data Elements – Not the PK - found in this table Provide Data Table Metadata Definitions for each of these two Data Elements Name client table Client ID Client Name First Name of the client Contact Contact numbers - 10 digit mobile numbers order table Order ID Order Date Order date in MM/DD/YY format Order type Prepaid order or COD order product Product ID Product Name Name of the product max 40 characters table Size Size - M / L/ XL/ XXL / XXL graphic design table Design ID Design type Polo / round neck Color color options - biege, red, green, grey, white, black
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.