COSC2307 Syllabus
COSC2307 Syllabus
Winter, 2024
INSTRUCTOR: Balwinder Kaur
SOURCE MATERIAL
• Required textbook: SQL Fundamentals, Third Edition, John, J. Patricck, 2008, Prentice-
Hall. ISBN-10: 0137126026, ISBN-13: 978-0137126026
• Reference book: Learning SQL, A Step-By-Step Guide Using Oracle, Richard Earp and
Sikha Bagui, 2003, Addison-Wesley, ISBN: 0-201-77363-5
• Additional readings: Modern Database Management, Global Edition, Jeff Hoffer ,
Ramesh Venkataraman , Heikki Topi ,2020, PEARSON, ISBN-10 : 1292263350, ISBN-
13 : 978-1292263359
• Course Website: http://courses.algomau.ca ( code: COSC2307)
CALENDAR DESCRIPTION
Students are introduced to database programming using SQL. The topics covered include data
definition, single and multiple table queries, updates, database administration, embedded SQL,
report formatting, data protection and security.
GENERAL
This course explores some of the programmatic extensions to Structured Query Language (SQL)
supported by today’s leading Relational Database Management Systems (RDBMS) vendors. It
consists of five major components. The first component explains basic concepts of database,
database management system, SQL. The second component involves the relational algebra
which is fundamental for SQL. The third part will teach students how to query database, modify
the data, create database, save the result and format the report (chapter 1 to chapter 8). The fourth
part covers row functions, summarizing data, joins and unions and sub-queries (chapter 9-18).
The last part introduces Database Design concept, normalization, PL/SQL and Database
applications.
LEARNING OUTCOMES
ASSIGNMENTS
There will be four assignments in this course, due in class on the due day, covering topics
presented in the previous week's lectures. Each assignment is worth 5 marks, making a total of
20 marks for the course.
Students are encouraged to bring assignment problems to the attention of the course instructor if
it appears that they might not be solved in a timely manner.
EXAMINATIONS
There are six quizzes, each being worth 2 marks. Each quiz will cover topics presented in the
previous class' lectures. No makeup quiz will be given.
There is one midterm, being worth 25 marks. It will cover topics presented in the previous
weeks' lectures.
The final examination for this course is worth 43 marks for the course. The final examination
covers topics presented across the whole of the course. You have to pass the final exam in order
to pass this course.
GRADING
Credit toward the semester grade will be allocated to each of the components as indicated in the
following table.
The general regulations of the university require punctual and regular attendance at the various
academic exercises. If there are extenuating circumstances related to an absence, the instructor
should be notified. Absences in excess of 20% Jan jeopardize receipt of credit for the course.
RULES OF CONDUCT
Feel free to work with and discuss assignments with other students. This can include discussions
of general issues. However, when it comes to actually writing, you must do this on your own.
You cannot copy the assignments from other people.
The University takes a very serious view of such offences as plagiarism, cheating, and
impersonation. Penalties for dealing with such offences will be strictly enforced.
PROPOSED SCHEDULE
Concepts of Module 1
1 database,Relational
Model Chapter 1
6 Module 8 Midterm
Final Exam