What kinds of information could you capture about this relationship? What would the new ERD look like? Would the intersection entity be considered dependent or independent? Can you think of other kinds of M:N relationships that exist in the real world? How would you resolve these M:N relationships if you were to include them on an ERD? The newly created office of the university, the Student Housing Office, helps enrolled students find apartments for them to stay in while attending school. The office asks apartment owners to fill in an information form about their units for rent that are available (location, number of bedrooms, monthly rent, utilities, curfew, kitchen, CR, distance to campus, etc.). Students needing assistance need to register with the service - they in turn can search the rental information to find apartments that meet their needs or budget. Students then can contact the owners directly to see the unit and possibly rent it. IF it gets rented, the apartment owners then call the Student Housing Office to deactivate their listing when they have rented the apartment or unit. QUESTIONS: 1. What entities would you include on a data model? 2. What attributes would you list for each entity? Select an identifier for each entity, if possible. 3. What relationships exist between the entities that you identified? Label the relationships appropriately, and denote the cardinality and modality of each relationship
What kinds of information could you capture about this relationship? What would the new ERD look like? Would the intersection entity be considered dependent or independent? Can you think of other kinds of M:N relationships that exist in the real world? How would you resolve these M:N relationships if you were to include them on an ERD?
The newly created office of the university, the Student Housing Office, helps enrolled students find apartments for them to stay in while attending school. The office asks apartment owners to fill in an information form about their units for rent that are available (location, number of bedrooms, monthly rent, utilities, curfew, kitchen, CR, distance to campus, etc.). Students needing assistance need to register with the service - they in turn can search the rental information to find apartments that meet their needs or budget. Students then can contact the owners directly to see the unit and possibly rent it. IF it gets rented, the apartment owners then call the Student Housing Office to deactivate their listing when they have rented the apartment or unit.
QUESTIONS:
1. What entities would you include on a data model?
2. What attributes would you list for each entity? Select an identifier for each entity, if possible.
3. What relationships exist between the entities that you identified? Label the relationships appropriately, and denote the cardinality and modality of each relationship.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
