MAN6905 – Databases and Business Intelligence Assignment 1 Assignment


MAN6905 – Databases and Business Intelligence Assignment 1
Assignment 1 (50 Marks total)
In this assignment you will apply critical thinking and technical skills to solve authentic business
problems. It is important that you:
 Conceptualise problems or situations;
 Apply technical skills to authentic situations;
 Solve the complex problems;
Submit all answers in a single MS-WORD file. Use headings to clearly separate each task.
Part 1 – Sales and Marketing
Management Database System (30 marks)
You are required to create a sales and marketing management system with a small number of
common sense attributes. The system should contain the following information
 Sales details
 Marketing details
 Customer details
 Production details
 Delivery details
 Management details
So consider what sales and marketing system is required to deliver a consistent and customer oriented
service to all customers over the world.
You need to identify the tables you require and the information that they are to contain.
This is only a small system, do not over-complicate it.
1. Design – Marks 10
Create an entity-relationship (ER) model drawn with MS WORD or POWER POINT if you prefer.
You are required to submit a print out of your database schema:
 Set of normalised tables – with your sample data.
 Indicate the table relationships using multiple keys; PK, FK, and SK using UML notation.
Edith Cowan University
MAN6905 – Databases and Business Intelligence Assignment 2
2. SQL – Marks 10
Use MYSQL to create the set of database tables of the relational database model and complete the
associated queries given.
1) Write all the SQL statements, necessary to create all tables and relationships, with Primary &
Foreign keys.
2) Execute each statement in the correct order to create the relational database in MYSQL.
3) Insert some data into each table.
4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL
5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to;
i. display all tables,
ii. identify sales total for each item
iii. identify delivery confirmation of sold items
iv. identify marketing level for sold items
3. FORM – Marks 10
Using MS-ACCESS, link to the MYSQL database (see the instructions in MYSQL Connection from
ACCESS on Blackboard) and create forms to enter sales and purchase orders.
 No buttons are necessary, just what ACCESS generates to scroll forward, add a record etc.
 Make it clear what the forms do in the Form by adding text or headers.
 Note: If you don’t own MS-ACCESS, do this part of the assignment in the lab.
For this part of the assignment you are required to submit:
(a) A detailed database schema diagram drawn in Excel or PowerPoint
(b) The required SQL CREATE TABLE and SELECT statements
(c) The result of all SQL statements run in MYSQL Query Browser as screen shots to demonstrate
correct execution of the statements
(d) The required MS-ACCESS screen shots.
Part 2 – Business Intelligence (20 Marks)
There are many large datasets available online, from governments in particular, such as:

Front Page
Edith Cowan University
MAN6905 – Databases and Business Intelligence Assignment 3
Choose TWO large datasets and analyse them with pivot tables. Document the insights and trends
that you find during the analysis. Address the following requirements and give FOR EACH DATASET:
1. Dataset details:
a. The URL of the dataset.
b. A description of the dataset.
c. A screen capture showing the first page of the Excel spreadsheet containing the dataset.
2. Screen captures of ONE pivot table analysis on the dataset utilised together with ONE chart output
that you have created.
3. A clear written analysis of your findings from the pivot table and chart.
a. Focus on the insight you are trying to gain and the business intelligence you derive.
b. Try differentiating dimensions from facts in the dataset. You will usually have dimensions
as the rows (time, location, product type) and facts in the centre (revenue, cost etc).

The post MAN6905 – Databases and Business Intelligence Assignment 1 Assignment appeared first on mynursinghomeworks.


Source link