Question: You are going to re-design a database to manage a number of rental properties in Smithfield area and kept historical/current records about all rental properties

You are going to re-design a database to manage a number of rental properties in Smithfield area and kept historical/current records about all rental properties under their management and corresponding details about each rental contract - including customer details, property details, owner details, contract periods and weekly rent. The table below shows some sample records of the current database. Customer Property Customer No No Name CR85 PG16 CR56 CR76 CR56 CR56

a. Identify all partial dependencies and transitive dependencies.

b. What normal form is the relation currently in? State the reasons for your answer.

c. Normalize the table to third normal form (3NF) and present or draw the dependency diagrams of the final 3NF tables.

Customer Property Customer No No Name CR85 PG16 CR56 CR76 CR56 CR56 PG4 CR56 CR76 PG16 PG16 John Kay Aline Stewart Aline Stewart PG4 CR76 PG16 John Kay Aline Stewart PG36 James Matt PG4 Aline Stewart PG4 Property Address 5 Novar Dr. Smithfield 6 Lawrence St. Smithfield 5 Novar Dr. Smithfield 5 Novar Dr. Smithfield 6 Lawrence St. Smithfield 5 Novar Dr. Smithfield 2 Manor Rd. Smithfield 6 Lawrence St. Smithfield John Kay Aline 6 Lawrence St. Stewart Smithfield Rent Start 1/Dec/08 1/Nov/07 CR56 Primary keys: Customer_No, Property_No, Rent_Start Rent Finish Property Owner Rent ($) No 450 375 1/Sep/07 1/Sep/08 1/Sep/06 10/Aug/07 1/Dec/05 10/June/06 350 1/Dec/05 31/Aug/06 420 10/Oct/04 15/Nov/05 375 1/July/04 31/Nov/05 325 1/Sep/02 10/June/04 325 Owner Name CO99 Janie Edwards CO99 Janie Edwards 450 CO93 Tony Shaw 450 CO93 Tony Shaw CO40 Tina Murphy CO93 Tony Shaw CO93 Tony Shaw CO40 Tina Murphy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Partial Dependencies and Transitive Dependencies 1 PropertyNo PropertyAddress RentStart RentFinish ... View full answer

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!

4. A partnership owns an aging 4-unit retail center in a local campus property. Cash flow projections for the next 10 years are: $50,000 for years 1 and 2; $60,000 for years 3 and 4; $70,000 for...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Please see the attachment and prepare financial analysis using spreadsheet and determine whether or not they should go with the project. For the exclusive use of Z. Wu, 2016. REVISED APRIL 14, 2016...

Hello, This is the Fina 210 Course about Real estate. Could you help me to solve this problem and show me a solution? because i want to know how to solve this type of question in exam. Thank you! ps:...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

PROBLEM DESCRIPTION The Molly Mackenzie Marina and its surrounding property are located on Gippsland Lakes in Victoria, the Gippsland Lakes are a network of lakes, marshes and lagoons covering over...

Review the following articles and describe how they relate to banking and home purchases. What types of services do banks offer? What are some of the most important things you would consider when...

A sample of ten 40-W light bulbs was taken from each of three manufacturing plants. The bulbs were burned until failure. The number of hours that each remained lit is listed in the following table....

Suppose that Lil John Industries equity is currently selling for $37 per share and that there are 2 million shares outstanding. If the firm also has 30 thousand bonds outstanding, which are selling...

Empirical research Blank _ _ _ _ _ _ that managers can boost stock prices through accounting practices. Multiple choice question. does not suggest suggests proves highly indicates

Shields Manufacturing produces containers for nurseries and landscaping businesses. The company competes based on its low-cost, high-quality products. As the company's expenses have risen, management...

You are an accountant for a defense contractor. The federal government is considering a change of rules for the allocation of research and development costs. The government is asking contractors to...

Hannalinn Corporation operates three divisions-Archer, Barrett, and Corvell. Division managers are evaluated based on the division's return on investment, and historically, the Corvell division has...

Your brother is a physician and has decided to start a home health care agency. The state government will reimburse treatment costs for about half of the patients under a new state-sponsored health...

Ashton Corporation recently announced a bonus plan to reward the manager of its most profitable division. The three divisional managers are to decide which performance measure will be used to...

Find the slope of the line that goes through the points (-15,0) and (-1,3).Slope, m=

Discuss whether the equity method should be viewed as a form of consolidation or a valuation technique.

On January 1, 2009, Plexon acquired 75% of the shares of Jayden for $40,000. The following balances appeared in the records of Jayden at this date: Share capital......... $20,000 Retained...

Craigs Inc. had the following transactions: 1. On September 1, Craigs Inc. purchased parts from an Indian company for a Canadian dollar equivalent value of $8,000, to be paid on February 20. The...

Below is a list of costs. Classify each of them as variable, fixed, or mixed (a combination of variable and fixed components). a. Cost of raw materials used in producing a firms products. b. Property...

-2x + y = 4 over the range x = -3 to x = 6 Graph each of the equations.

x + y = 4 2x - y = 8 Use the graphical method to solve each of the above pairs of equations.