itech1006-database management systems

Course Description

Title: Database Management Systems

Code: ITECH1006

Formerly: CP611

Faculty / Division: Faculty of Science and Technology

Teaching Period: 2015/07

Author: Mohammad Awrangjeb

Program Level:

AQF Level of Program

5 6 7 8 9 10

Level

Introductory

Intermediate

Advanced

Pre-requisites: Nil

Co-requisites: Nil

Exclusions: (CP611 and CP858 and ITECH5006)

Credit Points: 15

ASCED Code: 020303

Organisation:

Delivery Mode:

Regular semester

Structure:

This course consists of one two-hour lecture, one one-hour tutorial and one one-hourlaboratory.

Staff:

Type Name Room Telephone Email

Lecturer Mazher Hussain 216 0425533266 [email protected]

Tutor Belal Chowdhury 8600 6700 [email protected]

Course Coordinator Mohammad Awrangjeb T140 51226462 [email protected]

u

fdlGrades UD_ITECH1006_2015/07_2015-03-28 13:21:25 CRICOS Provider Number: 00103D Page: 1/7

Course DescriptionITECH1006 DATABASE MANAGEMENT SYSTEMS

FedUni Lecturer Mohammad Awrangjeb [email protected]

u

Timetable:

Type Day Time Room Staff

Lecture Tuesday 9:00 - 11:00 A.M 216 Mazher Hussain

Tutorial 1 Tuesday 11:00 - 1:00 P.M 508 Mazher Hussain

Tutorial 2 Tuesday 11:00 - 1:00 P.M 503 Belal Chowdhury

Tutorial 3 Tuesday 11:00 - 1:00 P.M 502 Amita

Additional consultation time can be booked by contacting the staff member concerned directly.

Learning Outcomes:

Knowledge:

K1. explain usage of a number of different types of information systems in commercial use;K2. demonstrate an understanding of emerging trends in database technology;K3. describe the different models of database management systems (hierarchical, network,

relational, object);K4. design a relational database for a provided scenario utilising tools and techniques

including ER diagrams, relation models and normalisation;K5. describe relational algebra and its relationship to Structured Query Language (SQL);

Skills:

S1. interpret entity-relationship diagrams to implement a relational database;S2. demonstrate skills in designing and building a database application using a

commercially available database management system development tool;S3. use a query language for data manipulation;

Application of knowledge and skills:

A1. design and implement a relational database using a database management system;A2. utilise a query language tools and techniques to obtain data and information from a

database;

Values and Graduate Attributes:

Values:

V1. appreciate the need for a level of professionalism when designing and implementing database solutions.

Graduate Attributes:

Attribute Brief Description Focus

Continuous Learning Utilising a blended learning approach facilitated by case studies and

scenarios requiring the storage and management of data.

Medium



Self Reliance Students will participate in self-directed learning environment to

develop their technical and theoretical expertise in the field of

database management systems.

Medium

Engaged Citizenship Students will utilise database management tools currently in use

within industry.

Low

Social Responsibility Students will be introduced to the concepts of information privacy and

security.

Medium

Content:

Scope:

Topics may include:

• Introduction to database management systems, advantages of the database approach,data modelling, schemas, access and security provisions for multi-user databases.

• The relational model, primary and foreign keys, referential integrity, relational algebra,structured query language and normalisation.

• Database systems in the context of information systems, types of information systems,organisation and management theories.

• Human computer interaction fundamentals, visual design standards. • Database maintenance operations, retrieving information from a database, logical

transactions, locking and avoidance of deadlocks, logging, backup and recovery.

Sequence:

The following is an approximate guide to the sequence of topics in this course.

Week(s) Topic(s)

1 - 3 Database principles and concepts, E-R Modelling, Normalisation

4 - 6 Relational Algebra / Structured Query Language

7 - 9 Database Life Cycle / DBA, Information Systems / Application Development

10 - 12 Distributed Databases, Transaction Processing, Recovery, Security, Review

Learning Tasks and Assessment:

