Course Title
UNCP Home Page CSC 3800 Database Management Systems
Fall 2009
Office Information
002 Instructor: Dr. Charles W. Lillie
Office: 1219 Oxendine
Telephone: 910-521-6415 email: lilliec@uncp.edu
Office Hours: MWF 8:30-9:30, MW 2:30-3:30
Time: 1:30 to 2:20 Meeting Days: MWF Location: Oxendine 1237B
Textbook: Databases Illuminated, Author: Catherine M. Ricardo, 2004, Jones & Bartlett Publishers
Homework assignments

Ch 1: Choose Project: Read STUDENT PROJECTS: INTRODUCTION TO STUDENT PROJECTS on page 50 in textbook.  Choose one of the five projects listed.

Ch 2: Student Project: Applying Planning Techniques to Student Projects on page 113 in textbook.  Apply the planning techniques to your project.

Ch 3: Student Project: Creating the E-R Diagram for the Student Projects on page 167 in textbook.  Create the E-R diagram for your project.

Ch 4: Student Project: Initial Mapping to Tables for the Student Project on page 225 in textbook.  Do the initial mapping for the tables in your project.

Ch 5: Student Project: Normalizing the Relational Model for the Student Projects on page 285 in textbook.  Normailze the relations in your project.

Ch 6: Student Project: Creating and Using a Relational Database for the Student Project on page 372 in textbook.  Create and use the relational database in your project.

Ch 7: Student Project: Drawing an EE-R Diagram and Creqting an Object-Relational Database for the Student Project on page 430 in textbook.  Draw an EE-R Diagram and create an object-relational database for your project.

Ch 8: Student Project: Drawing a UML Diagram and Designing an Object-Oriented Database Model on page 459 in textbook.  Draw a UML diagram and design an object-oriented database model for your project.

Ch 9: Student Project: Implementing Security Features for Student Project on page 491 in textbook.  Implement secutiry features for your project.

Ch 12: Student Project: Planning for Distribution on page 621 in textbook. 

Ch 13: Student Project: Creating a Website for the Student Project on page 672 in textbook.  Create a website for your project.



Contact Web Page Owner at lilliec@uncp.edu