Assignment Task

Unit Learning Outcome (ULO)

1. Explain and apply the business intelligence (BI) lifecycle concept, multidimensionality concept and database concept
2. Appraise and apply data warehousing architecture, technologies and development methodologies and database for business intelligence.
3. Collaborate constructively in a team to use Bl and database technologies for implementation of innovative Bl solutions and better dissemination of information.

Graduate Learning Outcome (GLO)

1. Discipline-specific knowledge and capabilities - students are required to demonstrate an understanding of the business intelligence context and explain the BI and database technologies and associated implementation issues.
2. Digital Literacy - students are required to apply BI and database technologies to find, use and disseminate actionable information.
3. Teamwork - students are expected to collaborate constructively in a team to appraise business intelligence and database requirements and develop Bl solutions.

Task

1. Your task is to analyse the healthcare database requirement (e.g. healthcare trade, healthcare sales data, healthcare site data, aggregated spend pattern, average visiting time, etc) and design a database that considers normalization. You must explain each of your normal form tables and provide: 1NF, 2NF, and 3NF tables to depict your work. The database can be re-used for the practical assignment on healthcare dashboard development, as shown in below example.

2. You may include the database tables as MS Word/Excel tables or as screenshot images. For 1NF, 3 tables are expected (with at least 5 rows for each field of the tables; hence each group member can develop one table. E.g., 1 table for healthcare owner, 1 table for government, 1 table for healthcare association). In the written report, you must explain the table structure, define the data field/attribute and the data type (i.e., Integer, Floatingpoint number, Character, String, Boolean), and provide details of the business rule, primary key, etc (include any assumptions that you may have made). As a group assignment, there should be only one set of business rules for all tables. An example of a database table is provided below.

3. The entire assignment should be discussed and presented as one coherent report. The written report should include: 1) objectives of your database design, 2) benefits of your database design, 3) tables, data fields and commentary, etc. Feel free to make reasonable assumptions. You may create your own artificial datasets. Real-world dataset is not compulsory. 

4. The contribution of each team member must be clearly stated in the Table of Contents (e.g., Introduction - done by Alex Smith). It might be useful to have a look at Deakin generic guidelines on group work at

5. A group contribution form must be signed by all group members and be attached as an appendix in the group report.