CISC 332*

Database Management Systems

Winter 2012

[Announcements | General Information | Reference Material]

[Computing Resources | Course Content | Required Work and Marking Scheme | Academic Integrity]

Data is one of the vital resources for most organizations and database management systems (DBMSs) are a major component of many of today’s application systems. The course provides an introduction to the design of relational databases and the use of relational DBMSs. Topics covered in the course will include logical database design with the entity-relationship data model and the relational data model, relational query languages (relational algebra and SQL) and database applications with Java.

The learning objectives for the course include the following:

• To become familiar with the basic concepts and application of data models

• To become familiar with the basic concepts of DBMSs and their use in common applications.

• Be able to proceed from a set of requirements to the development of a relational database and application programs to access the database.

• Be able to formulate queries in SQL and relational algebra.

Announcements

· Final exam is on April 21, 2:00 – 5:00 in KHS 100.

· A study guide for the exam is now available.

· A review session will be held Friday April 20 from 1:00 – 3:00 in Dupuis 215.

General Information

Instructor:	Patrick Martin Goodwin Hall 630 613 533 6063 martin [at] cs [dot] queensu [dot] ca Office Hour: Wednesday 2:00 – 3:00
Schedule:	Slot 4 (Tuesday 8:30 – 9:30, Wednesday 10:30 – 11:30 and Friday 9:30 – 10:30) Goodwin 254
TA:	Mingyi Zhang Goodwin Hall 633 myzhang [at] cs [dot] queensu [dot] ca Office Hours:
Prerequisites:	CISC 124and 204.

Reference Material

Course text book: Database System Concepts (6th Edition), A. Silberschatz, H. Korth and S. Sudarshan, McGraw-Hill Higher Education.

Useful links and documentation can be found here.

Computing Resources

Course work will involve using a DBMS, like DB2 or MySQL, and Java. Assignments can be completed with DB2 on the machines in the undergraduate CASLab in Goodwin Hall 248 and Walter Light Hall 310.

Course Content

A tentative course schedule (plus lecture slides) is available.
Thanks to Wendy Powley who created some of the on-line content used in the course and to the authors of the textbook for supplying some of the slides.

Required Work and Marking Scheme

Required Work	Due Dates	Percentage of final mark
Query Language Assignment	February 3	10


Project	Part 1 – February 17 Part 2 – March 9 Part 3 – April 4	30
Midterm test	March 2 (in class)	15
Final exam		45

NOTE:

A hard copy of assigned work is to be handed at the beginning of class on the date due. Do not hand-in assignments via email.
Late assignments are subject to a 10% per day late penalty, with weekends counted as one day. Late assignments will not be accepted beyond 5 days past the date due.

Academic Integrity

Academic integrity is constituted by the five core fundamental values of honesty, trust, fairness, respect and responsibility (see http:\\www.academicintegrity.org). These values are central to the building, nurturing and sustaining of an academic community in which all members of the community will thrive. Adherence to the values expressed through academic integrity forms a foundation for the "freedom of inquiry and exchange of ideas" essential to the intellectual life of the University (see the Senate Report on Principles and Priorities).

Students are responsible for familiarizing themselves with the regulations concerning academic integrity and for ensuring that their assignments conform to the principles of academic integrity. Information on academic integrity is available in the Arts and Science Calendar (see Academic Regulation 1), on the Arts and Science website and from the instructor of this course. Departures from academic integrity include plagiarism, use of unauthorized materials, facilitation, forgery and falsification, and are antithetical to the development of an academic community at Queen's. Given the seriousness of these matters, actions which contravene the regulation on academic integrity carry sanctions that can range from a warning or the loss of grades on an assignment to the failure of a course to a requirement to withdraw from the university.

Copyright Statement

The material on this website is copyrighted and is for the sole use of students registered in CISC 332. The material on this website may be downloaded for a registered student’s personal use, but shall not be distributed or disseminated to anyone other than students registered in CISC 332.

Failure to abide by these conditions is a breach of copyright, and may also constitute a breach of academic integrity under the University Senate’s Academic Integrity Policy Statement.

[CISC Home Page]

School of Computing, Queen's University