Monash university




Скачать 16.17 Kb.
НазваниеMonash university
Дата26.09.2012
Размер16.17 Kb.
ТипДокументы
MONASH UNIVERSITY



Faculty of Information Technology

School of Computer Science & Software Engineering


CSE 2316/3316 DATABASE MANAGEMENT SYSTEMS

SEMESTER 2, 2005


SUBJECT: CSE 2316/3316 Database Management Systems


PRE-REQUISITES: CSE1303, CSE1030 or equivalent.


LECTURER: Rama (M V Ramakrishna)

Phone: 9905 2470 email: rama at csse.monash.edu.au


LECTURE TIMES: Tue: 15:00 to 16:00, Thu: 13:00 to 14:00 in 25/S4


CONSULTATIONS: Tue: 14:00 to 14:50 and Thu: 12:00 to 12:50 in 75.174

See the subject home page for any changes to this information.


PRESCRIBED TEXT: Ramakrishnan, Raghu and Gehrke, Database Management Systems,

Second/third Edition, McGraw-Hill.


REFERENCE: Date C. J., An Introduction to Database Systems, 7/8th edn., Addison-Wesley

(Addison-Wesley Longman, 8th ed. In 2004).

Elmasri, R. and S. B. Navathe, Fundamentals of Database Systems, 4th edn.,

Benjamin-Cummings (Addison-Wesley Longman), 1994.

Garcia-Molina, H., Ullman, J.D. and J. Widom, Database Systems - The Complete

Book, Prentice Hall, New Jersey, U.S.A., 2002.

Lewis, P.M., A. Bernstein and M. Kifer, Databases and Transaction Processing –

An Application-Oriented Approach, Addison-Wesley, 2002.

Ullman, J.D. and J. Widom, A First Course in Database Systems, Prentice Hall, 1997.

(See Garcia-Molina, Ullman and Widom above.)

McFadden, F. R. and J. A. Hoffer, Modern Database management, 4th ed.,

Menlo Park, Calif. : Addison Wesley, Benjamin/Cummings Pub. Co., 1994.


For PHP: David Lane, Hugh E. Williams(2002): Web Database Applications

with PHP & MySQL . Publisher: O'Reilly.

McCarty, B. (2001), PHP 4 : a beginner's guide, Osborne/McGraw-Hill,

Berkeley, CA.


LECTURE NOTES: Lecture transp. are available (4 per page) as pdf files from the subject home page

which can be reached from lecturers home page at URL:

http://www.csse.monash.edu.au/~rama/


OBJECTIVES:


We start with an introduction to importance of information and data to organizations, and introduce the Entity-Relationship data model followed by relational model. The relational algebra operators are described followed by the commercial structured query language (SQL). You will be able to draw an ER diagram, given an enterprise description, and define the relational schema and be able to pose SQL queries to retrieve any required information from the database. We discuss normalisation of relations, database query processing, recovery and concurrency in databases followed by database security. You will learn about embedded SQL, and be able to write programs in ProC.


UNIT STRUCTURE BY LECTURE: Here is an approximate structure of the weekly lecture plan, given as a rough guide.



Week

Date

Topics119/7Overview, ER modelling 2Relational Model, Algebra3SQL4SQL5Database Normalisation6Embedded SQL, other data models7Hierarchical and network databases8Implementation Issues9Concurrency control10Query Optimisation11Database Security12Distributed and parallel databases13Misc., Revision


ASSESSMENT:


Assessment will consist of homework assignments, a programming assignment and final examination. The relative weight of the individual components in final grading is as follows. To pass the subject, you must pass each of the three components – secure at least the minimum score in each component. If you get below the minimum in any component, you will fail the subject, and the final mark calculated accordingly. For example, if you get 32/80 in the exams and 10/10 in each of the assignments, your total will be calculated as (100*32/80 = 40 N) independent of the marks obtained in the assignments.


Max. marksMin. for passProgramming assignment 105Homework assignments 105Exam 8036 (hurdle)

Lecturer may also standardise the marks keeping in view of the relative grading in the department, marking standards, relative difficulty of the tasks given etc. However, this will be for the whole class.


ACADEMIC DISHONESTY


Students are reminded that cheating, whether by fabrication, falsification of data, or plagiarism, is an offence subject to disciplinary procedures. Plagiarism is not acceptable. The use of another person's work or ideas must be acknowledged. Failure to do so may result in charges of academic misconduct which carry a range of penalties including cancellation of results and exclusion from your course. Students are responsible for ensuring that their work is kept in a secure place. It is also a disciplinary offence for students to allow their work to be plagiarised by another student The faculty policy on these matters is available at, http://www.csse.monash.edu.au/~ajh/adt/resources/cheatlinks.html.


CSE2316 Vs. CSE3316


The subject material is the same for both the levels. The assignment and exam will have different levels and will be indicated appropriately.


PEER LEARNING

The reminder on academic dishonesty above DOES NOT mean that you should not consult/learn from each other. You are strongly encouraged to discuss among friends/class mates. I would like every one of you to form and belong to a STUDY GROUP of size 4 to 6 students each.


It is NOT acceptable to ask your group mate,

  • "I am tired, let me copy your display module".

  • "I don't want to do these calculations, I will write your answers"

But it is okay, and you should ask if necessary such as,

  • "my read statement is not working. Can you take a look at my statement or show me your read statement if it is working".

  • “fname[] and field1[] strings do not compare equal, although I am very sure they have the same strings.


CONSULTATIONS AND STUDENT-LECTURER COMMUNICATION


In addition to the above times I am also available for consultations at the other campus. Check the web pages for full details and any changes to the consultation times.


Похожие:

Monash university iconMonash university

Monash university iconMonash university law review

Monash university iconAn exhibition of material from the Monash University Library

Monash university iconAn exhibition of material from the Monash University Library

Monash university iconSenior lecturer, Monash University Department of General Practice

Monash university iconAn exhibition of material from the Monash University Library, Rare Book Collection

Monash university iconSport An exhibition of material from the Monash University Library Rare Books Collection Introduction

Monash university iconAustralian Literature Exhibition An exhibition of material from the Monash University Library

Monash university iconПравительство Российской Федерации Государственное образовательное бюджетное учреждение высшего профессионального образования
С использованием материалов коллег из Bologna University, International Peace Operations Association, International University College...
Monash university iconПравительство Российской Федерации Государственное образовательное бюджетное учреждение высшего профессионального образования
С использованием материалов коллег из Bologna University, International Peace Operations Association, International University College...
Разместите кнопку на своём сайте:
Библиотека


База данных защищена авторским правом ©lib.znate.ru 2014
обратиться к администрации
Библиотека
Главная страница