ITEC 640: Database Concepts
Prerequisite: ITEC 501 and ITEC 502, or permission of ITEC Department
Credit Hours: (3)
An in-depth study of the theory, design, and implementation of database concepts with emphasis on relational and object-relational systems.
Detailed Description of Content of Course
Course topics include:
1. Motivation for Database Management Systems
2. Relational Database Management Systems
3. Relational Algebra, Relational Calculus, and SQL DML
4. Data Integrity and SQL DDL
5. Stored Procedures and Triggers
6. Transactions and Concurrency
7. Embedded SQL and Client/Server Communication
8. Database design and normalization
9. OO Databases, Object Relational Databases, Object-Relational Mappings
10. Physical Database Design and Tuning
11. Data security and User Account Management
12. Distributed databases and Data Warehousing
13. Educational Issues of teaching Database Management Systems
Detailed Description of Conduct of Course
Lecture and demonstration will be used to present course topics. Students will be expected to use Internet as well as textbook and lecture note resources to complete assignments. Multiple enterprise level data base management systems will be used.
Goals and Objectives of the Course
Students completing the course will be able to:
1. Explain, design and implement database schema
2. Explain, design and implement integrity controls
3. Administer and secure a database management system
4. Explain the mathematical foundations of relational query languages
5. Query and manipulate relational data
6. Compare and contrast OO, O-Relational, Relational, Network, and Hierarchical Database Management Systems
7. Compare and contract DBMSs and File Oriented Data Management
8. Implement efficient multi-user client/server applications that require non-trivial data-persistence.
9. Explain the purpose of distributed database systems and data warehouses and recognize situations where such solutions are appropriate.
Assessment Measures
Students may be assessed based on a multiple examinations and out-of-class assignments, including analysis, design, and implementation tasks.
Other Course Information
None.
