ACS-2814-001

Applications of Database Systems

Winter 2018
Mon 6:00-9:00p, 3D01
Jeanette Bautista, 3C08B
je.bautista@uwinnipeg.ca
Wk Date Topic Reading Labs /
Assignments
0 04 Jan Introductions / Course Outline
Text and DBs
Lab 1
1 09 Jan
11 Jan
Intro to Relational Databases and Access
Creating Tables and Relationships
Ch1
Ch2, 5
Lab 2
As1 out
2 16 Jan
19 Jan
Queries Ch4 Lab 3 [sol]
As1 DUE [sol]
3 23 Jan
25 Jan
Advanced Queries
Sample Test
Ch6
 
Lab 4 [sol]
4 30 Jan
01 Feb
TEST   Lab 5 [sol]
5 06 Feb
08 Feb
Joins / SQL
Creating Forms
Ch6
Ch3
Lab 6 [sol]
6 13 Feb
15 Feb
Midterm Review
MIDTERM EXAM
Ch3
As2 out
NO LAB
18 Feb - 24 Feb - READING WEEK: NO CLASSES
7 27 Feb
01 Mar
Creating Forms
Entity Relationship Modeling
Ch7 Lab 7
As2 DUE [sol]
8 06 Mar
08 Mar
Entity Relationship Modeling
ERD Examples
Ch7 Lab 8 [sol]
As3 out
9 13 Mar
15 Mar
Mapping
DDL
Ch8
Ch9
Lab 9 [sol]
10 20 Mar
22 Mar
Normalization Ch10 As3 DUE
[sol] [ERD]
11 27 Mar
29 Mar
Normal Forms / Review 1
Review 2
Ch10 As4 out
12 03 Apr Final Review
Review 3 [DB]
As4 DUE [solA] [solB]
Tue 17 Apr 1:30-4:30p, Room 4C60 - FINAL EXAM