Identify and describe primary and foreign keys.

The Trade Master company sells various tools. It has sales offices and warehouses all over Australia. The company developed a data warehouse to store information about sales, customers and products. These data are stored in the AppliedProject2 Access file provided for you.
The database consists of 6 tables:
• CompanyDim — with the sales office address, state and email • ProductDim — product information • WarehouseDim — warehouse locations • CustomerDim — information about customers • DateDim — sales dates • SaleFacts — information about sales
Please notice that all data (customers, sales, dates, warehouses and products) are randomly generated. Table and field names are self-explanatory.
The Global Trading company wants to retrieve information from the database for reporting and data analysis.
You have to do the following tasks
1. In the MS Word document: 1.1. Analyse and describe the tables. 1.2. Describe the dimension and fact tables. (You need to remember that the database tables are organised into a fact and dimension tables, and this structure is called a database star schema). 1.3. Identify and describe primary and foreign keys. 1.4. Describe relationships and cardinalities between the tables 1.5. Draw the database ER diagram with primary keys, foreign keys, relationships and cardinalities. 1.6. Copy from the database all queries to the Word document and explain them.

find the cost of your paper

set up and solve a case-study example of the light-intensity distribution in a photochemical reactor.

Photochemical reactor modeling: a case-study problem. Although radiation is important in heat transfer, an analogous model can be used in the design of photochemical reactors. The modeling of these reactors….

Write a critique on this technique of secondary-emission measurement.

Secondary-emission measurement: a case-study problem. An indirect way of measuring of secondary emission from ponds or large bodies of water used in waste treatment is to measure the concentration and….

set up a mass transfer model and evaluate the variation of the local mass transfer coefficient at various locations in the plate.

Chemical vapor deposition (CVD) on an inclined susceptor: a case-study problem. An important application of convective mass transfer theory is in CVD processes employed to coat surfaces with thin films….