ZuoTi.Pro
Question

I would like help with this question and please be clear and thank you for the help.

Produce a relational schema diagram that corresponds to the following ER diagram for a Vacation Property Rentals database. Yo

Figure 2: ER Diagram for Question 8 address id C first phone RENTER name middle email last signs Cid begin date RENTAL AGREEM

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
  • Renter (RenterId, FirstName, MiddleName, LastName, Address, Phone, Email)
    [Notes: For the composite entity Name, it's each attributes will be mapped as a simple attribute in the Renter as relational schema doesn’t handle composite attributes.]
  • RentalAgreement (RentalAgreementId, BeginDate, EndDate, Amount, RenterId, PropertyId)
    [Notes: As a rental agreement is signed between a renter for booking a property, each rental agreement should hold the reference for the renter's id corresponding to the property id for which it was signed.]
  • Property (PropertyId, NumberOfRooms, BaseRate, PropertyType, StreetAddress, City, State, ZipCode)
    [Notes: For the composite entity Address, it's each attributes will be mapped as a simple attribute in the Property as relational schema doesn’t handle composite attributes.]
  • BeachProperty (BeachPropertyId, BlocksToBeach, PropertyId)
    [Notes: Beach Property is a specialized class and it should hold the super class's primary i.e. Property's PropertyId as foreign key.]
  • MountainProperty (MountainPropertyId, Activity, PropertyId)
    [Notes: Mountain Property is a specialized class and it should hold the super class's primary i.e. Property's PropertyId as foreign key.]
0 0
Add a comment
Know the answer?
Add Answer to:
I would like help with this question and please be clear and thank you for the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Diagram the functional dependencies and determine the normal form for each relation PROPERTY Property ID Street...

    Diagram the functional dependencies and determine the normal form for each relation PROPERTY Property ID Street Address City State Zip RENTER Renter ID First Name Middle Initial Last Name Address Phone# E Mail RENTAL AGREEMENT Agreement ID End Date Rental Amount Nbr Rooms BooksBase Rate Property Type Property Type = M" BEACH PROPERTY MOUNTAIN PROPERTY Blocks to Beach (Activity)

  • This is how i mapped the relational schema diagram. would this be correct? i feel like...

    This is how i mapped the relational schema diagram. would this be correct? i feel like i am missing something. ud bundle at the start of the class on the due date. ment. 1. (10 pts) Use the ER-to-relational mapping algorithm to map the BANK ER diagram to a relational schema diagram. Prepare the diagram using ERDPlus and make sure to specify all primary keys and foreign keys. (Position the relations so that the arcs from the foreign keys to...

  • Please help me with this question. I would really appreciate it. Please explain briefly I am...

    Please help me with this question. I would really appreciate it. Please explain briefly I am trying to prepare for a test. Consider the following relational database to manage concert and ticket sales. The relations are artist, concert, venue, seat, ticket, and fan. The schemas for these relations (with primary key attributes underlined) are: Artist-schema = (artistname, type, salary) Concert-schema = (artistname, date, venuename, artistfees) Venue-schema = (venuename, address, seating_capacity) Seat-schema=(venuename, row, seatnumber) Ticket-schema = (fanID, date, venuename, row, seatnumber)...

  • DATABASES You are required to design and implement a relational database to help the local community...

    DATABASES You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your preliminary analysis, you have determined the following basic facts about the community center and the services it provides to the residents in the neighborhood: - The community center serves multiple areas which fall into different zip codes.  - The community center provides collaborative family based care services. An immediate family is...

  • Please do Question 9 only with JUST the Alegbra in one expression, thanks. I know how...

    Please do Question 9 only with JUST the Alegbra in one expression, thanks. I know how sql works, just confused on how to write the expressions Instructions When writing a query, write the query in a way that it would work over all possible database instances and not just for the given example instance! Consider the following database schema and example instance for a cab management database. Customer caccount Name gender DOB userName 15243 Pam M 1924 Pfan 26267 John...

  • This assignment consists of a series of SQL questions. For each question, you will need to...

    This assignment consists of a series of SQL questions. For each question, you will need to include: • SQL query. • An explanation of the query. Please include explanations as a comment AFTER your query, e.g., enclosed within a /* comments block */ ). See the first example in the SQL tutorial for a comment. You don’t need to explain straightforward code in comments. Only the parts that are interesting or different, so that we understand what you did. Question-1...

  • Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following...

    Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following scenario. • A Pokémon character has a unique number; a name; stamina, attack and defense values; a date introduced; and one or more moves. • A move has a name, is either quick or special, and has an accuracy and power points. • A Pokémon type has a type name, a description and a type count (the number of characters with that type). •...

  • Due to your experience in designing the database for the "Legendary League" game, you have been...

    Due to your experience in designing the database for the "Legendary League" game, you have been asked to design the ER diagram for a bigger database to manage the events for the "Legendary League" eSports Oceanic Championship (OC). The requirements are as follows: Registered teams compete in the OC. Each team has a name, and a number of team members. A team also maintains a rank throughout the OC, reflecting how well it is doing in the championship. Team members...

  • I need help with this please, I'm very confused. Given the following relational model database schema:...

    I need help with this please, I'm very confused. Given the following relational model database schema: GUEST (email, address, phone_no, name) (phone_no) is a candidate key. Email and address are long strings, phone_no and name are also strings. TYPE (code, description) The type code is a numeric code and the description a length varying string. AMENITY (code, description) The amenity code is a numeric code and the description a length varying string. CITY (city_id, name, state, country) The city identification...

  • Overview This lab provides you the opportunity to insert and update data with the use of SQL comm...

    Overview This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must have successfully completed Lab # 6. In Lab # 6, you executed a script that was provided to you. This script created 7 of the FLIX2YOU tables as documented in the Entity Relationship Diagram in the FLIX2YOU problem document. The second part of lab...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT