Reading and Homework Assignments CS 440-01
Note: check this page frequency as assignments and dates will change over the course of the semester. This is a tentative schedule as we may want to spend more time on one area and less on another. There are also 4 built-in extra days to allow us to go into some topics in more depth or discuss additional topics
Make sure that you read the material before class so that you are familiar with what will be covered. My assumption is that you have read the material prior to class. You should first read the material in the McFadden book and then glance at the material in the Access 97 book for some examples of the application of the material.
In general we will follow the outline in the McFadden book. I will not go over everything in the book as some of the material you should be able to grasp on your own. On the other hand, I will bring in some examples that are not in the book which may clarify or expand on the discussion in the text.
It is unlikely that I will go over all the HW; however, I will collect the HW without notice periodically.
| Topic | Homework | Comments | Dates | Reference Material | |
| Access 97 |
Modern Database Management |
||||
| Database Environment
For hints on HW and additional notes, check
the notes for ch 1 |
Problems and Exercises: 1, 2, 3, 4, 5, 6, 9 In MS ACCESS, create a table using the metadata in table 1.1. chapter 1 project |
9/8-Introduction to
databases. What makes a good/bad database; history of databases
9/13-Look at types
of relations: one-to-one, one-to-many, many-to-many (Fig 1.3/9); |
9/8,13 | 4,7 | ch 1 |
| Database Development Process
For hints on HW and additional notes, check the notes for ch 2 |
Problems and Exercises: 1, 5, 7, 9, 12, 13, 15, 16, 17, 18 chapter 2 project due9/27
|
9/15- System
Development Life Cycle, Prototyping Methodology
9/20- Three Schema Architecture / Three-Tiered DB Location Architecture; Other Notes: The interviewing process; types of questions to ask
|
9/15,20 | 6 | ch 2 |
| Entity-Relationship Model
For hints on HW and additional notes, check the notes for ch 3 |
Problems and Exercises: 1,3,4,5,6,7,8 and one from 11-16 chapter 3 project |
9/22- E-R model /
Relationships; other notations; introduction to normalization (1NF/3NF)
(cf.. pp.237-239)
9/27- Setting up relationships (Access ch 12) Conversion of E-R diagrams into tables (cf. ch 6 pp. 218-236) 9/29- Examples of E-R diagrams and exercises from the end of the chapter 3&4 Tertiary Relations Super/Subtypes; conversion of diagrams with super/subtypes into tables. |
9/22,27,29 | 3,12 | ch 3/6
Notes from other books |
| Enhanced E-R Model and
Business Rules
For hints on HW and additional notes, check the notes for ch 4 |
Problems and Exercises: 1,3,5,8,9,13,14 chapter 4 project |
10/4-.Business rules(145-159);
Relational Model (208-217)
|
10/4,6 | 3,12 | ch 4/6 |
| Logical Database Design and the Relational Model | Problems and Exercises: 1-8 chapter 6 project |
10/6
-Relational data Model(209-217). Normalization Theory(232-244) Review or
E-R to Table conversions. Functional Dependencies
(see Yang) Normalization Theory
from other sources (4NF,5NF, BCNF, DK/NF) Rules concerning
functional dependencies along with their proofs. ([handout]
see
Yang, Date,
Kroenke) This is an
active area a research. The Yang text is makes for interesting reading
for those interested in the mathematical design of databases. 10/11 Inference rules for functional dependencies and their proofs. Diagramming functional dependencies and conversion of functional dependencies into databases. ([handout] see Yang pp. 157-169) 10/13 -Relational Algebra (see Yang, Date) and its relation to SQL (cf. ch 9) This allows us to extend "tradition" algebra into working with relations. Check my notes on relational operators. |
10/11,13,18 | 12,14 | ch 6/3/4
Much of the material in this section will have material from other books and will give you a flavor of the theoretical and research areas in the field. |
| Mid-Term |
OCT 18 Part One will be in-class and will be drawn in part for the "Problems and Exercises" at the end of the chapters. Part Two will be doing programming with MS ACCESS using the database that comes with the text. |
||||
| SQL | Go over questions 1-20 and do the Project exercises. The database for this project can be found at Data for class project | 10/20- Intro to SQL (Update,
Join, Insert, delete etc.) variation in SQL
10/25- SQL functions, expressions and sub queries |
10/25,25 | 10,14,25,27 | ch 9
Read over material in ACCESS 97 book as it complements our discussion |
| Client/Server and Middleware
/ Database Access from Client Applications (Part I) |
Designing ASP and CF WEB pages. The ODBC driver and the ADO model. | 10/27- Introduction to WEB based
data processing. Use of products such as Cold Fusion
11/1 - Active Server Pages and the ADO model . See notes. 11/3 -ODBC driver, QBE and Object Oriented Programming of Databases in Visual Basic. ActiveX controls. (IN 123B). |
10/27, 11/1,3 | 20,30,33 | ch 8 &10
Some of the material for this section is in the texts; others will come from my notes.
|
| Physical Database Design | 11/8- Client/Server considerations.
Physical considerations in
DB design
11/10 - data types and integrating databases with OS and data structures. Go over an example of a WEB based database project I designed. (IN 123B) |
11/8,11/10 | 7 | ch 7 | |
| Client/Server and Middleware
/ Database Access from Client Applications (Part II) |
11/15- Access Methods, Denormalization, and RAID (ch 7); Middleware, Dynamic SQL and parallel Processing (ch 8) | 11/17,22 | ch 7,8 | ||
| Object Oriented Databases | 11/22 - chapter 5
11/24 - chapter 12 |
11/24,11/29 | ch 5 &12 | ||
| Data and database
Administration / Data Warehouse
|
11/29 - Data warehousing (ch 14)
12/1 - Database administration (ch 13) |
11/29, 12/1 | ch 13 & 14 | ||
| Over View - Practical look at DB processing | 12/6
12/8 |
12/1, 6, 8 | |||
|
FINAL EXAM |
|||||
You are the visitor to this site.