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:
- Describe a relational database and object-oriented database.
-
Describe components of a database management system and the techniques used to store
and access data within the DBMS.
- Utilize modeling software to build a database design.
- Describe normalization and perform normalization of a database model.
- Demonstrate the basic fundamentals of Structured Query Language (SQL).
- Use SQL to create the tables within a database and queries for updating tables.
-
Utilize SQL to build queries to extract data from multiple tables based on selection
criteria.
- Describe the duties of the database administrator.
- Describe the creation and use of metadata and data dictionaries.
-
Examine issues of implementing an enterprise database or other DBMS solution
such as concurrency, efficiency, management of and security.
-
Explain the role and issues surrounding the management of data such as efficiency,
privacy, security, ethical responsibility, and strategic advantage.
- 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.
