Case Study: Umbrella Corporation Rental Management System In view of the growing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case Study: ● ● ● ● Umbrella Corporation Rental Management System In view of the growing demand for property rentals, the Umbrella Corporation Company is planning to establish a property rental management system. The management system will be able to maintain data that is used and generated to support the property rentals business for their clients and property owners. Your team is assigned the project to design a database system to support the Umbrella Corporation Rental Management System. Scenario: Umbrella Corporation has a branch office in each state throughout Malaysia. Each branch office is allocated employees. The data describing the branch office includes a unique branch number, address (street, city, and postcode), and telephone numbers (up to a maximum of three). Employees with the role of Supervisor are responsible for an allocated group of employees called Assistants (up to a maximum of 3, at any one time). Not all employees are assigned to a Supervisor. The data stored regarding each employee includes employee id, name, address, position, sala the assigned Supervisor (where applicable), and the details of the branch office at which the employee is currently working. The employee number is unique across all branches of Umbrella Corporation. Each branch office offers a range of properties for rent. The data stored for each property includes property id, address (street, city, and postcode), type, number of rooms, monthly rent, and the details of the property owner. The property number is unique across all branch offices. The management of a property is assigned to an employee whenever it is rented out or requires to be rented out. An employee may manage a maximum of 10 properties for rent at any one time. Currently, the Umbrella Corporation Company is managing 30 properties. The details of property owner are also stored. There are two main types of property owner: private owners and business owners. The data stored for private owners includes owner id, name, address, telephone number, email, and password. The data stored on business owners includes name of business, type of business, address, telephone number, email, password, and contact name. The password will allow owners access to parts of the Umbrella Corporation database using the Web. Currently, there are 12 private owners and 13 business owners that have registered with Umbrella Corporation Company. Umbrella Corporation refers to members of the public interested in renting property as clients. To become a client, a person must first register at a branch office of Umbrella Corporation. The data stored on clients includes client id, name, telephone number, email, preferred type of accommodation, and the maximum rent that the client is preferred to pay. Also recorded is the details of the employee who processed the registration, the date the client joined, and some details on the branch office at which the client registered. The client id is unique across all Umbrella Corporation branches. Currently, there are 20 clients that have registered with Umbrella Corporation Company. Case Study: ● ● ● ● Umbrella Corporation Rental Management System In view of the growing demand for property rentals, the Umbrella Corporation Company is planning to establish a property rental management system. The management system will be able to maintain data that is used and generated to support the property rentals business for their clients and property owners. Your team is assigned the project to design a database system to support the Umbrella Corporation Rental Management System. Scenario: Umbrella Corporation has a branch office in each state throughout Malaysia. Each branch office is allocated employees. The data describing the branch office includes a unique branch number, address (street, city, and postcode), and telephone numbers (up to a maximum of three). Employees with the role of Supervisor are responsible for an allocated group of employees called Assistants (up to a maximum of 3, at any one time). Not all employees are assigned to a Supervisor. The data stored regarding each employee includes employee id, name, address, position, sala the assigned Supervisor (where applicable), and the details of the branch office at which the employee is currently working. The employee number is unique across all branches of Umbrella Corporation. Each branch office offers a range of properties for rent. The data stored for each property includes property id, address (street, city, and postcode), type, number of rooms, monthly rent, and the details of the property owner. The property number is unique across all branch offices. The management of a property is assigned to an employee whenever it is rented out or requires to be rented out. An employee may manage a maximum of 10 properties for rent at any one time. Currently, the Umbrella Corporation Company is managing 30 properties. The details of property owner are also stored. There are two main types of property owner: private owners and business owners. The data stored for private owners includes owner id, name, address, telephone number, email, and password. The data stored on business owners includes name of business, type of business, address, telephone number, email, password, and contact name. The password will allow owners access to parts of the Umbrella Corporation database using the Web. Currently, there are 12 private owners and 13 business owners that have registered with Umbrella Corporation Company. Umbrella Corporation refers to members of the public interested in renting property as clients. To become a client, a person must first register at a branch office of Umbrella Corporation. The data stored on clients includes client id, name, telephone number, email, preferred type of accommodation, and the maximum rent that the client is preferred to pay. Also recorded is the details of the employee who processed the registration, the date the client joined, and some details on the branch office at which the client registered. The client id is unique across all Umbrella Corporation branches. Currently, there are 20 clients that have registered with Umbrella Corporation Company.
Expert Answer:
Answer rating: 100% (QA)
BUSINESS RULE FOR UMBRELLA CORPORATION PROPERTY RENTALS 1 Any new branch getting registered under Um... View the full answer
Related Book For
Contemporary Financial Management
ISBN: 9780324289114
10th Edition
Authors: James R Mcguigan, R Charles Moyer, William J Kretlow
Posted Date:
Students also viewed these mathematics questions
-
The Doraville Machinery Company is planning to expand its current spindle product line. The required machinery would cost $520,000. The building that will house the new production facility would cost...
-
The Sweeney Paper Company is planning to sell $10 million worth of long-term bonds with an 11% interest rate. The company believes that it can sell the $ 1,000 par value bonds at a price that will...
-
Tarheel Furniture Company is planning to establish a wholly owned subsidiary to manufacture upholstery fabrics. Tarheel expects to earn $1 million after taxes on the venture during the first year....
-
Write a data type Interval that implements the following API: An interval is defined to be the set of all points on the line greater than or equal to min and less than or equal to max. In particular,...
-
You are a senior manager of a computer company that competes with Apple, Inc. (Apple). You read a case study about Apple and determined that doing a SWOT analysis of Apple may help you with your own...
-
The customer has just attended the weekly staff meeting for the infrastructure project and has stated that the market is changing for the product being created. As a result of this, the customer has...
-
What's wrong with the following statements? a. A Type I error of .05 means that in 5 out of 100 tests of the research hypothesis, I will reject a true null hypothesis. b. lt is possible to set the...
-
NewLife Hospital purchased a special X-ray machine. The machine, which cost $623,120, was expected to last ten years, with an estimated residual value of $63,120. After two years of operation (and...
-
Define target market . Define customer value . Write in one paragraph what do you think is the future of Marketing . Provide a marketing mix for a new product and the marketing campaign. Define...
-
On January 1, 2012, Fishing Creek Company purchased Skull Valley Technologies for $8,800,000 cash. The book value and fair value of Skull Valleys assets as of the date of the acquisition are listed...
-
Determine the amount of VAT to be paid by TREVISE for the month of September N (VAT collected and payable on sales - deductible VAT on purchases), justifying your answers. TREVISE", a company based...
-
An $800,000 bond issue on which there is an unamortized premium of $57,000 is redeemed for $785,000. Journalize the redemption of the bonds. If an amount box does not require an entry, leave it blank.
-
Question 1 The transactions of Samson Company for the month of March, 2023 are given below: a. Samson, owner, invested $100,750 cash in the company. b. The company purchased supplies for $1,550 cash....
-
Compute cost of goods sold using the following information. Merchandise inventory, beginning Cost of merchandise purchased Merchandise inventory, ending Cost of Goods Sold is Computed as: $ 13,200...
-
Current Attempt in Progress Edward Roddick is the new owner of Ace Computer Services. At the end of August 2023, his first month of ownership, Roddick is trying to prepare monthly financial...
-
Find the value of the determinant. 8-48 1-10 2-10 The determinant value is .
-
What does the potential customer do during the evaluation phase of the consumer adoption process?Explain
-
Q1) What is the a3 Value Q2) What is the a7 Value Q3) What is the a4 Value Q4) What is the b3 Value Q5) What is the b2 Value Q6) What is the sign of 2nd constraint? A pastry chef at a bakery wants to...
-
How can the passive residual view of dividend policy be reconciled with the tendency of most firms to maintain a constant or steadily growing dividend payment record?
-
Explain the relationship between financial decisions and shareholders wealth.
-
The Mutual Assurance and Life Company is offering an insurance policy under either of the following two terms: a. Make a series of twelve $1,200 payments at the beginning of each of the next 12 years...
-
The root mean square value of a signal \(x(t), x_{\mathrm{rms}}\), is defined as \[x_{\mathrm{rms}}=\left\{\lim _{T ightarrow \infty} \frac{1}{T} \int_{0}^{T} x^{2}(t) d t ight\}^{1 / 2}\] Using this...
-
What are the various methods available for vibration control?
-
Fill in the Blank. The presence of unbalanced mass in a rotating disc causes ____________ .
Study smarter with the SolutionInn App