-
for experts about operations to data access in ER diagram
If I have ER schema where I have:
2 entity: Room, Hotel
1 relationship: Link
Cardinality about Room side is (1:1) each room belongs only to one hotel
Cardinality about Hotel side (1:N) each hotel can have more than one
Hotel has code attribute as primary key.
Room has foreign key: room number attribute + hotel code.
see: https://ibb.co/f471m9Q
My doubt is about operation to evaluate performance database before to migrate to logical model, infact this step is necessary during ER restructuring.
My question:
I have hotel code (e.g. hotel Europe) and I need to know what rooms numbers are in that hotel, I have to access only to relationship "link" or I need to access to Room entity too?
I'd like to understand if, at level ER diagram, "link" relationship contains number attribute too. Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|