It's UWAweek 47

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 684 articles.
Currently 126 other people reading this forum.


 UWA week 36 (2nd semester, mid-semester break) ↓
SVG not supported

Login to reply

👍?
helpful
11:32am Thu 5th Sep, James S.

I understand that relationship attributes are a separate concept to Multiplicity, but I did find a useful video that explains this in detail: However, this takes the worksheet exercise to a new level because those attributes that we are asked to think about tend to make the ER model more complex because they are absorbed into the framework of existing entities. The gentleman that explained the concept in the video then added that if the relationship attribute cannot be added to the entity attributes themselves, then a new table is formed when there is a many to many relationship. Multiplicity, a separate concept, is in fact the guiding concept in this approach. Not so much confusing, but rather complex. If I am to summarise what he said, take the relationship attribute and add it to the entity attribute in a "one to many", add it to any entity in a "one to one" but build a new table in a "many to many", which itself would require another relationship or so. A domino effect. How de we keep it less complex or maybe simple?

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy