Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help and include steps 3. Task #3 From the scratch to normalized tables In this task, we will start from the scratch. Following is
please help and include steps
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 Deseription of business process Campus Housing Example Identify the Relational Database Tables for the following highlevel 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) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started