business intelligence and database

Sample assignment outline This report has been prepared by:

x, y, z

MIS781 Business Intelligence and Database Group Assignment

Sample report MIS781

Page 1 of 5

Table of content 1. Introduction .................................................................................................................................................................... 2

1.1 Objectives of the database design ................................................................................................................................ 2

1.2 Benefits of the database design ................................................................................................................................... 2

1.3 Assumptions.................................................................................................................................................................. 2

1.4 Description of business rules and variables used in this report ................................................................................... 3

1.5 Target Audience ............................................................................................................................................................ 3

2. Database within COIVD-19 pandemic setting ..................................................................................................................... 4

2.1 Database 1: For Health Department/Government ....................................................................................................... 4

2.2 Database 2: For Public .................................................................................................................................................. 5

2.3 Database 1: For Local Council / Hospital ...................................................................................................................... 5

3. References (use APA ref) .................................................................................................................................................... 5

Sample report MIS781

Page 2 of 5

1. Introduction COVID-19 pandemic setting…..

1.1 Objectives of the database design • Objective 1

• Objective 2

• Objective 3

1.2 Benefits of the database design

• Benefit 1

• Benefit 2

• Benefit 3

Eg. Three key benefits are:

• Empowering people to tackle the challenge of climate change

• Encouraging the use of/switch to renewable energy

• Provide a tangible outcome

1.3 Assumptions

The findings and analyses identified by the dashboard are derived from an amalgamation of publicly available data

sources from two organisations identified in Table 2.

Table 1 Assumptions

Assumption 1: Eg. The death rate includes those who passed away at home

Assumption 2: Eg. Senior citizen: 65+

Assumption 3

Assumption 4…..

Sample report MIS781

Page 3 of 5

1.4 Description of business rules and variables used in this report

Example Table 2. Business Rules and final variables used for analysis

1.5 Target Audience

1. Health Department/Government

2. Public

3. For Local Council / Hospital

Sample report MIS781

Page 4 of 5

2. Database within COIVD-19 pandemic setting

2.1 Database 1: For Health Department/Government

1NF

Field 1 2 3 4 5 6 7

PK Row 1

2

3

4

5

Commentary: Explain this 1NF table xxxxx

2NF

2NF table 1

Explain this 2NF table 1: xxxxx

2NF table 2

Explain this 2NF table 2: xxxxx

2NF table 3

Explain this 2NF table 3: xxxxx

3NF

3NF table 1

Explain this 3NF table 1: xxxxx

Sample report MIS781

Page 5 of 5

3NF table 2

Explain this 3NF table 2: xxxxx

3NF table 3

Explain this 3NF table 3: xxxxx

3NF table 4

Explain this 3NF table 4: xxxxx

2.2 Database 2: For Public

1NF -> 2NF -> 3NF

Commentary

2.3 Database 1: For Local Council / Hospital

1NF -> 2NF -> 3NF

Commentary

3. References (use APA ref)

1….

2….