How do I add a relationship association in Database ER Modeling
I have a smiple ER Model I created in StarUML.
I have worked out how to set up my multiplicity values between two classes. I was wondering how do I state the relationship(s) between each entity.
For example if you look at the image below:
Here I would like to state that students "have" accomodation, and that the accomdation "accomodates" students. How do I do this?
Thanks Peter
You can put a diamond on the line that connects students and accomodation. Diamonds diagram relationashuips. Inside the diamond, you can put "has/accomodates".
There are other ways to diagram relationships. Many ER modelers don't bother with diamonds when the relationships are binary (involving just two entities). If the relationships are ternary, quaternary, etc., diamonds become critical to keep the diagram from becoming spaghetti.
- How to add multiple columns in AWS redshift with alter table query
- Autoincrement separately for each foreign key
- How should international geographical addresses be stored in a relational database?
- MySQL union - alias not visible
- How to index a non unique key in mongodb?
- How to write this SQL query to find each account balance?
- User registration with CodeIgniter
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- "FATAL: remaining connection slots are reserved for non-replication superuser connections" triggers despite closing connections
- "Unsupported OP_QUERY command: insert" in Elixir project when trying to insert into Mongo DB
- Sql Server ldf files growing very fast
- How do I change the timezone to UTC in postgres permanently?
- What performance gains can I expect from database paging?
- Model.create is not a function - strapi
- Unable to copy or move file from databases folder with RNFS in react native
- Android Unit Tests Requiring Context
- Delphi FireDAC with MS Access 2010 database. Why does it convert ACE to Jet?
- database - flattened out vs. normalized
- Extract dirname from full path stored in database
- How to find a string inside a entire database?
- Implementing result paging in hibernate (getting total number of rows)
- Options to enforce a logical constraint in an Oracle database
- How can I tell a database to only return data in discrete portions?
- Where is the boundary for creating a table with types in the database?
- How to sort numbers before letters with linguistic sorting?
- How to implement database engine independent paging?
- How to simulate lost update in MySQL?
- Looking for fast ways to process 2 billion rows of data
- Does a SELECT query always return rows in the same order? Table with clustered index