CMPS 325 - Introduction to Database Systems

Institution:

Point Park University

Subject:

COMPUTER SCIENCE

Description:

This Database course surveys topics in database systems. The course emphasizes the effective use of database (management) systems. Topics include access methods, data models, query languages, database design, query optimization, concurrency control, recovery, security, integrity, client-server architecture, and distributed database systems. Hands-on use will be a key part of the course. Course Objectives Upon successful completion of the course, students will be able to: (1) Explain the importance of database design (2) Describe business rule are and how they influence database design (3) Define data models are and why they are important (4) Explain the details of the relational data model (5) Perform Data Modeling with the Entity Relationship Model (ERM ) (6) Define normalization and its role in the design process (7) Implement the basic Normal forms from 1NF to 4NF (8) Use The basic commands and functions of SQL (9) Use SQL for data administration (to create tables, indexes, and views) (10) Use SQL for data manipulation (to add, modify, delete, and retrieve data) (11) Use SQL to query a database for useful information

Credits:

4.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.pointpark.edu

Phone Number:

(412) 391-4100

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.