Question: 3. Task #3 - From the scratch to normalized tables In this task, we will start from the scratch. Following is the description of a

 3. Task #3 - From the scratch to normalized tables In

3. 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 per month 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). Provide your answer in the box (extend the box as you need) and submit this file to CougarVIEW: 3. 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 per month 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). Provide your answer in the box (extend the box as you need) and submit this file to CougarVIEW

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!