Course overview
- Study period
- Semester 2, 2024 (22/07/2024 - 18/11/2024)
- Study level
- Undergraduate
- Location
- St Lucia
- Attendance mode
- In Person
- Units
- 2
- Administrative campus
- St Lucia
- Coordinating unit
- Business School
This course aims to develop students' ability to manage and retrieve information from Information Systems. Students will learn how to use Structured Query Language (SQL) to retrieve information critical for business decision making, and will also develop a thorough understanding of data integrity and its effects on the quality of business decisions. The course also provides a hands-on experience with conceptual modelling of data requirements for business. This course further enhances the students' employability in other areas such as the ability to work in teams, the ability to think analytically and critically, and build confidence in presenting professionally.
This course provides students with an overall understanding of the relational database model. It emphasises the SQL query language and seeks to develop each student's ability to design and retrieve information from relational databases. The course seeks to make students aware of database elements including domains, nulls, recovery, concurrency, security and other similar issues. As such, students will learn how to: use the SQL query language to retrieve relevant information for business purposes; construct semantic data models to help achieve business objectives and know how to convert these models into normalized tables; evaluate and apply integrity constraints including domains, primary keys, and foreign keys; understand the concept of nulls and how this concept applies to SQL queries and database design; understand the importance of the database elements in their application; gain an appreciation of the benefits and requirements of distributed databases.
Course requirements
Assumed background
As the course will be both theoretical and practical ("hands on"), students are expected to be comfortable using PC applications as well as having a good understanding of how business users utilise computer database applications to automate and enhance their business applications. As the assignment will be project based and managed through a project team environment, it is expected that students are familiar and comfortable with this style of contribution to their learning and assessment.
Before attempting this course, students are advised that it is important to complete the appropriate prerequisite course(s) listed on the front of this course profile. No responsibility will be accepted by the School of Business, the Faculty of Business, Economics and Law or the University of Queensland for poor student performance occurring in courses where the appropriate prerequisite(s) has/have not been completed, for any reason whatsoever.
ﾠ
Prerequisites
You'll need to complete the following courses before enrolling in this one:
BISM1201 or 2 units COMP/COMS/INFS courses
Incompatible
You can't enrol in this course if you've already completed the following:
BISM3203 or 7206 or INFS1200 or 7900 or MGTS3203 or 7206
Restrictions
Quota: Minimum of 15 enrolments
Course contact
Lecturer
Ms Jennifer Grant
Course staff
Lecturer
Dr Reihaneh Bidar
Timetable
The timetable for this course is available on the UQ Public Timetable.
Additional timetable information
Please note: Teaching staff doﾠnotﾠhave access to the timetabling system to help with class allocation. Therefore, should you need help with your timetable and/or allocation of classes, please ensure you emailﾠbusiness.mytimetable@uq.edu.auﾠfrom your UQ student email account with the following details:
- Full name,
- Student ID, and
- the Course Code.
Aims and outcomes
This course aims to provide students with an overall understanding of the relational database model. In doing so, it emphasises the SQL query language and seeks to develop each student's ability to design and retrieve information from relational databases. The course also aims to make students aware of domains, nulls, recovery, concurrency, security, and other similar issues. This course further enhances the students' employability in other areas such as the ability to workﾠin teams, the ability to thinkﾠanalyticallyﾠand critically, and build confidence in presenting professionally.
Learning outcomes
After successfully completing this course you should be able to:
LO1.
Understand and apply popular data modelling techniques and develop appropriate data structures for particular business environments.
LO2.
Understand and apply the structured query language (SQL) to extract data from relational information systems.
LO3.
Develop and apply data quality assurance procedures to improve data quality.
LO4.
Research and understand current Information Systems issues and identify how to exploit available data for corporate advantage.
LO5.
Build your ability to work in teams and develop written presentation skills, which are regarded as essential to the effective and efficient conduct of information systems development projects in organisations.
Assessment
Assessment summary
| Category | Assessment task | Weight | Due date |
|---|---|---|---|
| Computer Code, Quiz |
Practical Lab Quiz
|
20% Individual |
Week 6
During Tutorial Class |
| Paper/ Report/ Annotation, Product/ Design, Project |
System Development
|
40% Group |
18/10/2024 6:00 pm
Peer Assessment due 25/10/2024 |
| Examination |
Final Exam
|
40% |
End of Semester Exam Period 2/11/2024 - 16/11/2024 |
Assessment details
Practical Lab Quiz
- Online
- Mode
- Written
- Category
- Computer Code, Quiz
- Weight
- 20% Individual
- Due date
Week 6
During Tutorial Class
- Learning outcomes
- L01, L02, L03
Task description
The online quiz will take place during the Week 6 lab sessions on campus. The quiz will be 60 minutes long. This assessment task covers learning materials presented in lectures, tutorials and the relevant textbook chapters from week 1 to week 5 inclusive. You may need to perform information retrieval tasks using SQL queries.
It is mandatory to attend your allocated tutorial time, and if you cannot attend, you must apply for a deferred quiz. Due to other classes scheduled after your tutorial, it is crucial to arrive and finish on time. If you plan to use your laptop, ensure it is compatible with the required software and has a stable internet connection. Further information about the exam will be presented during lectures.
AI Statement:
Note: This assessment task evaluates students' abilities, skills, and knowledge without the aid of generative Artificial Intelligence (AI). Students are advised that the use of AI technologies to develop responses is strictly prohibited and may constitute student misconduct under the Student Code of Conduct.
Submission guidelines
Deferral or extension
You may be able to apply for an extension.
Late submission
Exams submitted after the end of the submission time will incur a late penalty.
System Development
- Team or group-based
- Mode
- Product/ Artefact/ Multimedia
- Category
- Paper/ Report/ Annotation, Product/ Design, Project
- Weight
- 40% Group
- Due date
18/10/2024 6:00 pm
Peer Assessment due 25/10/2024
- Other conditions
- Peer assessed, Longitudinal.
- Learning outcomes
- L01, L02, L03, L04, L05
Task description
The main purpose of this assessment is to develop your ability to work in a team and to design, develop, and implement a well-structured relational database that effectively supports the given scenario. Students will be required to demonstrate their knowledge and ability to use SQL. The fundamental knowledge and skills required for this assessment task are expected to be cultivated through lectures and tutorials. However, students will need to conduct additional research to further enhance the skills necessary to successfully complete this assessment.
Team formation and teamwork: You will undertake this project as a part of a team of 3 to 5 members. Project team members must be allocated to the same tutorial. You will submit portions of the project at intervals, receive oral comments on your work during the informal presentations from your tutor, and revise earlier submissions.
Feedback on draft submissions (iterations 1 and 2)
- Iteration 1 during week 8 tutorials. The submission due date will be announced on BlackBoard.
- Iteration 2 during week 11 tutorials. The submission due date will be announced on BlackBoard.
Peer Assessment: 5% of the mark for this assessment will be determined by the members of your group, who will assess your contribution to the project against 4 criteria, for a mark out of 5. A link will be provided on Blackboard for this evaluation.
- If you mark other group members for any criteria at 3 or below, you must provide a comment to justify your low mark.
- If you mark low without a comment, the mark you have given will be changed, without consultation.
- If you do not fill out your peer assessment, you may be given a mark of zero for this part of the assessment or you may be allocated the mark based on the marks given by the rest of your team.
Peer Assessment Criteria
- Project Management - the extent to which someone participates in setting up processes, such as meeting times and work submission deadlines, which will lead to successful and timely completion of the project.
- Knowledge - the extent to which someone has contributed knowledge and skills to work completion
- Communication - the extent to which someone communicates respectfully, positively, and effectively with others in the group, in order to create group cohesion and get the project done with a minimum of conflict.
- Responsibility - the extent to which someone meets their obligations, like turning up to all meetings, and fully participating and taking all aspects of the project seriously.
Working effectively in a Team: A Practical Guide MOOC explores ways in which to learn how to build effective teams, be a great team player, and manage team conflict. You are encouraged to complete this practical guide if you haven't done a team project before. Refer to Teams101x MOOC.
AI Statement:
This task has been designed to be challenging, authentic, and complex. Whilst students may use AI technologies, successful completion of assessment in this course will require students to critically engage in specific contexts and tasks for which artificial intelligence will provide only limited support and guidance. To pass this assessment, students will be required to demonstrate detailed comprehension of their written submission independent of AI tools. If AI has been used it must be acknowledged.
Submission guidelines
Submit through Blackboard Assessment links.
Deferral or extension
You may be able to apply for an extension.
Late submission
A penalty of 10% of the maximum possible mark will be deducted per 24 hours from time submission is due for up to 7 days. After 7 days, you will receive a mark of 0.
Final Exam
- Mode
- Product/ Artefact/ Multimedia, Written
- Category
- Examination
- Weight
- 40%
- Due date
End of Semester Exam Period
2/11/2024 - 16/11/2024
- Other conditions
- Time limited.
- Learning outcomes
- L01, L02, L03, L04
Task description
The Final Examination will consist of multiple choice, short answer and problem solving questions based on learning materials presented in lectures, tutorials and the relevant chapters of the textbook from week 4 to week 13 inclusive. Further details about the exam will be discussed in lectures and posted to the Blackboard course site.
AI Statement:
This assessment task evaluates students' abilities, skills and knowledge without the aid of Artificial Intelligence (AI). Students are advised that the use of AI technologies to develop responses is strictly prohibited and may constitute student misconduct under the Student Code of Conduct.
Exam details
| Planning time | 10 minutes |
|---|---|
| Duration | 90 minutes |
| Calculator options | (In person) Casio FX82 series or UQ approved , labelled calculator only |
| Open/closed book | Closed Book examination - no written materials permitted |
| Exam platform | Paper based |
| Invigilation | Invigilated in person |
Submission guidelines
Deferral or extension
You may be able to defer this exam.
Late submission
Exams submitted after the end of the submission time will incur a late penalty.
Course grading
Full criteria for each grade is available in the Assessment Procedure.
| Grade | Cut off Percent | Description |
|---|---|---|
| 1 (Low Fail) | 0 - 29 |
Absence of evidence of achievement of course learning outcomes. |
| 2 (Fail) | 30 - 46 |
Minimal evidence of achievement of course learning outcomes. |
| 3 (Marginal Fail) | 47 - 49 |
Demonstrated evidence of developing achievement of course learning outcomes |
| 4 (Pass) | 50 - 64 |
Demonstrated evidence of functional achievement of course learning outcomes. |
| 5 (Credit) | 65 - 74 |
Demonstrated evidence of proficient achievement of course learning outcomes. |
| 6 (Distinction) | 75 - 84 |
Demonstrated evidence of advanced achievement of course learning outcomes. |
| 7 (High Distinction) | 85 - 100 |
Demonstrated evidence of exceptional achievement of course learning outcomes. |
Additional course grading information
Grades will be allocated according to University-wide standards of criterion-based assessment.
Supplementary assessment
Supplementary assessment is available for this course.
Learning resources
You'll need the following resources to successfully complete the course. We've indicated below if you need a personal copy of the reading materials or your own item.
Library resources
Find the required and recommended resources for this course on the UQ Library website.
Learning activities
The learning activities for this course are outlined below. Learn more about the learning outcomes that apply to this course.
Filter activity type by
Please select
| Learning period | Activity type | Topic |
|---|---|---|
Week 1 |
Lecture |
Course Overview and Intro to DBMS Learning outcomes: L01, L04 |
Week 2 |
Tutorial |
T1: Entity-Relationship Modelling Learning outcomes: L01 |
Lecture |
Entity-Relationship Model Learning outcomes: L01 |
|
Week 3 |
Tutorial |
T2: Relational Model and SQL prep Learning outcomes: L01, L03 |
Lecture |
Relational Model Learning outcomes: L01, L03 |
|
Week 4 |
Tutorial |
T3: SQL Exercises Learning outcomes: L02, L03 |
Lecture |
Database Design and Structured Query Language (I) Learning outcomes: L01, L02, L03 |
|
Week 5 |
Tutorial |
T4: SQL Exercises Learning outcomes: L02, L03 |
Lecture |
Structured Query Language (II) Learning outcomes: L02, L03, L05 |
|
Week 6 |
Tutorial |
T5: Practical Lab Quiz Lab Quiz during your tutorial. Learning outcomes: L01, L02 |
Week 7 |
Tutorial |
T6: Practical Exercises for Normalisation Learning outcomes: L01, L02, L03, L04 |
Lecture |
Normalisation Learning outcomes: L01, L03, L04 |
|
Week 8 |
Tutorial |
T7: Project Iteration 1 presentation and security Learning outcomes: L01, L02, L03, L04, L05 |
Lecture |
Database security and control Learning outcomes: L01, L03, L04 |
|
Week 9 |
Tutorial |
T8: Practical Exercises for Normalisation Learning outcomes: L01, L02, L03 |
Lecture |
Transaction Management: Recovery and Concurrency Learning outcomes: L01, L03 |
|
Mid Sem break |
No student involvement (Breaks, information) |
In-Semester Break |
Week 10 |
Tutorial |
T9: SQL exercises- Recovery and Concurrency Learning outcomes: L01, L02, L04 |
Lecture |
Missing Information, Data Warehousing Learning outcomes: L01, L04 |
|
Week 11 |
Tutorial |
T10: Project Iteration 2 Presentation and Data Quality Exercises Learning outcomes: L01, L02, L03, L04, L05 |
Lecture |
Data Quality and Data Cleaning Learning outcomes: L01, L02, L03, L04 |
|
Week 12 |
Tutorial |
T11: Team project Learning outcomes: L01, L04 |
Lecture |
Distributed DBMS Learning outcomes: L01, L04 |
|
Week 13 |
Tutorial |
T12: Q&A and Exam Practice Learning outcomes: L01 |
Lecture |
Big Data and Intelligence Technologies Learning outcomes: L01, L04 |
Policies and procedures
University policies and procedures apply to all aspects of student life. As a UQ student, you must comply with University-wide and program-specific requirements, including the:
- Student Code of Conduct Policy
- Student Integrity and Misconduct Policy and Procedure
- Assessment Procedure
- Examinations Procedure
- Reasonable Adjustments - Students Policy and Procedure
Learn more about UQ policies on my.UQ and the Policy and Procedure Library.