Unit convenor and teaching staff |
Unit convenor and teaching staff
Lecturer
Charanya Ramakrishnan
Contact via charanya.ramakrishnan@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Convenor
Mehmet Orgun
Contact via mehmet.orgun@mq.edu.au
E6A319
Send email
Lecturer
Nader Hanna
Contact via nader.hanna@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Tutor
Amara Atif
Contact via amara.atif@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Tutor
Hedieh Ranjbartabar
Contact via hedieh.ranjbartabar@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Tutor
Hijab Alavi
Contact via hijab.alavi@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Tutor
Mahmud Hasan
Contact via mahmud.hasan@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Mahmood Yousefiazar
Contact via mahmood.yousefiazar@mq.edu.au
Lab - E6A123
See HELP101 schedule/ send email
Tutor
Rezwan Huq
Lab - E6A123
See HELP101 schedule/ send email
|
---|---|
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 nomalisation techniques, and implementing and utlising 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:
A more detailed description of each task is given below.
Workshops are combined practicals and tutorials. Each week your attendance will be recorded in your scheduled workshop and you will receive 1 mark for attendance & active participation. There are 12 weeks of workshops, however, the total attendance mark is limited to 10 throughout the semester.
Attendance at workshops in this unit is NOT a hurdle requirement. However, if you do not attend all the workshops, you are unlikely to have sufficient knowledge to pass the exam or sufficient total marks to be able to pass the unit.
There are 3 assignments.
The first two assignments will be submitted and marked online. The third assignment will be marked in the tutorial class by your tutor.
You are encouraged to:
If you cannot submit on time because of illness or other circumstances, please contact the lecturer before the due date.
No extensions will be granted. Late assignments will be accepted up to 72 hours after the submission deadline. There will be a deduction of 20%* of the total available marks made from the total awarded mark for each 24 hour period or part thereof that the submission is late (for example, 25 hours late in submission – 40% penalty). This penalty does not apply for cases in which an application for disruption to studies is made and approved.
Assignment submission in this unit is NOT a hurdle requirement. However, if you do not make a reasonable attempt at all three assignments, you are unlikely to have sufficient knowledge to pass the exam or sufficient total marks to be able to pass the unit.
For this unit, a final examination will test your learning and knowledge of learning outcomes #1, #2, #3 and #4. The final examination accounts for 50% of the final mark.
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. If you get a mark of at least 30% in your first attempt at the final examination you will be given a second and final attempt to resit and pass the examination.
Second-chance hurdle examinations will be offered in the week of December 11th - 15th. You must make yourself available during that week to take advantage of this opportunity.
Regarding the examination process, note that
Four standards, namely Developing, Functional, Proficient, and Advanced, summarize as many different levels of achievement. Each standard is precisely defined to help students know what kind of performance is expected to deserve a certain grade. Typically, Developing corresponds PC, Functional is for P, Proficient for Cr, and Advanced covers D and HD. The standards corresponding to the learning outcomes and criteria of this unit are given below:
|
Standards |
|||
Criteria for L.O. #1 |
Developing |
Functional |
Proficient |
Advanced |
Data Analysis and Modeling |
Has limited understanding and ability to apply analysis, modeling and programming concepts and techniques. Assignment and exam performance shows functional level of understanding on some but not all assessment tasks. |
Demonstrates knowledge of terms and core concepts. Assignment and exam performance shows basic understanding and ability to apply most of the data modeling and implementation concepts and techniques. |
Understands most of the data modelling concepts and can apply them appropriately. Implements most of the tasks specified. Assignment and exam performance shows good understanding of data analysis and modeling concepts and application of these skills in conceptual database design. |
Shows depth of understanding of data analysis and modeling concepts and implements all tasks as specified with professional presentation. Assignment and exam performance shows critical thought and comprehension of the software development big picture and related issues and activities. |
Criteria for L.O. #2 |
|
|
|
|
Data Base |
Inaccurate reproduction of definitions and ideas, show limited understanding of database principles. Able to apply some of the basic database functionality in the assignments and final exam. |
Reproduce definitions and ideas, show some breath of understanding of Database principles. Able to apply most of the basic database functionality in the assignments and final exam. |
Show breath of understanding of database principles. Able to apply most of database functionality in the assignments and final exam. |
Apply terminology and ideas in some new contexts, show some depth of understanding of database principles. Able to apply most of database functionality in the assignments and final exam. |
Criteria for L.O. #3 |
|
|
|
|
Ethics |
Assessment performance shows limited understanding of what ethics is. |
Assessment performance shows an understanding of what ethics involves relating to sustainability and the environment. |
Assessment performance shows an appreciation of the impact of ethics on professional practice as well as ethical decision making relating to sustainability and the environment. |
Assessment performance shows a deep appreciation of the impact of ethics on professional practice as well as ethical decision making relating to sustainability and the environment. |
Criteria for L.O. #4 |
|
|
|
|
Use of modeling tools |
Assignment and exam performance shows limited understanding of data analysis and data modelling techniques and tools for introductory level database design and requirements specification. |
Assignment and exam performance shows basic understanding and ability to use data analysis and modeling tools. |
Assignment and exam performance shows good understanding of data analysis and modeling tools in conceptual database design. |
Assignment and exam performance shows depth of understanding of data analysis and modeling tools. |
Grading
For each task, those standards translate into a mark and the different component marks are added up. The final mark for the unit will be calculated by combining the marks for all assessment tasks according to the percentage weightings shown in the assessment summary. You will then be given a grade that reflects your achievement in the unit.
Name | Weighting | Hurdle | Due |
---|---|---|---|
Workshop Attendance | 10% | No | Weeks 2-13 |
Assignment1:Database Modelling | 15% | No | 1/09/2017 Friday at 5:00 PM |
Assignment2:Database Queries | 15% | No | 6/10/2017 Friday at 5:00 PM |
Assignment 3: DB Issues&Topics | 10% | No | In week 12 and 13 tutorials |
Final Exam | 50% | Yes | See Exam Timetable |
Due: Weeks 2-13
Weighting: 10%
Workshops are combined practicals and tutorials. Each week your attendance will be recorded in your scheduled workshop and you will receive 1 mark for attendance & active participation. The total attendance mark is limited to 10 throughout the semester.
Due: 1/09/2017 Friday at 5:00 PM
Weighting: 15%
This assignment will involve the development of a conceptual, logical and physical data model for a given problem description.
Due: 6/10/2017 Friday at 5:00 PM
Weighting: 15%
This assignment involves the design and execution of database queries to demonstrate knowledge of SQL
Due: In week 12 and 13 tutorials
Weighting: 10%
This assessment involves the presentation of a problem, possible solutions and a recommended solution relating to the lecture topics in Weeks 8-12.
Due: See Exam Timetable
Weighting: 50%
This is a hurdle assessment task (see assessment policy for more information on hurdle assessment tasks)
Final Exam
ISYS114 is taught via lectures, tutorials and practicals. The feedback that you receive also plays an important role in your learning. Make sure you read the feedback you are given, attend lectures which provide assignment feedback and compare your solution with sample solutions provided.
Lectures are used to introduce new material, provide motivation and context for your study, guide you in what is important to learn and explain more difficult concepts.
Tutorials and practicals are small group classes which give you the opportunity to interact with your peers and with a tutor who has a sound knowledge of the subject. This also gives you a chance to practice your technology skills.
You have many opportunities to seek for and to receive feedback. During lectures, you are encouraged to ask the lecturer questions to clarify anything you might not be sure of. You may also arrange to meet with your tutor or the lecturer or attend the consultation hours of any tutor. Each week, you will be given activities and problems to solve in the tutorials and practicals. This will at times involve contributing to a group of students and presenting solutions to the class. The final assignment involves working in pairs and giving a presentation in your tutorial class. The comments and the solutions provided will help you to understand the material in the unit, prepare you for the work in assignments as well as for the final exam. It is important that you keep up with these problems every week. Assignments have been especially designed to deliver continuous feedback on your work.
Each week you should:
Lecture notes are made available each week but these notes are intended as an outline of the lecture only and are not a substitute for your own notes or reading of the textbook or other additional material.
Classes
There are 2 hours of lectures per week.
Each week you should attend two hours of lectures (or watch the recorded lecture), and a 2 hour Workshop (including a tutorial and a practical). For details of days, times and rooms consult the timetables webpage.
Note that tutorials and practicals commence in week 2.
Please note that you should submit two assignments and give a presentation in the workshop and attend the tutorials and practicals. These activities are designed to help you learn the unit material and choosing not to do these activities may result in you failing the unit.
Digital recordings of lectures are available through the web page of the unit on ilearn.
The textbook for ISYS114 this semester is:
Modern Database Management,
https://www.vitalsource.com/referral?term=9780134402109
MS Word, PowerDesigner, SQLDeveloper
The web page for this unit can be found at http://ilearn.mq.edu.au/course/view.php?id=29757
The unit makes use of discussion boards hosted within iLearn. Please post questions of general interest there (for example, about assessment tasks), they are monitored by the unit staff but students may also provide answers.
Day lectures will be held on Tues 2-4pm E7B in Mason Theater. Evening lectures will be held on Mon 6-8pm in X5B T1.
In the table below, for each week, the lecturer, the topics to be covered and the textbook references are given.
Week |
Lecturer |
Topic |
Reading/Chapter |
1 |
Hanna |
Introduction to unit and databases |
Hoffer 1 |
2 |
Ramakrishnan |
Conceptual Data Modelling |
Hoffer 2-3 |
3 |
Ramakrishnan |
Logical Data Modelling |
Hoffer 4 |
4 |
Ramakrishnan |
Physical Data Modelling |
Hoffer 5 |
5 |
Ramakrishnan |
Introduction to SQL, Introduction to Assignment 2 Assignment1 due |
Hoffer 6 |
6 |
Ramakrishnan |
Introduction to SQL
|
Hoffer 6 |
7 |
Ramakrishnan |
Advanced SQL Feedback on Assignment 1 |
Hoffer 7 |
8 |
Hanna |
Database Development I: Database Application Development and Data Warehousing Assignment 2 due |
Hoffer 8-9 |
9 |
Hanna |
Data Quality and Integration
|
Hoffer 10 |
10 |
Hanna |
Advanced Database Topics I: Data and Database Administration Feedback on Assignment 2 |
Hoffer 12, online Hoffer 13 |
11 |
Hanna |
Big Data and Analytics |
Hoffer 11 |
12 |
Hanna |
GreenIT Presentations in Tutorials |
See online material |
13 |
ALL |
Revision, Exam Preparation Presentations in Tutorials |
Macquarie University policies and procedures are accessible from Policy Central. Students should be aware of the following policies in particular with regard to Learning and Teaching:
Academic Honesty Policy http://mq.edu.au/policy/docs/academic_honesty/policy.html
Assessment Policy http://mq.edu.au/policy/docs/assessment/policy_2016.html
Grade Appeal Policy http://mq.edu.au/policy/docs/gradeappeal/policy.html
Complaint Management Procedure for Students and Members of the Public http://www.mq.edu.au/policy/docs/complaint_management/procedure.html
Disruption to Studies Policy (in effect until Dec 4th, 2017): http://www.mq.edu.au/policy/docs/disruption_studies/policy.html
Special Consideration Policy (in effect from Dec 4th, 2017): https://staff.mq.edu.au/work/strategy-planning-and-governance/university-policies-and-procedures/policies/special-consideration
In addition, a number of other policies can be found in the Learning and Teaching Category of Policy Central.
Macquarie University students have a responsibility to be familiar with the Student Code of Conduct: https://students.mq.edu.au/support/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.
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 have enquiring minds and a literate curiosity which will lead them to pursue knowledge for its own sake. They will continue to pursue learning in their careers and as they participate in the world. They will be capable of reflecting on their experiences and relationships with others and the environment, learning from them, and growing - personally, professionally and socially.
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:
As local citizens our graduates will be aware of indigenous perspectives and of the nation's historical context. They will be engaged with the challenges of contemporary society and with knowledge and ideas. We want our graduates to have respect for diversity, to be open-minded, sensitive to others and inclusive, and to be open to other cultures and perspectives: they should have a level of cultural literacy. Our graduates should be aware of disadvantage and social justice, and be willing to participate to help create a wiser and better society.
This graduate capability is supported by:
We want our graduates to be aware of and have respect for self and others; to be able to work with others as a leader and a team player; to have a sense of connectedness with others and country; and to have a sense of mutual obligation. Our graduates should be informed and active participants in moving society towards sustainability.
This graduate capability is supported by:
Please see the passing requirements for the unit at the end of the Assessment Section under "Grading". Note the existence of a hurdle requirement (the final exam).
We are using edition 12 textbook rather than edition 11. Students may still use edition 11 if they have already purchased it.