讲解 INF10025 Data Management and Analytics Semester 2 2024辅导 SQL语言

INF10025

Data Management and Analytics

Semester 2 2024

PART A:        Unit Summary

Aims

This unit will provide a solid foundation for the design, implementation and management of organisational databases. Organisational data and data modelling is introduced, focusing on structured and unstructured data, and entity-relationship (ER) modelling. The skills required  to construct ER diagrams will be taught, with a focus on ensuring that the logic of the model  reflects the real-world industry case it is representing. Relational databases will be introduced and the functionality they afford organisations will be explored through real world industry cases. The process of designing, building and retrieving information from a database using SQL will be a focus of this unit. The unit also introduces students to the role databases play in data analytics and helping organisations harness the power of and insights from their data.

Unit Learning Outcomes

Students who successfully complete this unit can:

Graduate Attributes

This unit may contribute to the development of the following Swinburne Graduate Attributes:

    Communication 1 - Verbal communication

    Communication 2 - Communicating using different media

    Teamwork 1 - Collaboration and negotiation

    Teamwork 2 - Teamwork roles and processes

    Digital literacies 1 – Information literacy

    Digital Literacies 2 – Technical literacy

Content

•    Structured and unstructured data

•    Database relations, tables, records, keys, filters, queries, parameters, forms, indexes

•    Data formats, manipulation, and exchange tools

•    Transactions and ACID

•    Entity-relationship diagrams and modelling 

•    SQL

•    Data warehousing, big data, and data normalisation

•    Data analytics, business intelligence, data visualisation

PART B:       Your Unit in more detail

Unit Improvements

Unit Teaching Staff

Learning and Teaching Structure

Learning web site: https://swinburne.instructure.com/ The site is designed to assist students to study in their own time, and from their own homes.

Teaching staff are available to assist when required, however, it is up to students to take initiative and contact the appointed tutor. The best way to do this is via the discussion board (especially if the question is likely to be asked by other students) or by email. It is expected  that students will explore all the resources available online and undertake the preparatory reading and exercises outlined in the unit learning materials. Students should follow the dates provided in the Weekly Schedule (as contained in this document) for all assessment items and suggested course content sequencing.

Submission of tasks and feedback on submitted work will be provided via Canvas. Tasks submitted after the due date will be marked as incomplete unless you have received an extension in writing prior to the due date. Failing to submit by due dates will result in lower final grade.

Assessment

a)   Assessment Overview

b)   Minimum requirements to pass this Unit

To pass this unit students must submit a passable learning portfolio (see the Submission Requirements section for details) and meet all ULOs to a minimum standard.

c)    Examinations

This unit has no official examination. The learning portfolio does include two tests that   you must complete during class at the designated time. If you are unable to sit the tests at the designated time, then you must contact the convenor to arrange another suitable time. Arrangements must be made prior to the date of each test.

d)   Use of generative AI (genAI) in this Unit

The valid use of genAI in this unit is as follows:

•    you may not use genAI for any part of your assessment submissions or tests in this unit.

e)   Submission Requirements

Assessments must be submitted through Canvas. Tasks submitted after the due date will be marked Incomplete.

Please ensure you keep a copy of all assessments that are submitted.

f)    Extensions and Late Submission

If your preparation for a non-exam assessment is affected by illness or other

extraordinary circumstances outside your control, you may apply in advance for an extension to the due date.

Extensions must be applied for prior to the due date of the Task.

Tasks submitted after the due date will not be accepted unless an extension has been approved in writing.

g)   Referencing

To avoid plagiarism, you are required to provide a reference whenever you include    information from other sources in your work. Further details regarding plagiarism are available in Section C of this document under ‘Academic Integrity’ .

Referencing conventions required for this unit are: Harvard Standard

Helpful information on referencing can be found at

http://www.swinburne.edu.au/library/referencing/

h)   Groupwork Guidelines

This unit does not include group work. Any submission discovered to be non-individual work will be treated as collusion or plagiarism and may result in being marked as Fail.

Required Textbook(s)

There is not a required textbook for this unit.

Recommended Reading Materials

The Library has a large collection of resource materials, both texts and current journals.   Listed below are some references that will provide valuable supplementary information to

this unit. It is also recommended that you explore other sources to broaden your understanding.

• Lecture slides can be downloaded from the Canvas Modules section. These include details on the material you will need to read each week, as well as tasks for you to undertake.

• Lecture recordings can be download from Canvas Modules section.

• Tasks handouts also contain a list of references that can be used.