Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HELP PLEASE!! Instructions are in the photo. at Paragraph Styles 3. Task #3 - From the scratch to normalized tables In this task, we will

HELP PLEASE!! Instructions are in the photo. image text in transcribed
at Paragraph Styles 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) EMPEmp 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 (eg, 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 Couga VIEW

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 11 The Database For Big Data And Analytics

Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler

1st Edition

1583473858, 978-1583473856

Students also viewed these Databases questions

Question

LO1.2 Describe the role of economic theory in economics.

Answered: 1 week ago