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
icon
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

 

Campus Housing Example Identify the Relational Database Tables for the following high-
level business processes in a housing system run by the campus housing service. The campus
housing service helps students find apartments. Apartment owners complete information
forms about the available rental units (e.g., location, number of bedrooms, monthly rent),
which are then entered into a database. Students can search this database via the Web to find
apartments that meet their needs (e.g., a two-bedroom apartment for $400 or less month
per
within a half mile of campus) and contact the apartment owners directly to see the apartment
and possibly rent it. Apartment owners call the service to delete their listing when they have
rented their apartment(s).
Transcribed Image Text:Campus Housing Example Identify the Relational Database Tables for the following high- level business processes in a housing system run by the campus housing service. The campus housing service helps students find apartments. Apartment owners complete information forms about the available rental units (e.g., location, number of bedrooms, monthly rent), which are then entered into a database. Students can search this database via the Web to find apartments that meet their needs (e.g., a two-bedroom apartment for $400 or less month per within a half mile of campus) and contact the apartment owners directly to see the apartment and possibly rent it. Apartment owners call the service to delete their listing when they have rented their apartment(s).
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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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.
Similar questions
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
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