COMP SCI 2208MELB - Databases and Ethical Data

Melbourne Campus - Semester 2 - 2022

Databases have come a long way in the past decades and, rather than focusing purely on relational databases and SQL, this course introduces students to contemporary database applications and concepts, to develop a deep and thorough understanding of the principles that underpin all contemporary database systems. Students will be introduced to relational, NoSQL, and distributed database models, with an emphasis on the design, configuration, and ongoing maintenance of these systems. The course will cover consistency models, the evolution of transactional processing, and existing examples of all of the database types. With all of the data that is stored in systems, there are important questions of whether certain data should be collected, how it should be stored, how it should be processed, and whether answers can be shared from this data. Students will cover relevant ethical studies around the use of data, including the impact of local and international legislation such as the Australian Privacy Act and the European General Data Protection Regulation. This course will be assessed through programming assignments, small projects, lecture quizzes, contributions to group discussions, and written assignments. The majority of assessment is individual but some elements are group based to develop non-technical skills.

  • General Course Information
    Course Details
    Course Code COMP SCI 2208MELB
    Course Databases and Ethical Data
    Coordinating Unit School of Computer Science
    Term Semester 2
    Level Undergraduate
    Location/s Melbourne Campus
    Units 3
    Restrictions Available only to University of Adelaide College Melbourne Campus students
    Course Description Databases have come a long way in the past decades and, rather than focusing purely on relational databases and SQL, this course introduces students to contemporary database applications and concepts, to develop a deep and thorough understanding of the principles that underpin all contemporary database systems. Students will be introduced to relational, NoSQL, and distributed database models, with an emphasis on the design, configuration, and ongoing maintenance of these systems. The course will cover consistency models, the evolution of transactional processing, and existing examples of all of the database types. With all of the data that is stored in systems, there are important questions of whether certain data should be collected, how it should be stored, how it should be processed, and whether answers can be shared from this data. Students will cover relevant ethical studies around the use of data, including the impact of local and international legislation such as the Australian Privacy Act and the European General Data Protection Regulation. This course will be assessed through programming assignments, small projects, lecture quizzes, contributions to group discussions, and written assignments. The majority of assessment is individual but some elements are group based to develop non-technical skills.
    Course Staff

    Course Coordinator: Associate Professor Nickolas Falkner

    Course Timetable

    The full timetable of all activities for this course can be accessed from Course Planner.

  • Learning Outcomes
    Course Learning Outcomes
    1. Identify and discuss fundamental concepts of information and database theory
    2. Identify and discuss relational and non-relational database models
    3. Design and implement data models for all database types
    4. Describe and discuss the epistemological conflicts inherent in database design
    5. Interpret the data privacy acts of Australia and Europe
    6. Design and implement physical database designs
    7. Describe the impact of ethics on database design
    University Graduate Attributes

    No information currently available.

  • Learning & Teaching Activities
    Learning & Teaching Modes

    No information currently available.

    Workload

    No information currently available.

    Learning Activities Summary

    No information currently available.

  • Assessment

    The University's policy on Assessment for Coursework Programs is based on the following four principles:

    1. Assessment must encourage and reinforce learning.
    2. Assessment must enable robust and fair judgements about student performance.
    3. Assessment practices must be fair and equitable to students and give them the opportunity to demonstrate what they have learned.
    4. Assessment must maintain academic standards.

    Assessment Summary

    No information currently available.

    Assessment Detail

    No information currently available.

    Submission

    No information currently available.

    Course Grading

    Grades for your performance in this course will be awarded in accordance with the following scheme:

    M10 (Coursework Mark Scheme)
    Grade Mark Description
    FNS   Fail No Submission
    F 1-49 Fail
    P 50-64 Pass
    C 65-74 Credit
    D 75-84 Distinction
    HD 85-100 High Distinction
    CN   Continuing
    NFE   No Formal Examination
    RP   Result Pending

    Further details of the grades/results can be obtained from Examinations.

    Grade Descriptors are available which provide a general guide to the standard of work that is expected at each grade level. More information at Assessment for Coursework Programs.

    Final results for this course will be made available through Access Adelaide.

  • Student Feedback

    The University places a high priority on approaches to learning and teaching that enhance the student experience. Feedback is sought from students in a variety of ways including on-going engagement with staff, the use of online discussion boards and the use of Student Experience of Learning and Teaching (SELT) surveys as well as GOS surveys and Program reviews.

    SELTs are an important source of information to inform individual teaching practice, decisions about teaching duties, and course and program curriculum design. They enable the University to assess how effectively its learning environments and teaching practices facilitate student engagement and learning outcomes. Under the current SELT Policy (http://www.adelaide.edu.au/policies/101/) course SELTs are mandated and must be conducted at the conclusion of each term/semester/trimester for every course offering. Feedback on issues raised through course SELT surveys is made available to enrolled students through various resources (e.g. MyUni). In addition aggregated course SELT data is available.

    There is no previous feedback on this course.
  • Student Support
  • Policies & Guidelines
  • Fraud Awareness

    Students are reminded that in order to maintain the academic integrity of all programs and courses, the university has a zero-tolerance approach to students offering money or significant value goods or services to any staff member who is involved in their teaching or assessment. Students offering lecturers or tutors or professional staff anything more than a small token of appreciation is totally unacceptable, in any circumstances. Staff members are obliged to report all such incidents to their supervisor/manager, who will refer them for action under the university's student’s disciplinary procedures.

The University of Adelaide is committed to regular reviews of the courses and programs it offers to students. The University of Adelaide therefore reserves the right to discontinue or vary programs and courses without notice. Please read the important information contained in the disclaimer.