CS 360: Database Management

Course Description:

This course provides an overview of database system concepts. This course will deal with file organization methods, database models, data integrity and security, and database administration issues. The student will be introduced to application program development in database environment with emphasis on setting up, modifying, and querying a database. Prerequisite: CS 219.

Learning Outcomes:

Upon completion of this course you should be able to:

1. Describe a relational database and object-oriented database.
2. Describe components of a database management system and the techniques used to store and access data within the DBMS.
3. Utilize modeling software to build a database design.
4. Describe normalization and perform normalization of a database model.
5. Demonstrate the basic fundamentals of Structured Query Language (SQL).
6. Use SQL to create the tables within a database and queries for updating tables.
7. Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
8. Describe the duties of the database administrator.
9. Describe the creation and use of metadata and data dictionaries.
10. Examine issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.
11. Explain the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.
12. Describe the role of web-enabling databases.

Assessment Measures:

Assessment Tool	Linkage to Learning Outcome #:
Instructor will utilize various exercises in modeling and SQL to evaluate student's ability to demonstrate objectives and understand concepts in modeling, normalization and SQL.	3-7
Chapter tests will be used to evaluate students ability to understand terminology and basic concepts of data management and database systems. This should include at minimum a final	1-12
Case Studies, open-ended text based questions, formal paper and/or group projects will be used to illustrate and demonstrate student's ability to tie multiple concepts together relating to data management and database systems.	8-12

Textbooks

To view the approved textbook list, click here.