Task #3 – From the scratch to normalized tables In this task, we will start from the scratch. Following is the description of a campus housing’s business process. Read the process description and develop 3NF tables. Use the format in the example below. Example) PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) ** Bold and underline the primary key Description of business process
Task #3 – From the scratch to normalized tables In this task, we will start from the scratch. Following is the description of a campus housing’s business process. Read the process description and develop 3NF tables. Use the format in the example below. Example) PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) ** Bold and underline the primary key Description of business process
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 5P
Related questions
Question
Task #3 – From the scratch to normalized tables
In this task, we will start from the scratch. Following is the description of a campus housing’s business process. Read the process description and develop 3NF tables. Use the format in the example below.
Example)
PROJECT (ProjectNum, Proj_Name, Start_Date)
EMP(Emp_Num, Emp_Name, Job_Class)
** Bold and underline the primary key
Description of business process
Expert Solution
Step 1: Introduction
Below is the complete solution with explanation in detail for the given question about 3NF tables based on the given data with specified format.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning