HomeworkLib
Question

How to model this scenario in conceptual ER diagram?Bridge entity needed? I have a house-share entity(...

How to model this scenario in conceptual ER diagram?Bridge entity needed?

I have a house-share entity( primary key : house-share id) and housekeeper entity (primary key: housekeeper id).

At any point in time a housekeeper can only work in one house-share.

When a housekeeper finishes an allocation with a particular house-share the allocation is recorded(start date and end date).

A house-keeper may return to a house-share they previously worked in; if they do so, a new allocation is recorded.

I believe the relationship between house share and housekeeper must be many to many I can come up with a bridge entity(e.g. housekeepingwork)** which have pk's housekeeper id, start_date and end_date. But usually a bridge entity will have primary keys from both entities but not in this case. I'm wondering if I'm modelling this wrong?

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

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
How to model this scenario in conceptual ER diagram?Bridge entity needed? I have a house-share entity(...
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

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure...

    Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure that your ER diagram has the following elements: entities; relationships between entities; primary and foreign keys, and other necessary columns for each entity. Global Trading (GT) is a wholesale business that sells a variety of products; its customers are other businesses. Also GT's vendors are other businesses. GT has the following business rules for the database that the company wants you to design: -A...

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

  • I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram...

    I need help. Valley Vineyard Conceptual Model Case Read the case then create an entity-relationship diagram that captures the essence of the problem domain. Identify the entities (diagrammed in a rectangle box) Establish and label the relationships (diagrammed in a diamond) Determine the cardinalities Add the attributes, if you diagram is too busy the attributes can be on a separate page. Be sure to note any assumptions you have made. CASE: Valley Vineyard’s customers are mainly restaurants and wine shops...

  • Create an ER model for the scenario. Make sure that you read the description carefully. Your...

    Create an ER model for the scenario. Make sure that you read the description carefully. Your diagram should reflect all entities, attributes, and relationships in the description. You should make sure each entity has a primary key (a unique identifier). Use the relationship types we used in class (one-to-one, one-to-many, or many-to-many). Don't forget, attributes can describe both entities and relationships. Scenario 2: Tracking Trips for the SchUber Taxi Service A new Philadephia startup called SchUber is a matching service...

  • ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER...

    ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER model using a compute program and then turn in on the blackboard. Your ER model should include all of the necessary entity sets, relationships and keys, as well a weak entities and superclass/subclass relationships, if needed. A company decides to implement a software to monitor its employees' web surfing, and stores history of each employee's surfing in a database, as well as all of...

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