This course is required for all computer science  MAJ   majors.

This course introduces data modelling and the design, implementation and use of databases.

Prerequisites:  COMP 2001 and  COMP 2002

Corequisites:  COMP 2004,  COMP 2006,  COMP 2008

Availability: This course is usually offered in Fall and Winter semesters.

ⓘ

COMP 2006, COMP 2007 and COMP 2008 are strict corequisites. You must register for all three courses at the same time. If you are also intending to take COMP 2004 in the same semester as COMP 2006/7/8 then you must register for all four courses at exactly the same time. If you encounter difficulties then contact registrar@mun.ca.

Course Objectives

To present basic concepts in database systems and information management.  Students will learn how to analyze a situation where data needs to be stored, how to design a database, and then how to implement and use it.

Representative Workload

• Assignments 35%
• In-class Exam 25%
• Final Exam 40%

Representative Course Outline

• Basic information storage and retrieval, capture and representation (1 hour)
• Queries and links, analysis, indexing, quality issues such as scalability (2 hours)
• Database systems, core DBMS function design, architecture, use of a declarative query language (3 hours)
• Data modeling (2 hours)
• Security and privacy (1 hour)

Notes

• Credit cannot be obtained for both Computer Science 2007 and the former Computer Science 3754.
• Computer Science 2007 is a one credit-hour course.

Page last updated May 24th 2021