Participation in lectures, tutorials and computer laboratory classes. Completion of all tutorialand laboratory worksheets for the semester.

Students are expected to spend time regularly out of scheduled classes, reading referencematerial as required, reviewing topics already covered in lectures and preparing forforthcoming topics and laboratory classes and completing assessment tasks.

Assessment for this course will be based on a number of tasks. These may include writtenassignments, programming tasks and laboratory exercises covering the systemsdevelopment and programming design. An end of semester examination is based on allaspects of the course.

Learning Outcomes Assessed Assessment Task Assessment Type



K4, K5, S1, S2, S3, A1, A2 Development of skills and deepening of

understanding

Assignments, tutorial questions,

laboratory exercises

K1, K2, K3, K4, K5, S2, S3 Participation in class activities, supplementary

reading and other activities as suggested in

lectures

Examination(s)/Test(s)

The following tasks will be graded.

Task Released Due Weighting Type

Tutorial Part 1 Week 1 In timetabled tutorial

(Week 5)

4% A

Tutorial Part 2 Week 1 In timetabled tutorial

(Week Various)

6% A

Assignment 1 Week 2 Thu, May 7, 2015 - 17:00

(Week 7)

20% A

Assignment 2 Week 8 Thu, Jun 4, 2015 - 17:00

(Week 11)

20% A

Examination Exam period End of exam 50% B

Students are expected to spend time regularly out of scheduled classes, reading referencematerial as required, reviewing topics already covered in lectures and preparing forforthcoming topics and tutorial/laboratory classes and completing assessment tasks.Assessment for this course will be based on a number of tasks. Participation in tutorials andcomputer laboratory classes. Completion of all weekly tutorial and laboratory worksheets.Working with other students and sharing understanding in labs and tutorials is important. Assignments are based on and extend the experience gained in the labs and tutorial work.The end of semester examination samples the whole course and is designed to testunderstanding, not memory. The best preparation for the exam is to participate fully in allclasses and assessment tasks, to consult the textbook and other references provided and, ifnecessary, to seek assistance from fellow students and teaching staff if the course contentis not clear.

Final Exam:

The final exam in this course will take place in the end of term exam period. It will be a 3hour exam and students will NOT be permitted to take in any materials.

Assessment Criteria:

In order to receive a passing grade in this Course, students must receive a passing mark inthe invigilated (Type B) assessment tasks and an overall passing mark in the combinedresult of all (Type A and Type B) assessment tasks. Additionally, students who aredetermined to be 'at risk' may be subject to extra requirements such as minimumattendance. Failure to satisfy these extra requirements may result in an automatic fail in thecourse.



Topics Assessed :

All topics covered during this course are subject to assessment.

`Turnitin` Submission:

In order to verify the originality of assessment tasks, students may be required to useTurnitin plagiarism software to check their assignment before submission. Full details ofrequirements and how to use Turnitin will be provided by the Course Coordinator.

Late Assignment:

For all assessment items handed in after the official due date without an agreed extension, a10% penalty will be applied to the total mark for each day (or part thereof) late after the duedate (including weekends and public holidays).

Extensions:

If students are adversely affected by life circumstances then they may, at the discretion ofthe Course Coordinator, be granted up to one week as an extension on the due date. Ifstudents' work is affected to a substantial degree, requiring more than the few daysextension, then they may apply for Special Consideration.

Special Consideration:

In the case of serious illness, loss or bereavement, hardship or trauma students may begranted special consideration. In cases of absence from a scheduled examination orlateness in submitting an assignment, it is the responsibility of the student (or other party) tonotify the Course Coordinator preferably on the day. Application for Special Considerationshould be made to the School Administration Office of your course or your Partner ProviderOffice not later than three days after the date of the examination or submission of thecomponent of assessment. Deferred examinations will be held after the end of the normalexamination period. For more information on the special consideration policy and to accessthe appropriate forms, seehttp://policy.federation.edu.au/student_services_and_administration/enrolment/special_consideration/ch01.php

Exam Eligibility:

To be eligible to sit for the examination a student must have undertaken and submitted atleast one prior assessment task (worth more than 10%) for this Course.

