0% found this document useful (0 votes)
18 views3 pages

COSC2307 Syllabus

This document outlines the course details for a database programming course, including instructor information, required materials, prerequisites, course description, learning outcomes, assignments, examinations, grading, attendance policy, conduct rules, and proposed schedule.

Uploaded by

kishan maniyar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
18 views3 pages

COSC2307 Syllabus

This document outlines the course details for a database programming course, including instructor information, required materials, prerequisites, course description, learning outcomes, assignments, examinations, grading, attendance policy, conduct rules, and proposed schedule.

Uploaded by

kishan maniyar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

COSC 2307 - Database Programming

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)

PREREQUISITES: COSC 1046 or equivalent programming experience.

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

Students who successfully complete the course should be able to:

• Demonstrate database knowledge and understanding of basic concepts of database.


• Demonstrate the knowledge and understanding of structured query language (SQL), in
particular Data Definition Language (DDL) and Data Manipulation Language (DML).
• construct queries using SQL
• Be familiar with a commercial relational database system (for example Oracle) by writing
SQL using the system.
• Demonstrate the knowledge, understanding and methodology of database design by
translating requirements into a data model.
• Apply and use computer-based software to design and create database.
• Apply normalization to design database.
• Create a GUI that uses SQL and Stored Procedures to access data in underlying tables

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.

Assignments (4) and class 20%


exercises
Quizzes (6X2) 12%
Mid-Term 25%
Final Examination 43%
TOTAL 100%
ATTENDANCE POLICY

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

WEEK CHAPTER Module Assignments

Concepts of Module 1
1 database,Relational
Model Chapter 1

2 Relational Algebra Module 2 Class Exercise

3 Chapter 2, 3 Module 3, 4 Assign 1 & Class Exercise

4 4,5 Module 5, 6 Assign 2 & Class Exercise

5 6,7 Module 7 Quiz 1 & Class Exercise

6 Module 8 Midterm

7 8,9,10 Module 9,10 Quiz 2 & Class Exercise

8 11,12 Module 11,12 Quiz 3& Class Exercise

Module 13,14 Assign 3


9 13-14
Quiz 4

10 15,16 Module 15 Quiz 5 & Class Exercise

11 17,18 Module 16 Assign 4 & Class Exercise

12 Review Module 17 Quiz 6 & Class Exercise

Final Exam

You might also like