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.
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
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