CS-474 Independent Study

Temp link MySQL

Course Description: This course introduces the fundamental concepts, terminology and techniques for designing and implementing a normalized database using a relational database management system.

Topics to be covered include:

• History of Database Management Systems
  
• The role of databases and database applications in contemporary organizations
• The relational model
• The entity-relationship model
• The semantic object model
• Database Design & Database Integrity
• Functional dependencies & Normalization
• Relational Implementation & Relational Algebra
• Database Application Design
• Concurrency, Security & Database Recovery
• SQL
• Database Access Standards

Schedule

Glossary

Required Text: Ricardo, Catherine, Databases Illuminated, Jones and Bartlett, ISBN: 0-7637-3314-8.

Other References: Additional references will be posted to this site.

Software: MySQL, Microsoft Access, Table Designer – Semantic Object Model Software

Course Objectives:

To understand the architecture and components of a Database Management System and to be able to use them appropriately
To become familiar with the client-server model and to use a DBMS to create a small client-server application.
To acquire an understanding of the various database modeling techniques and practice using them.
To understand the importance of design in the construction of a database;
To learn what database integrity is and how the relational model can enhance it.
To gain experience in using SQL to build, query, update and manage relational databases
To gain additional team experience

General Course Information:As an independent study version of this course, you will be required to devote more "outside" time to the course than if you were meeting the normal 2.5 hours per week. Each week there will be reading assignments and homework assignments. Project Development will continue through the entire semester and be woven into all of the topics. There will be two midterms and a final, the nature of which will be determined. In addition, the project will amount to a significant portion of the grade.

Tentative Course Element Percentages: