In this video, we begin transforming our database from First Normal Form (1NF) to Second Normal Form (2NF) using SQL scripts and phpMyAdmin import. Since the process is extensive, this is Part 1, where we focus on creating the core organizational structure.

🔹 What You’ll Learn in This Video (Part 1)

Quick recap: Why we move from 1NF to 2NF.

Writing DDL commands (CREATE TABLE) for:

2nf_departments – defining department codes and names.

2nf_programs – linking programs to departments.

2nf_majors – assigning majors to programs.

2nf_minors – assigning minors to programs.

Applying constraints: primary keys, unique codes, and foreign keys.

Seeding tables with sample data.

Using Notepad++ to write SQL, then running it in phpMyAdmin via Import.

👉 This is the first step in our 2NF schema design. In the next parts, we’ll continue building other tables such as students, instructors, subjects, rooms, offerings, and enrollments.

📬 Stay Connected

Don’t forget to like 👍, subscribe 🔔, and share this video with your classmates.

#DBMS #SQL #phpMyAdmin #Normalization #1NF #Database