JMU

CS474 - Schedule

Week TOPIC Reading Project Step Assignment
2
 Introduction to course/
logistics
3
 Introduction to Database
Terminology		 Chapter 1
Chapter 2		 Choose a project.

Read Chapter 1 and Chapter 2 project steps.

We will discuss the first step on Thursday.
  1. Choose a project. Project may be one of the ones from the book, or you may choose your own topic.
  2. Read carefully through the first project step. (See project step column)
  3. Download this database -- UniversityDB.mdb
  4. Do the two lab assignments from Chapter 1. These give a good review of both using a database that exists and making a new database. Upload your completed db's to the Blackboard assignment. Be sure to close the database before uploading it.
  5. Each chapter has some exercises in the back. Read through those and highlight any which you want to review on Thursday.
4
 E-R Model and its ramifications Chapter 3 Steps 1 & 2 in project.
  1. Go through step 1 & 2. If you don't get all of the data dictionary done, at least try to define all of the data elements with which you will work in your database.
  2. Chapter 3 and associated questions.
5

02/09/06

 Relational Model - Relational algebra; query language

Review project progress.

 Chapter 4 Finish step 2, and review DBDesigner tool.
  1. Install DBDesigner.
  2. Continue with project.
  3. Chapter 4.
6

02/16/06

 Relational algebra continued. Chapter 4 "Implement" your project in DBDesigner - pass 1.
  1. Additional practice exercises.
7

2/23/06

 Database Management Systems - MYSQL

Chapter 6 Create at least one table in MYSQL and populate it with some data. We will be refining this design so don't go to far with it.
  1. Install MYSQL
  2. Create a table from your project
8

03/02/06

 Conversion Begin Chapter 5 Review current project status Conversion class with Dr. Adams sections
9

03/16/06

 Normalization

MySQL to begin building tables

 Chapter 5 Refine project to make sure that the tables are normalized.

Begin to implement them in MySQL.
  1. More practice with normalization
  2. MySQL queries
10

03/23/06

 Continue normalization Chapter 5 Review "exercise" - making sure we are on track with the other 474 sections.
11

03/30/06

 Exploring other models

Chapter 7Chapter 8Appendix B, C
12

04/06/06

 Databases and the internet

Social and ethical issues

 Chapter 13

Chapter 14
13

04/13/06

 Database Security Chapter 9
14

04/20/06

 Transaction Processing Chapter 10
15
 Data Warehouse and Mining
Department of Computer Science Nancy Harris Home Page Current Classes Link