CMPE 401 | 2ndSem 25'26 | DCPET 2-1 | DBMS 01
DCpet 2-1
This course provides a comprehensive journey through the lifecycle of relational database management, from conceptual design to advanced data manipulation. Students will first master the principles of Database Design, learning to eliminate data redundancy through Normalization (1NF, 2NF, 3NF, and BCNF) and visualize data structures using Entity-Relationship Diagrams (ERDs). The course then transitions into technical implementation using MySQL, where students develop proficiency in both Data Definition Language (DDL) to build schemas and Data Manipulation Language (DML) to manage records. The final phase of the course focuses on high-level data retrieval, empowering students to perform complex Single and Multi-Table Queries using joins, subqueries, and aggregate functions to extract actionable insights from interconnected data sets.