{"id":145775,"date":"2025-09-27T05:26:25","date_gmt":"2025-09-27T05:26:25","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/"},"modified":"2025-09-27T05:26:25","modified_gmt":"2025-09-27T05:26:25","slug":"dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/","title":{"rendered":"DBMS: From 1NF to 2NF Using SQL Script &#038; Import | Part 1: Departments, Programs, Majors, Minors"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/qpXqq0BsGow?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>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.<\/p>\n<p>\ud83d\udd39 What You\u2019ll Learn in This Video (Part 1)<\/p>\n<p>Quick recap: Why we move from 1NF to 2NF.<\/p>\n<p>Writing DDL commands (CREATE TABLE) for:<\/p>\n<p>2nf_departments \u2013 defining department codes and names.<\/p>\n<p>2nf_programs \u2013 linking programs to departments.<\/p>\n<p>2nf_majors \u2013 assigning majors to programs.<\/p>\n<p>2nf_minors \u2013 assigning minors to programs.<\/p>\n<p>Applying constraints: primary keys, unique codes, and foreign keys.<\/p>\n<p>Seeding tables with sample data.<\/p>\n<p>Using Notepad++ to write SQL, then running it in phpMyAdmin via Import.<\/p>\n<p>\ud83d\udc49 This is the first step in our 2NF schema design. In the next parts, we\u2019ll continue building other tables such as students, instructors, subjects, rooms, offerings, and enrollments.<\/p>\n<p>\ud83d\udcec Stay Connected<\/p>\n<p>Don\u2019t forget to like \ud83d\udc4d, subscribe \ud83d\udd14, and share this video with your classmates.<\/p>\n<p>#DBMS #SQL #phpMyAdmin #Normalization #1NF #Database<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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. \ud83d\udd39 What You\u2019ll Learn in This Video (Part 1) Quick recap: Why we move from 1NF to 2NF. Writing DDL commands (CREATE TABLE) for: 2nf_departments \u2013 defining department&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-145775","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DBMS: From 1NF to 2NF Using SQL Script &amp; Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBMS: From 1NF to 2NF Using SQL Script &amp; Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"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. \ud83d\udd39 What You\u2019ll Learn in This Video (Part 1) Quick recap: Why we move from 1NF to 2NF. Writing DDL commands (CREATE TABLE) for: 2nf_departments \u2013 defining department...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-27T05:26:25+00:00\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"DBMS: From 1NF to 2NF Using SQL Script &#038; Import | Part 1: Departments, Programs, Majors, Minors\",\"datePublished\":\"2025-09-27T05:26:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/\"},\"wordCount\":179,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/\",\"name\":\"DBMS: From 1NF to 2NF Using SQL Script & Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"datePublished\":\"2025-09-27T05:26:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBMS: From 1NF to 2NF Using SQL Script &#038; Import | Part 1: Departments, Programs, Majors, Minors\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBMS: From 1NF to 2NF Using SQL Script & Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/","og_locale":"en_US","og_type":"article","og_title":"DBMS: From 1NF to 2NF Using SQL Script & Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com","og_description":"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. \ud83d\udd39 What You\u2019ll Learn in This Video (Part 1) Quick recap: Why we move from 1NF to 2NF. Writing DDL commands (CREATE TABLE) for: 2nf_departments \u2013 defining department...","og_url":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/","og_site_name":"UshopWell.com","article_published_time":"2025-09-27T05:26:25+00:00","author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"DBMS: From 1NF to 2NF Using SQL Script &#038; Import | Part 1: Departments, Programs, Majors, Minors","datePublished":"2025-09-27T05:26:25+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/"},"wordCount":179,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/","url":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/","name":"DBMS: From 1NF to 2NF Using SQL Script & Import | Part 1: Departments, Programs, Majors, Minors - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"datePublished":"2025-09-27T05:26:25+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/dbms-from-1nf-to-2nf-using-sql-script-import-part-1-departments-programs-majors-minors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"DBMS: From 1NF to 2NF Using SQL Script &#038; Import | Part 1: Departments, Programs, Majors, Minors"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/145775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=145775"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/145775\/revisions"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=145775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=145775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=145775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}