Question: Carefully review the data. Notice the different sheets ( sales , products, categories, and locations ) contain company - related data. sales: transactional data of
Carefully review the data. Notice the different sheets sales products, categories, and locations contain companyrelated data.
sales: transactional data of sales activities. Format the data as a Table and name the table tbl Sales. Add the table to the Data Model
products: description of the company's products. Format the data as a Table and name the table tbl Products. Add the table to the Data Model
categories: description of the products categories. Format the data as a Table and name the table tbl Categories. Add the table to the Data Model
locations: description of the locations where the company has operations. Format the data as a Table and name the table tbl Locations. Add the table the
Data Model
Since the data is organized in a "database" format, create relationships between the different tables to associate the data in the file. In total, three relationships
need to be created. HINT: make sure to carefully review the data before creating the relationships
Note: No need to upload any files at this point. Make sure to save your work.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
