Introduction to Database Management (Revision 8)
View previous syllabus
Area of Study: Science
Prerequisite: COMP 361
Faculty: Faculty of Science and Technology
COMP 378 has a Challenge for Credit option.
**Note: Students who are concerned about not meeting the prerequisites for this course are encouraged to contact the course coordinator before registering
This course is developed along the database development life cycle, which will allow students to easily relate topics to one another along a logical path. The structure of the course follows the development of the material in Modern database management (10th ed.) (Hoffer et al., 2010). The Study Guide consists of nine units; each of which consists of one or more sections. Each section has a goal, objectives, and activities.
The theoretical material in this course is supplemented by labs, Assignment, and Project components. The labs provide hands-on training for students, and link to commercial products.
Students successfully completing this course will be able to
- analyze the data and data organization needs of organizations;
- apply the Entity-Relationship (E-R) Model for building information systems' data models;
- transform an E-R diagram into a relational model, and use normalization to create a database relational schema;
- discuss the physical database design process of producing an efficient and tuned database;
- explain when denormalization is preferred over normalization, and use vertical and horizontal partitioning for data distribution;
- elaborate on data storage and indexing options, and perform query optimization;
- use SQL for database creation, manipulation, and control;
- explain the client/server model, and describe the key components used to implement internet database environments;
- perform basic database administration tasks;
The course consists of the following nine units.
Unit 1 - Introduction to Database Systems:
This unit discusses the evolution of file processing systems, and introduces the role of databases in organizations. It also introduces the core components of a database environment.
Unit 2 - Data Modeling: The Entity-Relationship Diagram:
This unit discusses the entity-relationship (E-R) diagram: how it may be used to model real-life situations, and its symbols and constructs.
Unit 3 - The Relational Model and Normalization:
This unit explains the relational model, normalization, and how to transform an entity-relationship data diagram into a relational model.
Unit 4 - Physical Database Design:
This unit introduces the physical design process, its steps, inputs, and outputs.
Unit 5 - SQL - A Standard Navigation Language for Relational Databases:
This unit provides a thorough presentation of the SQL language used by most database management systems.
Unit 6 - Introduction to Two-Tier and Three-Tier Architectures, and the Internet Database Environment:
This unit introduces the Internet database environment, including Web-enabled databases, Web-enabled system design, and programming in two-tier and three-tier architectures. It also discusses XML and data exchange on the Internet.
Unit 7 - Introduction to Data Warehousing:
This unit introduces the fundamental concepts of data warehousing. The data warehouse architectures and OLAP tools are explained.
Unit 8 - Data Quality and Database Administration:
This unit is devoted to data quality, data integration, and database administration. The roles of data administration and database administration, their function, and their importance to an information resource will be discussed.
Unit 9 - Overview of Object-Oriented Databases:
This unit introduces the object-oriented data model, and discusses the implementation of object persistence using relational databases.
To receive credit for COMP 378, you must achieve an average grade of at least 50 percent from the combined marks of the invigilated final examination and the online quiz, and an average grade of at least 50 percent from the combined marks of the Assignments and Project. The weighting of the composite grade is as follows:
To learn more about assignments and examinations, please refer to Athabasca University's online Calendar.
Hoffer, J. A., Venkataraman, R., & Topi, H. (2010). Modern database management (10th ed.) [eText version]. Prentice Hall.
A print version of the eText can sometimes be purchased from the publisher through a direct-to-student link provided on the course website; you can also acquire the textbook on your own if you wish.
Software: Computer Science 378 is accompanied by a set of labs and a project to familiarize students with the database techniques and languages that are being used in work environments. The labs use the Teradata University Network, while the project can be implemented using either SQL Server or Oracle. You can download SQL Server using the SCIS access to the MSDN Academic Alliance Software Center, or download the free version of the Oracle database.
The remaining learning materials for COMP 378 are distributed in electronic format. At this time, those materials include:
- Computer Science 378 Study Guide (including lab instructions)
- Detailed descriptions of the requirements for the individual Assignments and Project.
- An online quiz.
- A course evaluation form
- Links to a variety of resources on the World Wide Web.
- Additional supporting materials of interest to students of Computer Science 378 may occasionally be made available electronically.
Special Course Features
Computer Science 378 is offered in a computer-mediated communications (CMC) mode, and can be completed at the student's workplace or home. It is a core course in the B.Sc. Computing and Information Systems (CIS) program.
The Challenge for Credit process allows students to demonstrate that they have acquired a command of the general subject matter, knowledge, intellectual and/or other skills that would normally be found in a university level course.
Full information for the Challenge for Credit can be found in the Undergraduate Calendar.
Undergraduate Challenge for Credit Course Registration Form
Athabasca University reserves the right to amend course outlines occasionally and without notice. Courses offered by other delivery methods may vary from their individualized-study counterparts.
Opened in Revision 8, September 18, 2013.
View previous syllabus
Updated March 09 2018 by Student & Academic Services