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 company-related 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.
Carefully review the data. Notice the different

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!