CIS 275 Database Management

Lecture Hours: 4
Credits: 4

Designed to be broader than teaching specific database products or fourth generation languages. Addresses database development, a concept which includes data modeling, database design, and database implementation, and basic architecture and administration of Oracle, SQL Server, and MySQL databases. Identifies the entity-relationship and object data modeling techniques, and the importance of normalizing data models. Presents techniques of implementing these models into a relational database scheme. Introduces Structured Query Language (SQL).

Prerequisite: CIS 101 or CIS 120, either with a grade of C or better; or consent of the instructor.
Student Learning Outcomes:

Explain the purpose and appropriate application of database technology.
Describe the components of a database management system (DBMS) product.
Develop skills to model users’ needs.
Transfer data models into normalized designs.
Implement normalized designs into relational database schemes.
Identify the fundamental concepts of data structures used by computer scientists for building database management systems.
Demonstrate the basic use of a fourth generation language like SQL.

Content Outline

Overview of Database Processing
Components of Database Processing Systems
Database Development
Data Models
- Entity-relation model
- Semantic object model
- Comparison of semantic and entity-relational models
Relational Model
- Normalization
Transformation of Data Models into Relational DBMS
Manipulation of Relational Data Using SQL
Hands-On Experience with SQL