Task #3 – From the scratch to normalized tablesIn 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 campushousing service helps students find apartments. Apartment owners complete informationforms 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 findapartments that meet their needs (e.g., a two-bedroom apartment for $400 or less monthperwithin a half mile of campus) and contact the apartment owners directly to see the apartmentand possibly rent it. Apartment owners call the service to delete their listing when they haverented their apartment(s).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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).

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

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions