COSC3421.03 – Summer 2004

Introduction To Database Systems

Course Director: Dominic K. To

• Email: dominic@cs.yorku.ca
• Room CSB2014
• Phone: (416) 736-2100 ext. 70117

Teaching Assistants:

· Yu Li: yuli@cs.yorku.ca (assignments 1 and 2)

· Victor Wong: kywong@cs.yorku.ca (assignments 2 and 3)

---

What is New?

8/06: Exam info updated

7/16: Posted assignment 3

7/09: Exam schedule has been announced. Follow this link

7/04: Assignment 2, Q7: the expected output from the given data should be:

Arts 2 12

CS 4 25

Math 10 62

7/01: Posted assignment 2

6/13: Posted: assignment 1 solution and sample mid-term questions

5/25: Assignment 1 posted

5/06: Welcome to COSC3421 !

---

Course Outline

Enrollment: Follow the CS Department's procedures for enrollment. Please DO NOT contact your instructor for any enrollment matters.

Announcements during the course:

Announcements during the course will usually be made on this web site under “What is new?”. Urgent matters will be communicated to you by email, using your email id associated with your enrolment record. If you are not sure of what email id is in your enrolment record, please ask your instructor as soon as you can.

Assignments:

• Assignment 1 solution
• Assignment 2: SQL for creating tables and data for assignment 2
• Assignment 3

Schedule:

Course Work	Due Date	Location	Notes
Assignment 1	See instruction on assignment	See instruction on assignment	-
Assignment 2	See instruction on assignment	See instruction on assignment	-
Assignment 3	See instruction on assignment	See instruction on assignment	-
Mid-term	6/17; 7pm (in class)	In class	Closed book. Sample questions
Final exam	Follow this link		Closed book. Covers: Chapters 1, 2, 3, 4.2, 5, 6(JDBC only), 16, 17.4, 19.1 to 19.6 (inclusive), and lecture material

---

Supplementary Material:

Textbook: On-line support materials based on the textbook by Raghu Ramakrishnan. Includes:

• Lecture notes (Some of the lecture notes will be used in class.)
• Answers to the odd-numbered exercises in the book.

DB2 on PRISM Quick Beginning (Specific to COSC3421)

Lab: Prism

You will need a Prism computer account to do assignment 2 and beyond.

Click here to find out how to create your account, if you do not have one already.

IBM: SQL, Getting Started (For reference only. May be useful for assignment 2)

IBM: SQL Reference (For reference only. May be useful for assignments 2 and 3)

IBM DB2 Universal Database (For reference only)

IBM: DB2 Application Development Guide  (For reference only. May be useful for assignment 3)