Course Description
This course provides a comprehensive overview of the principles and practices involved in the design and implementation of databases. Through a combination of theoretical foundations and practical applications, students will learn to create efficient and effective database systems to meet the information needs of organizations. The course covers essential topics such as database modeling, relational database management systems (RDBMS), normalization, SQL programming, and database administration. Successful completion of ITSM 1203 Information Technology Fundamentals and ITSM 1303 Programming logic are recommended prior to taking this course.
Prerequisite(s)
ITSM-1313
At the end of this course, students will be able to:
- Demonstrate Understanding of Database Concepts
- Apply Database Design Principles
- Execute SQL Commands
- Design and Implement Database Systems
- Ensure Database Security and Integrity
- Utilize Advanced Database Concepts
- Analyze and Solve Database Problems
- Collaborate Effectively in Database Projects
- Evaluate Database Management Systems
Topical Outline
MODULE 1. INTRODUCTION TO DATABASE MANAGEMENT
MODULE 2. THE RELATIONAL MODEL: INTRODUCTION, QBE, AND RELATIONAL ALGEBRA
MODULE 3. THE RELATIONAL MODEL: SQL
MODULE 4. THE RELATIONAL MODEL: ADVANCED TOPICS
MODULE 5. DATABASE DESIGN: NORMALIZATION
MODULE 6. DATABASE DESIGN: RELATIONSHIPS
MODULE 7. DATABASE MANAGEMENT SYSTEMS PROCESSES AND SERVICES
MODULE 8. DATABASE INDUSTRY CAREERS
MODULE 9. DATABASE INDUSTRY TRENDS