Introduction to Database Concepts
| Course Code | COMP-122 |
|---|---|
| Lecture hours per week | 2 |
| Lab hours per week | 2 |
| Course Availability | Open |
| Description | This course introduces students to the fundamental concepts and practices of relational database design, implementation, and management. Students learn how to analyze business requirements, model data using entity-relationship diagrams, design relational table structures, apply keys and constraints, normalize data to reduce redundancy, and implement secure database solutions. Using Oracle Database and SQL, students develop practical skills in creating, modifying, querying, and managing relational databases, including data definition, data manipulation, filtering, sorting, joins, functions, transactions, and user access control. Students also use AI-assisted development practices to support query writing, debugging, documentation, data modelling, and validation while maintaining accuracy, security, privacy, and professional judgment. Through hands-on labs, assignments, and a database design project, students build foundational database skills required for software development, data-driven applications, and enterprise information systems. |