CS
205 Data Modelling and Database Design
Syllabus,
Fall 2006
Course title: CS 205 Data
Modelling and Database Design
Credits: 4 required credits in the CS
major
Prerequisites: CS
140 or CS 143 or CS 170
Instructor: Dr.
Gancho Ganchev
Office: WS114 - Mo We 1:30
- 3:00, Tu Th 3:15 – 4:15
Phone: (203) 837-9349
Email: ganchevg@wcsu.edu, gfganchev@yahoo.com
Description:
An in-depth
introduction to information management techniques with emphasis on data
modeling and relational database design. Topics include conceptual data
modeling, relational database design and normalization, database query
languages, schema integration and integrity constraints, physical database
design, and database usability issues in a shared environment. Students will
design and implement a database application working from the E-R modeling stage
through to the actual implementation.
Resources:
Recommended
textbooks:
[1] Hoffer,
J.,
[2]
Ricardo, C (2004), Databases Illuminated, Jones and Bartlett
Class
notes and additional course materials will be
posted on the N: drive in the folder N:/Class/GanchevG/Database
Attendance: You are expected
to be present for each class session.
Withdrawals: No withdrawals will be approved after the official
University deadline.
Assessment: Four test (approximately 30
minutes in duration), one SQL assignment and a cumulative final exam (2
hours).
Grading:
Semester tests . . . . 36 %
Assignment . . . . . . 24 %
Final exam . . . . . . 40 %
The final exam will be held
on Tuesday December 19th from 5:30 pm in room WS 103
Tentative Schedule of
Topics:
|
Session |
Date |
Topics |
|
|
1 Th |
Sep 07 |
Introduction |
|
|
2 Tu |
Sep.12
|
Database Models |
Notes |
|
3 Th |
Sep 14 |
Database Development Process |
|
|
4 Tu |
Sep 19 |
Analysis:
Entity-Relationship Modeling |
|
|
5 Th |
Sep 21 |
Analysis:
Entity-Relationship Modeling |
|
|
6 Tu |
Sep 26 |
Analysis:
Entity-Relationship Modeling |
|
|
7 Th |
Sep 28 |
Analysis:
Entity-Relationship Modeling |
|
|
8 Tu |
Oct 03 |
Analysis:
Entity-Relationship Modeling |
|
|
9 Th |
Oct 05 |
Analysis: Entity-Relationship
Modeling
|
|
|
10 Tu |
Oct 10 |
Logical Design: The Relational Model |
|
|
11 Th |
Oct 12 |
Test (logical design excluded) Logical Design: The Relational Model |
|
|
12 Tu |
Oct 17 |
Logical Design: The Relational Model |
|
|
13 Th |
Oct 19 |
Logical Design: The Relational Model |
|
|
14 Tu |
Oct 24 |
Test
on logical design Implementation: SQL |
TBA |
|
15 Th |
Oct 26 |
Implementation: SQL |
TBA |
|
16 Tu |
Oct 31 |
Implementation: SQL |
TBA |
|
17 Th |
Nov 02 |
Structured Query Language and Integrity |
TBA |
|
18 Tu |
Nov 07 |
Test on SQL Physical Design |
Ch. 6, notes |
|
19 Th |
Nov 09 |
Submit project table
structures Physical Design |
Ch. 6, notes |
|
20 Tu |
Nov 14 |
Physical Design |
Ch. 6, notes |
|
21 Th |
Nov 16 |
Physical Design |
Ch. 6, notes |
|
22 Tu |
Nov 21 |
Submit
project table content Transaction Management and Concurrency Control |
TBA |
|
23 Tu |
Nov 28 |
Backup and Recovery |
TBA |
|
24 Th |
Nov 30 |
Backup and Recovery |
TBA |
|
25 Tu |
Dec 05 |
Distributed Databases |
Ch 13 |
|
26 Th |
Dec 07 |
Database Administration |
|
|
27 Tu |
Dec 12 |
Additional Topics Assignment
due |
TBA |
|
28 Th |
Dec 14 |
Test Additional Topics |
TBA |
|
|
Dec 19 |
Final Exam |
Cumulative |