Available Grades:

A list of the available grades, a description of the corresponding required studentperformance and the required percentages for the Course is given in the UniversityHandbook. https://federation.edu.au/students/essential-info/administration/exams/results The Course Coordinator may standardise raw marks before allocating grades.



Plagiarism:

It is important to learn from the work of others and you are encouraged to explore the library,World Wide Web resources and have discussions with other students. However work forassessment must be entirely the student's own work. Plagiarism is the presentation of theexpressed thought or work of another person as though it is one's own without properlyacknowledging that person. You must not allow other students to copy your work and musttake care to safeguard against this happening. In cases of copying, normally all studentsinvolved will be penalised equally; an exception will be if you can demonstrate the work isyour own and you took reasonable care to safeguard against copying. Plagiarism is aserious offence. As set out in the University Regulation 6.1.1 students who are caughtplagiarising will, for a first offence, be given a zero mark for that task. A second offence willresult in a failing grade for the Course(s) involved and any subsequent offence will bereferred to the Student Discipline Committee. More information about the plagiarism policyand procedure for the university can be found athttp://federation.edu.au/students/learning-and-study/online-help-with/plagiarism

Academic Regulations:

Supplementary information concerning teaching, learning, and assessment may be providedfrom time to time in response to unforeseen circumstances. This may include changes intimes or location of classes, order of the schedule or due dates for assignments.Announcement of these matters in classes and placement of a notice on the course Moodlepage shall be deemed to be official notification.

FedUni has a range of educational policies, procedures and guidelines, which you can findat http://policy.federation.edu.au/category_list.php?catalogue_id=115

Student Support:

The University provides many different kinds of services to help you gain the most from yourstudies. You can see the list of Student Services contacts at http://federation.edu.au/students#Assistance_support_and_servicesStudents who have a disability or medical condition are welcome to contact the DisabilityLiaison Unit to discuss academic support services. The role of the DLU is to support thedevelopment of a learning and working environment that maximise participation in Universitylife by students with a disability

Learning Management System:

This course makes use of Moodle to support your learning. You can access Moodle fromthe FedUni home page or at https://moodle.federation.edu.au/login/index.php If you do nothave access for this course you should notify your course co-ordinator immediately

Presentation of Academic Work:

FedUni General Guide to Referencing


http://federation.edu.au/__data/assets/pdf_file/0015/164121/FedUni-General-Guide-to-Referencing-2014.pdf


Materials:

Reading:

Textbooks:

Coronel, C., Morris, S. and Rob, P. (2014). Database Systems: Design Implementation,and Management, 11th Edition. Cengage Learning.

References:

Connolly, Thomas and Begg, Carolyn. (2007). A Practical Approach to Design,Implementation and Management. Addison Wesley.

Date, C. J. (1995). An Introduction to Database Systems. Addison-Wesley.

Pratt, Philip J. (2003). A Guide to SQL. Thomson Course Technology.

Pratt, P.J. & Adamski, J.J. (2008). Concepts of Database Management (6th Edition).Thomson Course Technology .

Ullman, Jeffrey D. and Widom, Jennifer. (2002). A First Course in Database Systems.Prentice Hall.

Rob, P., & Coronel, C. (2002). Database Systems: Design Implementation, andManagement. Cengage Learning.

SAFARI:

Hernandez, M.J. (2003). Database Design for Mere Mortals: A Hands-On Guide toRelational Database Design. Addison-Wesley. Available here.

Riordan, R.M. (2005). Designing Effective Database Systems. Addison-WesleyProfessional. Available here.

Petersen, J. (2002). Absolute Beginner`s Guide to Databases. Que. Available here.

Note that some material in lectures, assignments and other resources provided to studentsmay contain direct quotations from the text book(s) and references listed.

Adopted Reference Style:

APA


http://proquest.safaribooksonline.com/0201752840

http://proquest.safaribooksonline.com/0321290933

http://proquest.safaribooksonline.com/078972569X

itech1006-database management systems

Documents