Question
The Sandy Feet Rental Company rents condominiums at the Sand Feet Oceanside resort.There are two buildings, each of which as condos with two or three
The Sandy Feet Rental Company rents condominiums at the Sand Feet Oceanside resort.There are two buildings, each of which as condos with two or three bedrooms and two bathrooms.In The Shores building, condos are oceanview or oceanfront.The oceanfront condos rent for more than the oceanview properties.The Outrigger building is away from the beach.All the properties rent per week and do not take daily rates.The rate schedule varies by location, number of bedrooms and season of the year.Some properties have high speed internet access and some accept pets.Renters pay a $150 deposit per pet if they want to bring their pet with them.
Sandy Feet Rental Company wants to keep their records in a database. The company deals with customers, owners, transactions and housekeeping charges, among other information. They take in all rental amounts, pay housekeeping per unit and disperse rental funds to the property owners while keeping 25% of the rental fee for their services. The cleaning crew charges $50 (for two bedrooms) or $60 (for three bedrooms).
Create a set of tables for the company in 3NF.Represent your answer in DBDL.(i.e. give table name and fields.Underline the primary key.)Draw an entity-relationship diagram. Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)
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