Dr. Amita Goyal Chin — INFO 364: Database Systems
Virginia Commonwealth University

Announcements:

  1. 8/19/09: Computer Lab Locations, Remote Login Information, iSQL access.
  2. 8/19/09: Please report any problems with Oracle, iSQL, the computer labs, etc. using the Incident Reporting Form. Please be as clear and concise as possible when reporting the problem.
  3. 8/19/09: October 30, 2009 is the last day to withdraw with a "W".
  4. 9/2/09: Your oracle accounts are now available. Please use your eid and the password oracle to login. Please use the workspace info364 You can access oracle via the web. You will need to change your password after the first time you login.
  5. 9/17/09: Hmwk #1 Solutions
  6. 9/18/09: Getting Started with Oracle Apex
  7. 10/14/09: Hmwk #2 Solutions
  8. 11/3/09: Due to problems with the Oracle server tonight, HMWK #3 will be due on Monday, 11/9/09.
  9. 11/8/09: For your Oracle login: Workspace = info364; Username = your eid; Password = oracle
  10. 11/8/09: Homework #3 and #4 postponed until 11/15/09. Please do not worry about forms and reports on the homeworks.
  11. 11/16/09: OPTIONAL Normalization Quiz on Monday, 11/23/09. I'll count the higher grade of your SQL and Normalization quiz as Quiz #2.
  12. 11/18/09: HW #6 due date is changed to Monday, 11/30/09; HW #7 & HW #8 are still due on Wed, 12/2/09. Exam II is also on Wed, 12/2/09.

Class Schedule

I will attempt to adhere to the following schedule. However, changes may be necessary. All of these changes will be announced in class and will be made to this web page. I encourage you to check this page regularly.
Week Week of ... Additional Due on WedAssignment
1 8/21 Course Overview, Lab, Account Information ----

----
2 8/24 Introduction to Database Systems (Chap 1)---- ----
3 8/31

Introduction to Database Systems (Chap 1)

---- HW #1
4 9/7

9/7 is Labor Day Holiday

---- ----
5 9/14 Practice Exercises - Relational Algebra (Chap 2) HW #1HW#2; Here's a pdf version also - pdf file
6 9/21 Quiz #1 - Terminology, Keys, Database Concepts;

SQL (Chap 6)
Create Inventory DB,
Create S-SP DB,
Lecture Queries

----

HW #3
7 9/28

----

----

HW #4
8 10/5

----

HW#2
9 10/12

Monday - Lab

---- ----
10 10/19 Exam Review (Mon); EXAM # 1 (Wed) - ALL Covered Material

Create Inventory DB,
Create S-SP DB,
Lecture Queries

SQL Practice Exercises #1-3

---- HW #5;
HW #6
11 10/26

Create Inventory DB,
Create S-SP DB,
Lecture Queries

SQL Practice Exercises #1-3

---- ----
12 11/2 ERD (Chapter 4) & Normalization (Chapter 3) HW #3 HW #7: Video Store ERD
13 11/9 ERD/Normalization/Concurrency ControlHW #4 ----
14 11/16 Quiz #2 - SQL HW #5HW #8
15 11/23 Mon: Optional Normalization Quiz

Wed: *** Thanksgiving Break: NO CLASS ***

---- ----
16 11/30 FINAL EXAM (Wed, 12/2/09) Mon, 11/30: HW #6

Wed, 12/2: HW #7: Video Store ERD; HW #8		----
Amita Goyal Chin, Ph.D.

Last Updated: 11/18/09