ITEC 340:   DATABASE I

Spring 2005

 

 

Instructor:

Dr. Robert Phillips  (rphillip@radford.edu) (www.radford.edu/~rphillip)

Office:

Davis B51 (831-5379)

Office Hours:

M,W from 10:00 to 11:00, F 9:00 to 10:00 and Tu, Th from 10:30 – 11:30

 

 

Required Texts:

Database Design, Application, & Administration, by Michael V. Mannino, 2nd edition. With e-instruction registration card  -  for Dr. Phillips use class code  )7884d43

Required Hardware:

E-instruction response pad (available at book store)

 

 

Tentative Schedule:

 

 

Module

 

Number of Lectures

 

Chapters

Database  Concepts and SQL

-          Why Databases?

-          Intro to Relational Databases

-          Introduction to SQL

-          Advanced Queries

-          VIEWS and embedded SQL

 

1

1

3

3

3

 

1

2 (pp. 25-27 and 37-48)

3

9

10

Database Design,  Data Integrity, and Stored Procs

-          Data Integrity, constraints and DDL

-          Database Design

-          Normalization of Relational Tables

-          Stored Procedures and triggers

 

2

3

2

3

 

2 (pp.28 – 36) & constraints summary handout

4 and 5

7

11

Transaction Processing, Data Warehousing, and DB Administration

-          Concurrent Access and Transactions

-          Distributed Transaction Processing

-          Data Warehousing

-          Account Maintenance and Security

-          Backup and recovery

 

 

2

2

3

1

1

 

 

15

17

16

14

14

                                        

 

 

 

 

Grading:

Test 1

100 points

 

Test 2

100 points

 

Test 3 (final)

100 points

 

Homework

100 points

 

In class quizzes and participation

100 points

 

 

Homework:

Homework from the text as well as other sources will be assigned throughout the semester.  All assignments are to be completed on your own.  You may not work with a classmate to solve a problem.  Late homework will not be accepted.

Etiquette:

Please turn off cell phones.  Please arrive for class on time.

Attendance:

Attendance is required.  Any student missing six or more classes will receive a grade of F in the class.  Being late twice will count as one absence.

 

You should plan on attending all lectures. You are responsible for all material presented in class and all announcements made in class.  If you miss a class you are responsible for finding out what was missed.  Being absent when a homework assignment is made or changed, a test date announced, etc., is not an acceptable excuse for not being prepared.

Cheating:

The Radford University Honor Code will be strictly enforced.  All violations will be reported.