Assessment Brief: ICT5151 Data and Information Management Trimester 2, 2024

Assessment Overview

Assessment 1: Quiz

Assessment 1 Details

In-class activities/quizzes - Students will complete in class workshop assessments including on-line quizzes, situation analyses and practical applications of skills.

Assessment 1 Marking Criteria and Rubric

The assessment will be marked out of 100 and will be weighted 10% of the total unit mark.

Assessment 2: Laboratory Practicum

Assessment 2 Details

In-class activities/quizzes - Students will complete in class workshop assessments including situation analyses and practical applications of skills.

Activities assess students’ ability to understand theoretical concepts and materials. To complete these activities, you are required to study the material provided (lecture slides, tutorials, and reading materials) and engage in the unit’s activities and the discussion forums. The prescribed textbook, lecture materials, and recorded videos are the main references and the recommended reading material.

By completing this assessment successfully, you will be able to identify key aspects of databases. The student is required to submit the Laboratory Practicum at the end of the workshop session.

Assessment 2 Marking Criteria and Rubric

The assessment will be marked out of 100 and will be weighted 10% of the total unit mark.

Assessment 3: Database Analysis and Design Project

Assessment 3 Details

In your assignment you will need to analyse the following scenario, create ER diagram, build database and populate it with sample data.

A small private medical centre specialises on providing daily physical rehabilitation procedures. The centre wants to design and create a relational database to store the following information:

• A doctor is assigned to each patient.
• For each visit a patient makes a booking.
• A booking can be made for at least one procedure.
• In the end of each visit a patient can make a payment or pay later.
• A room is assigned for each procedure, and only one procedure can be done in each room. All rooms are assigned different procedures.
• The following details are stored in the database:

You need to design and implement the hospital database. There are three parts in the assignment:

1. Conceptual Model design
2. Relational Model design
3. Physical Model design. Database population using SQL programming.

Your assignment consists of 3 parts:

Part 1. Conceptual Mode

You need to describe the Conceptual Model, which must include the following elements:

• Entities and their attributes. For each entity you must also introduce unique identifier attribute for each entity.
• Identify multi-valued and composite attributes (if any). In this case, they need to be shown in the ER diagram with the corresponding notations.
• Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, one-to-many, many-to-many, and also optional or mandatory.
• Draw the Conceptual Model Enhanced Entity-Relationship diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document.

Part 2. Logical (Relational) Model

Describe the algorithm of conversion of the Conceptual Model into the Logical Model. Remember that your description should include the following elements:

• Entities in the Conceptual Model become relations (tables) in the Logical Model, and unique identifiers become primary keys.
• For one-to-one or one-to-many relationship between two entities you will need to create a foreign key in one of the relations (tables).
• If there is a many-to-many relationship between two entities, then you will need to create a new relation (table) with a composite primary key.
• For each field (column) in a relation, describe a data type (integer, float, character, text etc.).
• If an entity contains a multi-valued attribute, then you will need to create a new relation in the Logical Model corresponding to this attribute.
• Draw the Logical Model diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the assignment Word document.

Part 3. Create and populate the database.

The SQL queries below can be written in XAMPP MySQL.

• Write SQL queries to create each table. The queries should contain creation of primary and foreign (if applicable) keys.
• Write SQL queries to populate the tables. Each table should contain several records to test the referential integrity.
• One of the records describing doctors should have your name as a doctor’s name.
• One of the records describing patients should have an address as your campus address (Sydney, Melbourne, or Brisbane campus address).
• One of the records describing bookings should have your student id as a primary key.
• One of the records describing rooms should have your ICT5151 classroom number in your campus.
• Make screenshots of the development environment you worked with and insert the images in the assignment file.

• Copy SQL queries in the assignment document.
• Export your project database in SQL script containing queries to create tables and populate data.
• Write SELECT SQL queries to test the database.

What to submit:

1. A MS Word document containing database design and diagram images of Conceptual and Logical Models.
2. Your project database SQL script generated by XAMPP.

Assessments 3 Marking Criteria and Rubric

The assessment will be marked out of 100 and will be weighted 30% of the total unit mark. The marking criteria and rubric are shown on the following page.

Assessment 3 Marking Criteria and Rubric

Assessment 4: Research Report

Assessment 3 Detail

Data are vital to business. Whether it is easy to access real-time data or the availability of advanced technology to process and analyse these data, enterprises are trying to make the most of this precious raw material. Data management in today’s world needs a modern approach to effectively handle the complex problems of dealing with multiple data formats.

Data management is the process of collecting, sorting, arranging, and managing vast amounts of data to help businesses derive valuable insights from it. From data governance to data architecture and security, modern data management is a multifaceted discipline. But following the modern data management approach is not easy, especially for enterprises that are used to traditional business methods.

In your report you need to research on the modern data management approach in an enterprise. You need to research and explain the following topics:

• What are structured and semi-structured data?
• Explain pros and cons of structured and semi-structured data.
• Research typical use cases (applications, business areas, information systems) for structured and semi-structured data
• Explain the necessity of data management for every business.
• Explain Data Management in the following areas:
  • Data Security
  • Data Destruction
  • Data Warehousing and business intelligence management
  • Document and record storage
  • Data governance
  • Data quality management
• Research and explain modern data architecture components and characteristics (infrastructure architecture, parallel and distributed processing, scalability, open data access, automation, elasticity, intelligence, governance etc.).
• Research the modern data architecture of a selected Cloud service provider. For example, you can consider Amazon Web Services (AWS), Google Cloud, Microsoft Azure etc.

Your report should contain the following sections:

1. Cover page
2. Table of contents
3. Abstract
4. Introduction
5. Background to study: literature review, and how your study fits in
6. Methods: how the study was carried out, and how data were analysed
7. Discussion of results
8. Conclusion
9. References

Assessments 4 Marking Criteria and Rubric

The assessment will be marked out of 100 and will be weighted 30% of the total unit mark. The marking criteria and rubric are shown on the following page.

Assessment 4 Marking Criteria and Rubric