As Kelly anticipated his retirement from teaching at Kansas University he decided he needed an additional...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As Kelly anticipated his retirement from teaching at Kansas University he decided he needed an additional source of income and started a real estate firm that specializes in the leasing, maintenance, and subrental of apartment buildings. Kelly has hired a number of employees to carry out the day to day operations. Employees negotiate the long-term leases of the apartment buildings from their owners, arrange to have them maintained through a series of maintenance contracts, and negotiate/enforce subrental contracts with individual tenants. Usually, the same employee handles all business for a given building throughout its life with the firm (typically 1-5 years), but this sometimes changes because of reassignment or turnover. Employees are paid on a complicated formula that accounts for tenant satisfaction, contractor performance and other factors, so it is important that their participation in past leases, maintenance contracts, and subrentals is accounted for. Owners for buildings are identified by a combination of their name and address while contractors are given a unique ID#. Tenants are identified by social security numbers (SSN). Kelly runs background checks on employees, contractors, and potential lessors, so he adds them to the database as soon as they are cleared. Tenant information is obtained at contract signing time. Building and apartment information is noted when a lease is signed. Subrental contracts can include more than one person; however, one tenant is designated as the prime renter who is legally responsible for final settlements. Tenants are allowed to rent just one apartment at a time. Maintenance contracts note both the buildings and set of apartments covered, but subrental contracts just single out the particular apartment for the contract. Buildings are identified by their address, while apartments are identified by a combination of their building address and apartment number. Apartments range from 1 to 3 bedrooms. Leases cover just one building and when they expire a new lease is written if the parties on both sides want to continue the relationship. Subrental contracts last one year while maintenance contracts last from two months to three years. The set of lessors, contractors, and tenants do not overlap, nor are employees allowed to become any of these parties. Required: Using the narrative description above and the attribute list on the following page develop a conceptual model using UML with classes, associations, and multiplicities specified. Convert your conceptual model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the tables. You may use the abbreviations (in parentheses) in your tables to save writing time. Do not add any attributes. Attributes Tenant SSN (TenSSN) Subrental contract starting date (SCStartDate) Subrental contract # (SC#) Apartment # (Apt#) Tenant name (TenName) Building address (BldgAdd) Accumulated hours of a maintenance contract spent on a particular apartment (HrsOnApt) Owner address (OwnAdd) Total lease amount (TotleaseAmt) Lease # (Leaset) Building age (BldgAge) Percentage of maintenance contract for a particular building (%ContForBldg) Maintenance contract total fee (MaintContTotFee) Contractor address (ContAdd) Contractor ID # (Cont#) Employee name (EmpName) Apartment square footage (AptSgft) Maintenance contract # (MC#) Count of tenants on a subrental (CountTen) Count of apartments in building (CountApt) Employee SSN (EmpSSN) Owner name (OwnName) Count of bedrooms in apartment (CountBR) As Kelly anticipated his retirement from teaching at Kansas University he decided he needed an additional source of income and started a real estate firm that specializes in the leasing, maintenance, and subrental of apartment buildings. Kelly has hired a number of employees to carry out the day to day operations. Employees negotiate the long-term leases of the apartment buildings from their owners, arrange to have them maintained through a series of maintenance contracts, and negotiate/enforce subrental contracts with individual tenants. Usually, the same employee handles all business for a given building throughout its life with the firm (typically 1-5 years), but this sometimes changes because of reassignment or turnover. Employees are paid on a complicated formula that accounts for tenant satisfaction, contractor performance and other factors, so it is important that their participation in past leases, maintenance contracts, and subrentals is accounted for. Owners for buildings are identified by a combination of their name and address while contractors are given a unique ID#. Tenants are identified by social security numbers (SSN). Kelly runs background checks on employees, contractors, and potential lessors, so he adds them to the database as soon as they are cleared. Tenant information is obtained at contract signing time. Building and apartment information is noted when a lease is signed. Subrental contracts can include more than one person; however, one tenant is designated as the prime renter who is legally responsible for final settlements. Tenants are allowed to rent just one apartment at a time. Maintenance contracts note both the buildings and set of apartments covered, but subrental contracts just single out the particular apartment for the contract. Buildings are identified by their address, while apartments are identified by a combination of their building address and apartment number. Apartments range from 1 to 3 bedrooms. Leases cover just one building and when they expire a new lease is written if the parties on both sides want to continue the relationship. Subrental contracts last one year while maintenance contracts last from two months to three years. The set of lessors, contractors, and tenants do not overlap, nor are employees allowed to become any of these parties. Required: Using the narrative description above and the attribute list on the following page develop a conceptual model using UML with classes, associations, and multiplicities specified. Convert your conceptual model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the tables. You may use the abbreviations (in parentheses) in your tables to save writing time. Do not add any attributes. Attributes Tenant SSN (TenSSN) Subrental contract starting date (SCStartDate) Subrental contract # (SC#) Apartment # (Apt#) Tenant name (TenName) Building address (BldgAdd) Accumulated hours of a maintenance contract spent on a particular apartment (HrsOnApt) Owner address (OwnAdd) Total lease amount (TotleaseAmt) Lease # (Leaset) Building age (BldgAge) Percentage of maintenance contract for a particular building (%ContForBldg) Maintenance contract total fee (MaintContTotFee) Contractor address (ContAdd) Contractor ID # (Cont#) Employee name (EmpName) Apartment square footage (AptSgft) Maintenance contract # (MC#) Count of tenants on a subrental (CountTen) Count of apartments in building (CountApt) Employee SSN (EmpSSN) Owner name (OwnName) Count of bedrooms in apartment (CountBR)
Expert Answer:
Answer rating: 100% (QA)
Answer servee AUthenticuute uselloginc Connect user t s... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A real estate firm is evaluating an office building using the income approach. The real estate firm has compiled the following information for the office building. All information is on an annual...
-
An accounting firm that specializes in auditing mining companies collected the data found in the file Dat9-6.xls on your data disk describing the long-term assets and long-term debt of its 12...
-
Quality Bikes is a wholesale firm that specializes in the distribution of bicycles. In the past, the company has maintained ample inventories of bicycles to enable filling orders immediately, so...
-
The Apache NetBeans IDE is an open-source integrated development environment, and it supports development of all Java application types, which include . a. Java desktop applications b. Mobile and Web...
-
Calculate the NPV of the project described in Practice Problem 41, but assume that the project would generate annual revenue of $70,000 and annual costs of $40,000 for six years. Assume the discount...
-
From the following statements of financial position and further information you are to draw up a consolidated statement of financial position as at 31 December 2016. During the year Parent Ltd had...
-
Water flows down the face of the dam shown in Fig. P4.43. The face of the dam consists of two circular arcs with radii of 10 and \(20 \mathrm{ft}\) as shown. If the speed of the water along...
-
A bank managers responsibility was making loans. Auditors discovered that several loans he made over a five-year period had not been repaid. A fraud investigation revealed that the manager had been...
-
Bramble Company has two classes of capital stock outstanding: 8%, $20 par preferred and $5 par common. At December 31, 2025, the following accounts were included in stockholders' equity. Preferred...
-
Consider the following information regarding corporate bonds: Rating AAA AA A BBB BB B CCC Average Default Rate 0.0% 0.1% 0.2% 0.45% 2.2% 5.5% 12.2% Recession Default Rate 0.0% 1.0% 3.0% 3.0% 8.0%...
-
Draw a diagram to describe and explain how you will apply value chain theory in resuscitating the township economy.
-
The Brian B. Sand & Zachary B. Sand Joint Trust (the Trust) sued the Biotechnology Value Fund (BVF) under Section 16(b) of the Securities Exchange Act of 1934. Mark Lampert controlled BVF as well as...
-
For the last five years, Madison has worked 20 hours per week at Save Right Pharmacy. She has always been a reliable and efficient employee. When her mother became seriously ill, Madison notified...
-
In 2018, Kafka Properties, LLC, purchased a portion of the property subject to a restrictive covenant, referred to as Lot One. The covenant provides, in relevant part, that the owner of the property...
-
On June 3, 2019, Catherine Shanahan received an unsolicited phone call on her cell phone. When she answered, she heard a prerecorded voice message advertising extended automobile warranties (Service...
-
Plaintiff Deborah Ehling was hired by Monmouth-Ocean Hospital Service Corp. (MONOC) in 2004 as a registered nurse and paramedic. Plaintiffs claims in this case arise out of an incident involving her...
-
Define the following accounting and budget terms: a) Acceptable variance limit b) Creditor c) KPI d) Superannuation e) Contingency plan f) Balance sheet g) Net profit h) Operating budget
-
State whether each statement is true or false. If false, give a reason. {purple, green, yellow} = {green, pink, yellow}
-
The six-month forward :S exchange rate is S0.9976 per . A major commercial bank has made public a model that it uses to forecast future :$ spot exchange rates. This model forecasts the spot exchange...
-
It is often argued that automated order-driven trading systems must provide special arrangements for small trades (which are often market orders) as well as for block trades. Advance some...
-
You are given the following hypothetical quotes. Spot exchange rates: :$ 1.1865-1.1870 $: 108.10-108.20 Three-month interest rates (percent per year): In $ 5-5*4 In 3V4SV2 In \V-\% What should the...
-
If a politician running for office does not speak in general terms, does not try to move to the middle of the political spectrum, and does not take polls, is the median voter model therefore wrong?
-
Voters often criticize politicians running for office who do not speak in specific terms (i.e., who do not specify which spending programs will be cut, whose taxes will be raised, etc.). If voters...
-
Suppose the United States can produce 120 units of X at an opportunity cost of 20 units of Y and the United Kingdom can produce 40 units of X at an opportunity cost of 80 units of Y. Identify...
Study smarter with the SolutionInn App