rade Master company sells various tools

FIND A SOLUTION AT Academic Writers Bay

Assessment 3: Applied Project-2
Due date:
Week 12
Group/individual:
individual
Word count / Time provided:
2500 words
Weighting:
30%
Unit Learning Outcomes:
ULO-1, ULO-2, ULO-3, ULO-4
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 must do the following tasks
In the MS Word document:
Analyse and describe the tables. 
Describe dimension and fact tables. (You need to remember that the Data Warehouse tables are organised into a fact and dimension tables, and this structure is called a database star schema).
Identify and describe primary and foreign keys.
Draw the database diagram. 
Copy from the database all queries to the Word document and explain them.

READ ALSO...   Clinical Case Study Evaluation and Treatment Plan

In the SQLite Browser, you need to write, save and run the following SQL queries:
Create all primary and foreign keys.
Insert a new customer. Devise your own data for this record.
Create a new sale fact related to the new customer. You can choose any existing product, warehouse, date and sales office.
Display all customer names, their addresses and states.
Display all customer names from Victoria.
Display the total amount of all company sales in 2018.
Display total amount of sales for each product separately.
Display total amount of sales for each product and state separately, i.e. the output should contain 3 columns: product, state and total amount for this product and state.
Display products sold from warehouses located in Victoria.
For each sale, display a customer name and a purchase date.
Display a total number of sales (NOT AMOUNT!) for each customer.
For each sales office (branch), display: branchKey, branch state, a customer name (a customer purchased in this office), a product name purchased by this customer, and a month number of the purchase.

 Your submission should consist of the following documents: 
MS Word document  containing answers to the Task 1
SQLite Browser file with stored SQL queries from Task 2
Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 30% of the total unit mark
Marking Criteria
Not satisfactory (0-49%) of the criterion mark)
Satisfactory (50-64%) of the criterion mark
Good (65-74%) of the criterion mark
Very Good (75-84%) of the criterion mark
Excellent (85-100%) of the criterion mark
Demonstrate understanding of database design and ability to draw database diagrams (20%)
Inadequate understandin g of database design and database diagrams.
Basic knowledge only of understanding and of database design and database diagrams.
Exhibits breadth and depth of understanding of database design and database diagrams.
Exhibits accurate and detailed breadth and depth of understanding of database design and database diagrams.
Displays exceptional understanding of database design and database diagrams.
Demonstrate understanding of database primary and foreign keys, and database referential integrity.  (10%)
Inadequate understandin g of database primary and foreign keys, and database referential integrity.   
Basic knowledge only of understanding of database primary and foreign keys, and database referential integrity.  
Exhibits breadth and depth of understanding of database primary and foreign keys, and database referential integrity.  
Exhibits accurate and detailed breadth and depth of understanding of database primary and foreign keys, and database referential integrity.  
Displays exceptional understanding of database primary and foreign keys, and database referential integrity.  
Demonstrate an understanding and ability to write and run simple SQL DDL and DML queries (20%)
Inadequate understandin g and ability to write and run simple SQL DDL and DML queries
Basic knowledge only of understanding and ability to write and run simple SQL DDL and DML queries
Exhibits breadth and depth of understanding and ability to write and run simple SQL DDL  and DML queries
Exhibits accurate and detailed breadth and depth of and ability to write and run simple SQL DDL and DML queries
Displays exceptional understanding and ability to write and run simple SQL DDL and DML queries
Demonstrate understanding and skills of writing advanced SQL queries, including table joins, MS Access functions and aliases (50%)
Inadequate understandin g and skills of creating the Conceptual Model diagram
Basic understanding and skills of creating the Conceptual Model diagram
Exhibits breadth and depth of understanding and skills of creating the Conceptual Model diagram
Exhibits accurate and detailed breadth and depth of understanding and skills of creating the Conceptual Model diagram
Displays exceptional understanding and skills of creating the Conceptual Model diagram

READ ALSO...   Jessica
Order from Academic Writers Bay
Best Custom Essay Writing Services

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER