CISC 332*/CMPE 332*

Database Management Systems

Winter 2015


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 include data models, particularly the relational data model, relational query languages (relational algebra and SQL), logical database design with the entity-relationship data model and issues in the development and operation of Web-based database applications.

Students should have taken CISC 124 and 204 or have equivalent knowledge of programming, data structures and formal models. Course material will be taken from the course text. Course work will involve both written and programming assignments, a final exam and a course project.

Announcements 

·         All official course information and material will be available on the CISC 332/CMPE 332 Moodle site. Only students registered in the course can access the site.

General Information

Instructor:

Patrick Martin
Goodwin Hall 630
613 533 6063
martin@cs.queensu.ca
Office Hour: Thursday 11:00 – 12:00

Schedule:

Slot 12 (Monday 12:30 – 1:30, Wednesday 11:30 – 12:30 and Thursday 1:30 – 2:30)
Jeffery 128

TAs:

TBA

Prerequisites:

CISC 124*and 204*.

Intended Student Learning Outcomes

To successfully complete the course students will demonstrate their ability to

 

  1. Students will apply database design techniques and tools to create a database schema and database instance for an application.
  2. Students will apply an application design method and development tools to create a web application to support users in querying and manipulating the database for an application.
  3. Students will compose queries on a database in both SQL and the relational algebra.
  4.  Students will assess the quality of database schemas and queries.
  5. Students will apply methods to improve the performance and security of a database application.

Reference Material

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

Programming reference: PHP and MySQL for Dummies, J. Valade, Wiley, 2009 (download available).

Computing Resources

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

Course Content

Course material is available on the course Moodle site.

Grading Scheme

Required Term Work (Tentative Schedule)

Query language assignment due January 26, 2015.

 

Course project

·         Part 1 due February 12, 2015.

·         Part 2 due March 9, 2015.

·         Part 3 due April 2, 2015

·         Project demos in last week of classes.

 

Grading Method

In this course, some components will be graded using numerical percentage marks.  Other components will receive letter grades, which for purposes of calculating your course average will be translated into numerical equivalents using the Faculty of Arts and Science approved scale (see below). Your course average will then be converted to a final letter grade according to Queen’s Official Grade Conversion Scale (see below).

 

           Arts & Science Letter Grade Input Scheme      Queen’s Official Grade Conversion Scale               

Assignment    

mark

Numerical value for calculation of final mark

 

 

Grade

 

Numerical Course Average (Range)

A+

93

 

A+

90-100

A

87

 

A

85-89

A-

82

 

A-

80-84

B+

78

 

B+

77-79

B

75

 

B

73-76

B-

72

 

B-

70-72

C+

68

 

C+

67-69

C

65

 

C

63-66

C-

62

 

C-

60-62

D+

58

 

D+

57-59

D

55

 

D

53-56

D-

52

 

D-

50-52

F48 (F+)

48

 

F

49 and below

F24 (F)

24

 

 

 

F0 (0)

0

 

 

 

Late Policy

Assignments should be handed in by 4:00 pm on the day they are due. 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 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 http://www.queensu.ca/secretariat/policies/senateandtrustees/principlespriorities.html).

 

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 http://www.queensu.ca/artsci/academic-calendars/regulations/academic-regulations/regulation-1), on the Arts and Science website (see http://www.queensu.ca/artsci/academics/undergraduate/academic-integrity), 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 of Course Materials

This material is designed for use as part of CISC 332/CMPE 332 at Queen¹s University and is the property of the instructor unless otherwise stated.  Third party copyrighted materials (such as book chapters and articles) have either been licensed for use in this course or fall under an exception or limitation in Canadian Copyright law.

 

Copying this material for distribution (e.g. uploading material to a commercial third-party website) can lead to a violation of Copyright law. Find out more about copyright here:

http://library.queensu.ca/copyright.

Disability Accommodation Statement

Queen's University is committed to achieving full accessibility for persons with disabilities. Part of this commitment includes arranging academic accommodations for students with disabilities to ensure they have an equitable opportunity to participate in all of their academic activities.

If you are a student with a disability and think you may need accommodations, you are strongly encouraged to contact the Disability Services Office (DSO) and register as early as possible. For more information, including important deadlines, please visit the DSO website at: http://www.queensu.ca/hcds/ds/