CS 315

Database Management Systems

Summary:

CS315 is an introduction to the design, implementation, and management of relational database systems.

Topics include the role of databases in organizations; types and functions of database management systems; conceptual data modeling, entity relationship data models; and the principles of relational database design. The implementation and maintenance of database management systems and the role of the database administrator are discussed. SQL (Structured Query Language) will be utilized for querying the database.

Essentials:

Syllabus

Slide Set 1: Database Introduction
Slide Set 2: Relational Databases
Slide Set 3: Entity Relationship Diagram
Slide Set 4: ER Attributes
Slide Set 5: ER Relationships
Slide Set 6: Normalization 1NF 2NF
Slide Set 7: Normalization 3NF
Slide Set 8: Relational Operations
Slide Set 9: SQL Data Definitions
Slide Set 10: SQL Queries
Slide Set 11: SQL Advanced

All documents are in Adobe Acrobat format. Acrobat Reader is free and vailable on textbook CD or download latest version from Adobe.

(If doesn't load in browser save file and open with Acrobat Reader)

Projects:

Due Week 3 - Class 1: Ch. 1 Problems 1 through 6 and 14 (pp 51-52). Value=10 points; Late projects will be reduced 20% per class!
- Figure P1.1 Table (Tab delimited text file)
- Figure P1.7 Table (Comma seperated values file)
Due Week 4 - Class 1: Ch. 2 Probs. 1 through 10. Include attributes in problem 6 ERD (pp 95-96).
Value=20 points; Late Projects will be reduced 25% per class!
Due Week 6 - Class 1: Ch. 3 Probs. 1 through 3, 8, and 9. Use Chen Model for ERD's without attributes (pp 163-165).
Value=20 points. Late Projects will be reduced 25% per class!
- Figure P3.1
Due Week 9 - Class 1: Ch. 4 Probs. 1-7, 11-14
Value=20 points; Late Projects will be reduced 25% per class!
Due Week 12 - Class 1: Exam 2 will also be on this Day.
All SQL must be compatible and work with MS Access.
Paste working SQL into an MS Word document.
Value=30 points; Late Projects will be reduced 25% per class!
Resize MS Access window and do an Alt-Print Screen to capture window,
then paste image into word document for the specified items [PrtSc].
Chapter 5 Review Questions: 1, 2, 3[PrtSc], 5, 6, and 15[PrtSc].
Chapter 5 Problems 2, 4[PrtSc], 5, 6[PrtSc]
(Book Error Problem 6: Date should be 1/20/2002)
and Chapter 5 Problems 7, 8[PrtSc]
(Book Error Problem 8: Only calculate Fuel Per Hour; Not Total Mileage Charge)

Textbook:

Database Systems: Design and Management,
5th Edition
by Peter Rob, Carlos Coronel
Published by Thompson Learning
ISBN: 061906269X

Textbook Web Site

Tools:

Text Pad
Feature filled shareware text editor. Designed to be used as a programming language or html editor. Optional Clip Libraries and Syntax Definitions can be installed to aid in SQL coding.
SQL Syntax Definition

WinZip (Popular "Zipper" to create and open zip files)

Topics:

Essentials

Books

Tools

Links