databaseentity-relationship
Entity-Relationship Model for Chat-Database
I am creating an Application for my exam and I am implementing a chat-function. (As Simple As Possible)
Now I need to create an Entity-Relationship-Model
Therefore I have these entities:
chatgroups chatmessages and chatusers
I have created this ER-Model:
Can anyone please tell me if this is the correct way or if there is a more efficient or even better way to create this model?
Best regards
Solution
Your model looks reasonable. I'd advise you to underline your key attributes and to name at least your M:N relationship, e.g. subscriptions, since it must have its own table. Naming the other two would be a good idea though they can be denormalized into the chatmessages entity relation.
- "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
- select multiple cells inner join one table
- 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
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]
- Can an executable file display a website by precising the url? Can I run a specific website on my own .exe file?
- No start database manager command was issued. SQLSTATE=57019
- How to visualize database tables in postgresql using pgAdmin?
- Django Filter __In Preserve Order
- PostgreSQL - query all tables' all table columns
- Which database should I use for my Flutter application?
- Unique key with NULLs
- Is better use an empty value as a '' or as NULL?