Unit convenor and teaching staff |
Unit convenor and teaching staff
Teacher
Charanya Ramakrishnan
Contact via By email
Macquarie University International College
Contact staff member
Teacher
Hedieh Ranjbartabar
Contact via By email
Macquarie University International College
Contact staff member
|
---|---|
Credit points |
Credit points
3
|
Prerequisites |
Prerequisites
|
Corequisites |
Corequisites
|
Co-badged status |
Co-badged status
|
Unit description |
Unit description
This unit introduces students to the principles and concepts of data storage, management and modelling, including the role of data and information in organisations. The unit will cover conceptual modelling techniques, converting conceptual data models into relational data models and verifying its structural characteristics with normalisation techniques, and implementing and utilising a relational database using a database-management system. Fundamental data modelling tools, techniques and query languages such as Structured Query Language (SQL) will be used. Ethical and green approaches to the collection, backup, use and storage of data and the construction of systems are emphasised. An introduction to the concepts and issues relating to data warehousing, governance, administration, security and privacy and alternative database structures such as distributed and object oriented databases will be provided. The unit concentrates upon building a firm foundation in information representation, organisation and storage with particular emphasis upon the application of database systems.
|
Information about important academic dates including deadlines for withdrawing from units are available at https://www.mq.edu.au/study/calendar-of-dates
On successful completion of this unit, you will be able to:
Requirements to Pass
In order to pass this unit a student must obtain a mark of 50 or more for the unit (i.e. obtain a passing grade P/ CR/ D/ HD).
For further details about grading, please refer to Schedule 1 of the Assessment Policy.
Students must also pass any hurdle assessments as stipulated in the Assessment Section of this Unit Guide.
Grading
The College will award common result grades as specified in Schedule 1 of the Assessment Policy.
Students will receive criteria and standards for specific assessment tasks, which will be aligned with the grading descriptors given in Schedule 1.
The attainment (or otherwise) of learning outcomes for a unit of study will be reported by grade and mark which will correspond to the Schedule 1 and be as outlined below.
Grade |
Mark Range |
Outcome |
Description |
|
HD |
High Distinction |
85-100 |
Pass |
Provides consistent evidence of deep and critical understanding in relation to the learning outcomes. There is substantial originality, insight or creativity in identifying, generating and communicating competing arguments, perspectives or problem solving approaches; critical evaluation of problems, their solutions and their implications; creativity in application as appropriate to the program. |
D |
Distinction |
75-84 |
Pass |
Provides evidence of integration and evaluation of critical ideas, principles and theories, distinctive insight and ability in applying relevant skills and concepts in relation to learning outcomes. There is demonstration of frequent originality or creativity in defining and analysing issues or problems and providing solutions; and the use of means of communication appropriate to the program and the audience. |
CR |
Credit |
65-74 |
Pass |
Provides evidence of learning that goes beyond replication of content knowledge or skills relevant to the learning outcomes. There is demonstration of substantial understanding of fundamental concepts in the field of study and the ability to apply these concepts in a variety of contexts; convincing argumentation with appropriate coherent justification; communication of ideas fluently and clearly in terms of the conventions of the program. |
P |
Pass |
50-64 |
Pass |
Provides sufficient evidence of the achievement of learning outcomes. There is demonstration of understanding and application of fundamental concepts of the program; routine argumentation with acceptable justification; communication of information and ideas adequately in terms of the conventions of the program. The learning attainment is considered satisfactory or adequate or competent or capable in relation to the specified outcomes. |
F |
Fail |
0-49 |
Fail |
Does not provide evidence of attainment of learning outcomes. There is missing or partial or superficial or faulty understanding and application of the fundamental concepts in the field of study; missing, undeveloped, inappropriate or confusing argumentation; incomplete, confusing or lacking communication of ideas in ways that give little attention to the conventions of the program. |
FA |
Fail |
Did Not Attend |
Student has failed the compulsory attendance component of assessment |
|
FH |
Fail |
49 |
Failed Hurdle |
Student has obtained a raw mark over 50, yet failed all available attempts of at least one hurdle assessment (as described within Schedule 2 of the Assessment Policy). |
Other grades (FW, I, IS, UD, UJ, UL) may be allocated student has withdrawn after the Census Date, not submitted or completed one or more components of the assessment, has been awarded a supplementary assessment, has applied for special consideration or because of an unresolved matter such as allegations of academic misconduct. These grades are outlined in Schedule 1 of the Assessment Policy.
Where to find information about assessment
General assessment information including the number and nature of assessments, due dates and weightings has been provided in this unit guide.
Specific assessment information including assignment instructions, questions, marking criteria and rubrics as well as examples of relevant and related assessment tasks and responses will be available in the Assessment section on iLearn. For units that have final examinations, students may access past final exam papers using MultiSearch.
Student Responsibilities
As per the Assessment Policy, students are responsible for their learning and are expected to:
Submission of Assessment Tasks
Assessments must be submitted in accordance with instructions provided in this unit guide. Assessment tasks which have not been submitted as required will not be marked; they will be considered a non-submission and zero marks will be awarded for the task.
Late Submissions and Penalties
Late submissions without an approved extension are possible but will be penalised at 20% per 24 hour period or thereof up to 4 days (weekend inclusive).
Late penalties will be calculated based on the marks allocated to the assessment. I.e. if an assessment is worth 100 marks, a 20mark deduction will be made for each day of lateness or part thereof.
Example: An assignment is due at 5:00 pm on a Friday and is marked out of 100 marks.
Please see “In class assessment” section for further information on in class assessments.
Extensions
Extensions will only be granted as a result of a successful application for Special Consideration. To apply for an extension of time for submission of an assessment item, students must submit their application for Special Consideration via ask.mq.edu.au.
An approved extension will not incur late penalties. However, where a student has been granted an extension and submits late (i.e. after the stipulated due date following extension), late penalties will be applied as per the new the due date. Late penalties will be 20% per 24 hour period or thereof up to 4 days (weekend inclusive).
Resubmissions
Students are responsible for ensuring that they make correct submissions. Following an initial submission, students may resubmit their work up to four days after the due date if, for example, they have submitted the incorrect document or forgotten to include information.
Resubmissions will be treated as late submissions and will be penalised at 20% per 24 hour period or thereof up to 4 days (weekend inclusive). After the 5th day record of submission will be made and feedback provided on the new content submitted but the student will receive zero marks for the assessment task.
In order to resubmit your work you will need to contact your teacher, and ask them to delete your original submission so that you can upload a new one. Teaching staff contact details have been provided in this unit guide.
Retention of Originals
It is the responsibility of the student to retain a copy of any work submitted. Students must produce these documents upon request. Copies should be retained until the end of the grade appeal period each term.
In the event that a student is asked to produce another copy of work submitted and is unable to do so, they may be awarded zero (0) for that particular assessment task.
Requests for original documentation will be sent to the applicant’s student email address within six (6) months of notification by the student. Students must retain all original documentation for the duration of this six (6) month period and must supply original documents to the University within ten (10) working days of such a request being made.
In Class Assessments
Students must bring their Student ID Card to all assessment tasks, including in class assessments and produce this if requested. Students may be refused the opportunity to take an in class assessment task where unable to show their student ID card.
Where an assessment is to be held or submitted a scheduled lesson, students must be ready to submit, present or sit the assessment task at the start of the lesson, however not all assessments may commence at the beginning of the lesson. No additional time or adjustment will be made for late arriving students or students not ready to submit an assessment at the start of the lesson and late penalties will apply.
For example, if a one hour test or quiz is due to take place in a 2 hour lesson, the test or quiz may start at any time in the first hour or at the start of the second hour, so students must be ready to take the test at the beginning of the lesson. No additional time will be given to or adjustment made for students who arrive late. While they may still be permitted to take the test, depending on the task, the student will have only the remaining time to complete the task. Similarly, where an assessment task is due in a given lesson, late penalties may apply to a student who submits the task at the end of the lesson, depending on submission instructions for the task.
Revision Sessions
Where relevant, a revision session may be scheduled prior to the final examination. Revision sessions will usually be scheduled on Monday and/or Tuesday of Week 7. Details of the revision session will be provided in the teaching schedule section of the unit guide and reminders may be posted in iLearn. Where revision sessions are available, students are strongly encouraged to attend.
Final Examinations
The final examination period is Week 7. Examinations will usually be scheduled on Tuesday and Wednesday of Week 7, however students must be available to take exams and submit assessments on any day of this week.
For unit specific details please refer to the Assessment section of this unit guide.
Final Examination Timetable
The University will publish the College Final Examination Timetable at least 4 weeks before the commencement of the final examination period and students will be able to access their final examination schedule in Week 3 of the Term.
Final Examination Requirements
Schedule 4 of the Assessment Policy explains what students are responsible for:
Details of the structure and format of the final examination paper will be made available to students via iLearn prior to the start of the final examination period. This detail will include:
Students must follow directions given by the Final Examination Supervisor.
Students will be required to present their Macquarie University Campus Card as photographic proof of identity for the duration of the final examination and may be refused the opportunity to take a final examination where unable to show their student ID card.
Students are not permitted to:
Missed assessments and examinations
The Special Consideration Policy establishes the principles that support students seeking to notify the University when they experience short-term, unexpected, serious and unavoidable circumstances, which affect their performance in assessment. This Policy applies only to short-term, serious and unavoidable circumstances that arise after a study period has commenced, and where specific assessment task/s have been affected. Students with a pre-existing disability/health condition or prolonged adverse circumstances are advised to seek support from Campus Wellbeing and should also refer to the Student Disability Support Policy.
In order to support students who have experienced serious and unavoidable circumstances, the University will attempt to provide affected students with one (1) additional opportunity to demonstrate that they have met the learning outcomes of a unit or units. An additional opportunity provided under such circumstances is referred to as Special Consideration, and may be granted after careful evaluation of the supporting evidence.
Students are expected to plan their work so that they can meet assessment deadlines at the same time as other obligations which they may have, both inside and outside the University. Special Consideration will not be granted when students are unable to complete an assessment task due to planned or foreseeable absence (e.g. holidays, recreational activities or normal work commitments or changes).
All applications for Special Consideration must be substantiated by original, independent documentary evidence in the format and by the deadline prescribed in the Procedure.
Please refer to the Special Consideration Policy section under Policies and Procedures below.
Supplementary Tests, Supplementary Examinations and Second Attempts at a Hurdle Assessments
Where a student has been granted a supplementary test or examination as a result of an application for special consideration, they will be advised of the time, date and location for the supplementary task.
Supplementary interim assessments (i.e. assessments held during the term) will be held throughout the term and students who have been granted an opportunity to sit a supplementary exam will be informed of times and dates via ask.mq.edu.au.
The supplementary final examination period for formal, end of term examinations will be the fortnight following Week 7. Students who have requested special consideration for a final examination must be available to undertake examinations during the supplementary examination period.
Where a student is eligible for a second attempt at a hurdle assessment, this will typically be scheduled during the supplementary interim/final examination periods unless stipulated otherwise in the assessment section of the unit guide. Students awarded second attempts at hurdles will be notified via email so please ensure you are checking your student email regularly.
No more than one (1) supplementary assessment will be offered to a student in each affected unit, so it is essential that the student makes themselves available for the alternative assessment activity. Please refer to the Special Consideration Policy for further details.
Results for supplementary final examinations may not be available for up to two weeks following the supplementary examination. Students in their final term of study who undertake supplementary final exams and students who apply for special consideration for a unit which is a prerequisite to another unit in their program should note that formal completion of their Program will not be possible until supplementary results are released and this may impact on their ability to enrol in subsequent programs of study on time.
Accessing your Results
Students will be able to view their results for internal assessments via the Grades section in iLearn.
Grades (e.g. HD, D, CR, P, F) for all assessment tasks will be released to students once marking has concluded. Marks for individual assessments may be released as well.
Final results for the unit will be released at 00:01 on Thursday of Vacation Week. Students will be able to view their final result for the unit via eStudent.
Calculating your GPA
A Grade Point Average (GPA) is a calculation that reflects the overall grades of a student in a coursework program. Please refer to the GPA Calculator.
Obtaining Feedback
Teaching staff will provide students with feedback about their academic progress and performance in assessment tasks or a unit of study. Where relevant, other staff such as Senior Teachers, Program Managers and members of the Student Administration and Services Team will provide feedback and advice to students about their performance in a program of study. Feedback may be provided to individual students, a group of students or a whole class and it may be written or verbal in nature.
Some examples of feedback include:
Recorded voice comment provided in response to an essay submitted online.
It is a student’s responsibility to:
If you are unsure how or when feedback has been or will be provided, or you feel that feedback provided is not sufficient, you must approach relevant teaching or administrative staff and request additional feedback in a timely manner during the term and prior to any subsequent assessment task or the final assessment task for the unit. Claims that not enough feedback has been provided are not grounds for a grade appeal, especially where a student has not made any effort to approach staff about obtaining additional feedback in a timely manner. Students may seek general feedback about performance in a unit up to 6 months following results release.
If you have any problems contacting your teacher you must seek help from administrative staff in the 10 Macquarie Walk Level 2 Reception.
Feedback Sessions
Where relevant, a revision session may be scheduled after the results release. Revision sessions will usually be scheduled on Friday of Vacation Week. Details of the revision session will be provided in the teaching schedule section of the unit guide and reminders may be posted in iLearn. Where revision sessions are available, students are strongly encouraged to attend.
Contacting Teaching Staff Obtaining Help
Students may contact teaching staff at any time during the term by using the contact details provided in this guide. Students should expect a response within 1-2 business days. Teaching staff are unable to accept assessment submissions via email, all assessments must be submitted as outlined in the unit guide.
For all university related correspondence, students must use their official Macquarie University student email account which may be accessed via the Macquarie University Student Portal. Inquiries from personal email accounts will not be attended to.
Academic Honesty
All members of the University community must abide by the principles of academic honesty as per the Academic Honesty Policy. The fundamental principle is that all staff and students act with integrity in the creation, development, application and use of ideas and information. This means that:
All breaches of the Academic Honesty Policy are serious and penalties apply. Students should be aware that they may fail an assessment task, a unit or even be excluded from the University for breaching the Academic Honesty Policy.
Examples of some dishonest behaviours include deception, fabrication, obstruction, plagiarism and sabotage.
Deception includes:
Plagiarism involves using the work or ideas of another person, whether intentionally or not, and presenting this as your own without clear acknowledgement of the source of the work or ideas. This includes, any of the following:
Sabotage includes, but is not limited to, theft of work, destruction of library materials.
Fabrication involves creating false data, citation(s), or reports.
Obstruction involves intentionally impeding or interfering with another student’s academic work
The University may commence applicable disciplinary procedures if a person who breaches the Academic Honesty Policy.
Turnitin
To uphold principles of Academic Honesty, Macquarie University employs online anti-plagiarism Software called Turnitin. Turnitin compares electronically submitted papers to a database of academic publications, internet sources and other student papers that have been submitted to the system to identify matching text. It then produces an Originality Report which identifies text taken from other sources, and generates a similarity percentage.
All text based assessments must be submitted through Turnitin as per instructions provided in the unit guide. It is the student’s responsibility to ensure that work is submitted correctly prior to the due date. This includes verifying that correct files have been submitted as no special consideration will be given to students who have uploaded incorrect documents. No hard copies of assessments will be accepted and only Turnitin records will be taken as records of submission.
Multiple submissions may be possible via Turnitin prior to the final due date and time of an assessment task and originality reports may be made available to students to view and check their levels of similarity prior to making a final submission. Students are encouraged to use these reports to ensure that they do not breach they Academic Honesty Policy through high levels of similarity (plagiarism).
Students should note that the report on the initial submission will be immediate but on a second or subsequent submission it will take at least 24-36 hours for the similarity report to be generated. This may be after the due date so students should plan any resubmissions carefully. If you have not planned your submission time carefully and note high levels of similarity in your work after the due date, you can still resubmit your work, however a late penalty (20% per day) will apply. For instructions on how to resubmit your work please see “Resubmissions after the due date” section in this unit guide.
Teaching staff will use the report to judge whether plagiarism has occurred and whether penalties should apply for breaches of the Academic Honesty Policy. Any similar text identified by Turnitin will be considered carefully to see if it is indeed a breach of the Academic Honesty Policy.
There is no set percentage which indicates whether plagiarism has occurred; all identified matching text should be reconsidered carefully. If plagiarism has occurred or is suspected and resubmission is possible prior to the due date, students are advised to edit their work before making a final submission. Help may be sought from teaching staff and students may also access research resources provided by the library or Learning Skills.
Please refer to these instructions on how to submit your assignment through Turnitin and access similarity reports and feedback provided by teaching staff.
Should you have questions about Turnitin or experience issues submitting through the system, you must inform your teacher immediately. If the issue is technical in nature may also lodge a OneHelp Ticket, refer to the IT help page.
Submission of Drafts through Turnitin.
In some instances students may be required to submit drafts of written work via Turnitin prior to the due date of the assessment task so that they can receive feedback prior to making a final submission. If the student does not make a final submission prior to the due date, their draft will be counted as the final submission or late penalties applied.
Name | Weighting | Hurdle | Due |
---|---|---|---|
Workshop Tasks | 10% | No | Weeks 1-6 |
Assignment1:Database Modelling | 15% | No | Week 3, Friday, 11.55 pm |
Assignment2:Database Queries | 15% | No | Week 5, Thursday, 11.55 pm |
Assignment 3: DB Issues&Topics | 10% | No | Week 6, Lesson 3 & 4 |
Final Exam | 50% | Yes | MUIC Final Examination Period |
Due: Weeks 1-6
Weighting: 10%
Each week, Lessons 1 and 3 are dedicated to theory, and Lessons 2 and 4 are dedicated to practical workshops.
Participation in Workshops will be assessed through workshop tasks as per the instructions provided in class and in iLearn. In each workshop, students will receive 1 mark if they satisfy the participation requirement. There are ten workshop tasks in total. Please refer to the Unit Schedule below for the times of each workshop task.
A list of workshops tasks and marking criteria is available in iLearn. This is an individual task. If a student misses a practical workshop task, they should refer to the Special Consideration policy.
Due: Week 3, Friday, 11.55 pm
Weighting: 15%
In Week 3, students will submit an assignment, which will involve the development of a conceptual and logical data model for a given problem description. Detailed information about the assignment and marking criteria will be posted in iLearn. Students upload their assignments to an assignment link in iLearn as a zip folder in Week 3, Friday by 11.55 pm. This is an individual task. Feedback will be provided via iLearn and Gradebook. Please refer to the late submission section above.
Due: Week 5, Thursday, 11.55 pm
Weighting: 15%
In Week 5, students will submit an assignment, which will involve the design and execution of database queries to demonstrate knowledge of SQL. Detailed information about the assignment will be posted in iLearn. Students will be provided a text template, in which they will insert their SQL statements. They will then submit this text file to an assignment link in iLearn in Week 5, Thursday by 11.55 pm.
In Week 5, Lesson 4, each student will answer short-answer questions on their assignment submission, in the form of a 60-minute, paper-based test.
Assignment 2 is worth 15%. 5% will be allocated to the assignment submitted by the student, and the remaining 10% will be allocated to the test.
This is an individual task. Further information and marking criteria will be available in iLearn. Feedback will be provided in class and via iLearn. Please refer to the late submission section above.
Due: Week 6, Lesson 3 & 4
Weighting: 10%
For this assessment task, students will present a problem, possible solutions and a recommended solution relating to the lesson topics from Lesson 3 of Week 4 to Lesson 1 of Week 6.
The presentations will run in Week 6. Each student will have 4 minutes to present and 2 minutes to respond to questions. Detailed information about the assignment marking criteria will be posted in iLearn. Students are required to submit their work via an assignment link on iLearn as a PowerPoint file before the start of the Week 6, Lesson 3 & 4.
Students will also submit a 500-word report via Turnitin in iLearn by Week 6, Thursday, 11.55 pm. The report will incorporate information provided in the presentation. Further information and marking criteria will be provided in iLearn.
This is an individual task. The presentation is worth 5% and the report is worth 5%. Feedback will be provided in class. Please refer to the late submission section above.
Due: MUIC Final Examination Period
Weighting: 50%
This is a hurdle assessment task (see assessment policy for more information on hurdle assessment tasks)
This is a 3-hour (+10 minutes reading time), closed book, paper-based final exam, and an individual assessment task which may cover any topic in the unit. The exam will contain short answer questions.
The final examination in this unit is a hurdle requirement. You must get a mark of at least 40% in the examination to pass the unit. Where students have not obtained the minimum mark required, but have made a serious attempt at this assessment task, they will be given one further opportunity to meet the hurdle requirement. In this unit, a serious attempt is defined as obtaining at least 30%. Where a student is given the additional opportunity and does not attain at least 40%, they will be deemed not to have met the hurdle requirement and will subsequently not pass the unit.
Students are not allowed to bring mobile phones and other electronic devices; notes and course materials; dictionaries (paper/electronic); or calculators.
Details of the structure and format of the final examination paper will be made available to students prior to the start of the final examination period.
The final examination period is Week 7. Examinations will usually be scheduled on Tuesday and Wednesday of Week 7, however students must be available to take exams and submit assessments on any day of this week.
Please refer to the Special Consideration section of the unit guide.
Term Dates & College Calendar
Details of key dates during the term can be found on the Important Dates calendar.
Enrolment and Timetables
General timetable information is available via Macquarie University's Timetable page.
Students will be able to enrol in units and register for classes via eStudent and also view their personal timetable. It is the student’s responsibility to ensure that classes they have registered for do not clash.
Students are only permitted to attend classes in which they have registered via eStudent, unless they have written approval from the Students Services and Administration Manager. To seek approval, students must email muic@mq.edu.au or speak to a member of the Student Services and Administration Team in 10 Macquarie Walk Level 2 Reception. Approval will only be granted in exceptional circumstances.
The last day to enrol, add or change units is Tuesday of Week 1. Swapping groups is not possible after the enrolment period has concluded. The last day to enrol and register into classes is Tuesday of Week 1 and this must be finalised by the student in eStudent by the end of the day.
Guest Lecturer Presentations and Workshops
One or two Guest Lecturer Presentations and/or workshops may be scheduled during the term. These sessions will take place outside of regular class time, usually in a lecture theatre on campus. In the session a speaker (usually an expert or well-known academic in the field) will give a presentation on a particular topic related to the unit or field.
While attendance at guest lectures is not compulsory, and content covered is not examinable unless covered in regular classes, students are strongly encouraged to attend these sessions as they will:
Specific details including time and venue for Guest Lecturer Presentations and workshops will be posted in iLearn announcements and provided in class.
Recordings of these sessions may also be made available to students via iLearn.
Attendance Requirements – All Students
All students are expected to attend 100% of scheduled class time.
Attendance will be monitored in each lesson & students will be able to see their current attendance percentage to date and potential attendance percentage for each unit they have enrolled in via iLearn.
Where a student is present for a part of a lesson (for example arrives late, leaves early, leaves the class frequently, particularly for lengthy periods) the teacher reserves the right to mark a student absent for that part of the lesson.
In cases of unavoidable non-attendance due to illness or circumstances beyond their control, students should lodge an application for special consideration ask.mq.edu.au within 5 working days and supply relevant supporting documentation, even if they have not missed a formal assessment task. This will ensure that that appropriate records of unavoidable absences can be kept.
Public Holidays and Make-up Lessons
If any scheduled class falls on a public holiday a make-up lesson may be scheduled on an alternate day, usually on a Saturday or a weekday at a time when students do not have other classes scheduled. Alternatively, some make-up lessons might be delivered on-line.
In Term 1 there will be no public holidays.
Technology Used and Required
Bringing your own Device (BYOD)
Macquarie University is BYOD (Bring Your Own Device) friendly and it encourages students to bring their Windows or Mac devices to use on campus and during classes.
In some classes in this unit, you will need to have access to a mobile device, Office applications (Word, Excel and PowerPoint) and an Internet Browser of your choice. If you do not have your own device and computer access is required in a particular lesson, you may be able to borrow a laptop to use for the duration of the lesson.
As a Macquarie University student, you are entitled to free access to Microsoft Office Suite, which you can download for use on your device. Please visit the University’s software downloads page for full instructions.
If you do bring your own device, you will need to ensure that it is sufficiently charged as access to power points will not be available in the classrooms.
iLearn
iLearn is Macquarie's online learning management system and a principal teaching and learning resource which will be used throughout the term. Students must access iLearn at least 3 times per week to access important information including:
For any resource related iLearn questions contact your teacher. For any technical or support issues using iLearn, please contact the IT helpdesk (Ph. 02 9850 4357) or lodge a ticket using OneHelp.
Useful Study Resources
StudyWise is an iLearn resource created by Learning Skills, which is specifically designed to help you to manage your studies, strengthen your study techniques, write effective assignments and improve your English language proficiency. Once you enrol in StudyWISE, you can access it from your iLearn course list under the category "Student Support".
InfoWise will help you improve your research skills by teaching you how to use MultiSearch, decode citations, identifying key search terms and use advanced search techniques.
Lib Guides provide students with links to electronic sources and websites that are good starting points for research in different fields or disciplines.
MultiSearch will connect you to Macquarie University Library and allow you to search library resources, databases, unit readings and past exam papers
Academic Language and Learning Workshops are designed to help you with Study Skills, Assignment Writing, Referencing and Academic Language.
Research resources provide information about:
Numeracy Support is provided by the Numeracy Centre. Students who can attend these support classes on a drop in basis as required.
Week/ Lesson |
Topic/Content Covered |
Required Reading |
Associated Tasks |
Assessment Task |
---|---|---|---|---|
1.1 |
Introduction to unit and databases |
Hoffer 1 |
Learn about the following:
|
|
1.2 |
Introduction to unit and databases |
Hoffer 1 |
|
Workshop Task 1 (1%) |
1.3 |
Conceptual Database Modelling |
Hoffer 2-3 |
Learn about the following:
|
|
1.4 |
Conceptual Database Modelling |
Hoffer 2-3 |
|
Workshop Task 2 (1%) |
2.1 |
Conceptual Database Modelling |
Hoffer 2-3 |
|
|
2.2 |
Conceptual Database Modelling |
Hoffer 2-3 |
|
Workshop Task 3 (1%) |
2.3 |
Logical Database Design & Physical Database Design and Performance |
Hoffer 4-5 |
Learn about the following:
|
|
2.4 |
Logical Database Design & Physical Database Design and Performance |
Hoffer 4-5 |
|
Workshop Task 4 (1%) |
3.1 |
Introduction to SQL |
Hoffer 6 |
Learn about the following:
|
|
3.2 |
Introduction to SQL |
Hoffer 6 |
|
Workshop Task 5 (1%) |
3.3 |
Advanced SQL |
Hoffer 7 |
Learn about the following:
|
|
3.4 |
Introduction to SQL |
Hoffer 6 |
|
Assignment 1 due in iLearn, Friday, 11.55 pm (%15) Workshop Task 6 (1%) |
4.1 |
Database Application Development |
Hoffer 8-9 |
Learn about the following:
|
|
4.2 |
Advanced SQL |
Hoffer 7 |
|
Workshop Task 7 (1%) |
4.3 |
Data Warehousing |
Hoffer 8-9 |
Learn about the following:
|
|
4.4 |
Advanced SQL |
Hoffer 7 |
|
Workshop Task 8 (1%) |
5.1 |
Data Quality And Integration |
Hoffer 10 |
Learn about the following:
|
|
5.2 |
Introduction and Advanced SQL |
Hoffer 6-7 |
Task 9 (1%) Assignment -2 due in iLearn, Thursday 11.55 pm (5%) |
|
5.3 |
Data and Database Administration |
Hoffer 12-13 |
Learn about the following:
|
|
5.4 |
Database Application Development, Data Warehousing |
Hoffer 8-13 |
|
Assignment 2 in-class test (10%) |
6.1 |
Big Data & Analytics |
Hoffer 11 |
Learn about the following:
|
|
6.2 |
Data Quality And Integration and Data and Database Administration. |
Hoffer 8-13 |
|
Workshop Task 10 (1%) Assignment 3 Report due in Turnitin by Thursday 11.55 pm |
6.3 |
Revision |
Assignment -3 (Presentations) (%10) |
||
6.4 |
Revision |
Assignment -3 (Presentations) |
||
7 |
Final Exam Week |
|||
8 |
Vacation Week |
Macquarie University policies and procedures are accessible from Policy Central (https://staff.mq.edu.au/work/strategy-planning-and-governance/university-policies-and-procedures/policy-central). Students should be aware of the following policies in particular with regard to Learning and Teaching:
Undergraduate students seeking more policy resources can visit the Student Policy Gateway (https://students.mq.edu.au/support/study/student-policy-gateway). It is your one-stop-shop for the key policies you need to know about throughout your undergraduate student journey.
If you would like to see all the policies relevant to Learning and Teaching visit Policy Central (https://staff.mq.edu.au/work/strategy-planning-and-governance/university-policies-and-procedures/policy-central).
Macquarie University students have a responsibility to be familiar with the Student Code of Conduct: https://students.mq.edu.au/study/getting-started/student-conduct
Results shown in iLearn, or released directly by your Unit Convenor, are not confirmed as they are subject to final approval by the University. Once approved, final results will be sent to your student email address and will be made available in eStudent. For more information visit ask.mq.edu.au.
Academic Honesty
Using the work or ideas of another person, whether intentionally or not, and presenting them as your own without clear acknowledgement of the source is called Plagiarism.
Macquarie University promotes awareness of information ethics through its Academic Honesty Policy. This means that:
All breaches of the Academic Honesty Policy are serious and penalties apply. Students should be aware that they may fail an assessment task, a unit or even be excluded from the University for breaching the Academic Honesty Policy.
Assessment Policy
Students should familiarise themselves with their responsibilities under the Assessment Policy, and notably Schedule 4 (Final Examination Requirements).
Disruptions to studies
The Disruption to Studies Policy applies only to serious and unavoidable disruptions that arise after a study period has commenced. Students with a pre-existing disability/health condition or prolonged adverse circumstances may be eligible for ongoing assistance and support. Such support may be sought through Campus Wellbeing and Support Services.
To be eligible for Special Consideration, a student must notify the University of a serious and unavoidable disruption within five (5) working days of the commencement of the disruption (Disruption to Studies notification). All Disruption to Studies notifications are to be made online via the University’s Ask MQ system. A Disruption to Studies notification must be supported by documentary evidence.
Students should note that in cases of medical disruptions they must see a professional authority as outlined in the Disruptions to Studies Supporting Evidence Schedule and present a Professional Authority Form. The PAF is the preferred form of evidence for medical/psychological /mental health disruptions. However, health documents that clearly indicate the duration and specific nature of impact on studies will also be considered as evidence. Overseas students may use their OSHC insurance for the purpose of seeing a registered healthcare professional.
In submitting a Disruption to Studies Notification, a student is acknowledging that they may be required to undertake additional work. The time and date, deadline or format of any required extra assessable work as a result of a disruption to studies notification is not negotiable and in submitting a disruption to studies notification, a student is agreeing to make themselves available to complete any extra work as required. This means that as a result of special consideration being awarded, a student may be required to complete a different type of assessment for example an exam instead of a presentation or vice versa.
Macquarie University operates under a ‘Fit to Sit’ model. This means that in sitting an exam and/or in-class test or otherwise submitting an assessment, a student declares themselves fit to do so. Therefore, if a student is feeling unfit to sit the exam or test, or otherwise submit the assessment (as the case may be), they should not do so. If a student sits an exam or test, or otherwise submits an assessment, knowing that they are unfit to do so, they will not be granted Special Consideration.
It is the responsibility of the student to determine whether they are fit to sit an examination or test or otherwise submit an assessment, or whether a Disruption to Studies claim should be submitted for non-participation.
The student will retain all original documentation submitted regarding the disruption, and must understand that this may be requested by the University at any time. In this event, students will be provided 10 business days to submit the original documentation.
Please refer to the Disruption to Studies Policy for further details.
Final Examination Script Viewings
A student may request to view their final examination script once results have been released but scripts remain the property of Macquarie University.
Students should view their final examination paper prior to submitting a grade appeal, if this is relevant to their case. The viewing will be conducted in a secure location under supervision.
To request a final examination script viewing, please email: muic@mq.edu.au and write ‘script viewing’ in the subject heading.
Scripts may be reviewed for up to 6 months following the results release date for the relevant Term.
Grade Appeals
A student who has been awarded a final grade for a unit has the right to appeal that grade as outlined in the Grade Appeal Policy. Grade appeals apply to the final mark and grade a student receives for a unit of study. They do not apply to results received for individual assessment tasks.
Grade appeals must be submitted via ask.mq.edu.au within 20 working days from the published result date for the relevant unit. Before submitting a Grade Appeal, please ensure that you read the Grade Appeal Policy and note valid grounds for appeals.
Students are expected to seek feedback on individual assessment tasks prior to the award of a final grade. Students also have the right to request generic feedback from the teaching staff on their overall performance in the unit, including in a final examination. This can be done at any time in the six month period starting from the day on which the final grade of the relevant unit is published.
Course Progression
The College closely monitors students' academic progress as per the Progression Policy for Programs delivered by Macquarie University International College.
To maintain Satisfactory Academic Progress, a student must successfully complete (pass) 50% or more of their enrolled units in a Term of study. To successfully complete a unit, students must obtain a passing grade and meet any other requirements to pass listed in the unit guide.
Students who fail to make Satisfactory Academic Progress will be classified as "at risk" and will be notified in writing. At-risk students may be required to undergo academic counselling, undertake certain initiatives or have conditions placed upon their enrolment to help them make satisfactory progress.
Students must also pass 50% or more of the units in 2 or more terms in order to meet Minimum Rate of Progress (MRP) requirements. A student is deemed not to be making Minimum Rate of Progress if they fail more than 50% of their enrolled units in two consecutive Terms of study, or if they have failed more than 50% of their units after studying two or more terms.
Any domestic student who has been identified as not meeting Minimum Rate of Progress requirements will be issued with an Intention to Exclude letter and may subsequently be excluded from the program.
Any international student who has been identified as not meeting MRP will be subject to exclusion from the program and be issued with an Intention to Report letter and may subsequently be reported to the Department of Home Affairs for not meeting visa requirements. International students must comply with the Progression Policy of the College in order to meet the conditions of their visa.
Macquarie University provides a range of support services for students. For details, visit http://students.mq.edu.au/support/
Learning Skills (mq.edu.au/learningskills) provides academic writing resources and study strategies to improve your marks and take control of your study.
Students with a disability are encouraged to contact the Disability Service who can provide appropriate help with any issues that arise during their studies.
For all student enquiries, visit Student Connect at ask.mq.edu.au
For help with University computer systems and technology, visit http://www.mq.edu.au/about_us/offices_and_units/information_technology/help/.
When using the University's IT, you must adhere to the Acceptable Use of IT Resources Policy. The policy applies to all who connect to the MQ network including students.
Our graduates will also be capable of creative thinking and of creating knowledge. They will be imaginative and open to experience and capable of innovation at work and in the community. We want them to be engaged in applying their critical, creative thinking.
This graduate capability is supported by:
We want our graduates to have emotional intelligence and sound interpersonal skills and to demonstrate discernment and common sense in their professional and personal judgement. They will exercise initiative as needed. They will be capable of risk assessment, and be able to handle ambiguity and complexity, enabling them to be adaptable in diverse and changing environments.
This graduate capability is supported by:
Our graduates will take with them the intellectual development, depth and breadth of knowledge, scholarly understanding, and specific subject content in their chosen fields to make them competent and confident in their subject or profession. They will be able to demonstrate, where relevant, professional technical competence and meet professional standards. They will be able to articulate the structure of knowledge of their discipline, be able to adapt discipline-specific knowledge to novel situations, and be able to contribute from their discipline to inter-disciplinary solutions to problems.
This graduate capability is supported by:
We want our graduates to be capable of reasoning, questioning and analysing, and to integrate and synthesise learning and knowledge from a range of sources and environments; to be able to critique constraints, assumptions and limitations; to be able to think independently and systemically in relation to scholarly activity, in the workplace, and in the world. We want them to have a level of scientific and information technology literacy.
This graduate capability is supported by:
Our graduates should be capable of researching; of analysing, and interpreting and assessing data and information in various forms; of drawing connections across fields of knowledge; and they should be able to relate their knowledge to complex situations at work or in the world, in order to diagnose and solve problems. We want them to have the confidence to take the initiative in doing so, within an awareness of their own limitations.
This graduate capability is supported by:
We want to develop in our students the ability to communicate and convey their views in forms effective with different audiences. We want our graduates to take with them the capability to read, listen, question, gather and evaluate information resources in a variety of formats, assess, write clearly, speak effectively, and to use visual communication and communication technologies as appropriate.
This graduate capability is supported by:
Weekly face to face contact for this unit will be 8 hours (48 hours per term).
There will be 4 lessons per week consisting of 2X2 hours in a classroom and 2x2 hour workshop in the MUIC PC Laboratory.
There are also 2 x two-hour workshops scheduled outside of class time.
The following texts have been prescribed for this unit.
Jeffrey A. Hoffer; Ramesh Venkataraman; Heikki Topi, 2016, Modern Database Management,12th edition, Publisher: Pearson.
Print ISBN: 9780133544619, 0133544613, eText ISBN: 9780134402109, 0134402103
Texts will be available for purchase from the Co-Op Bookshop located in the Campus Hub Building C10A, Level One, Phone: 8986 4000.
All students should ensure that they have access to the prescribed text(s) from the start of the Term as failure to do so could jeopardise their academic progress in this unit.
Other editions or formats of the above resource(s) may be acceptable, but you must students must consult teaching staff prior to purchasing these.