Where can I learn more about Conceptual Data Model?
Where can I learn more about Conceptual Data Model? I have to create a schema based on the convention in the image below.
I don't understand the "bubble" (or relationship) between the two entities. What should be the name of a relationship (verb, nom, etc.)?
Is there books or websites which cover this data modelisation theory? What is the name of those diagram? I googled as much as I can around "Conceptual Data Model" and I didn't find anything similar to the image above.
Thanks for the help.
P.S. I will be using Open ModelSphere "Conceptual Data Model".
Try learning the Entity Relationship Model : http://en.wikipedia.org/wiki/Entity-relationship_model
And also the Unified Modeling Language : http://en.wikipedia.org/wiki/Unified_Modeling_Language
Here is one book by Korth: http://www.db-book.com/ for starting DBMS. Have a look at the ER-Model chapter.
For UML have a look at : http://www.amazon.com/UML-Distilled-Standard-Modeling-Language/dp/020165783X?tag=particculturf-20
- ERROR: insert or update on table "promos" violates foreign key constraint "fk_businesses_promos"
- Storing Friends in Database for Social Network
- How to pass data.frame for UPDATE with R DBI
- How to randomly select rows in SQL?
- How can I get data from the OpenTelemetry collector into PostgreSQL?
- How to save Some Dynamic data without duplications in SQLite
- DDEV is there a command to (re-)create an empty database?
- Do transaction in Django make things faster
- Performance comparison of using Redis hashes vs many keys
- Does the prepared SQL statements in a stored procedure make the performance better?
- solve error "The entity cannot be tracked"
- Create own IVR that will access Database
- PostgreSQL: Export database to .sql file
- What is the "N+1 selects problem" in ORM (Object-Relational Mapping)?
- With python-oracledb what does 'DPY-4027: no configuration directory to search for tnsnames.ora' mean
- How can I get info from 3 table in one request in surrealQL?
- How to generate SQLite entity relationship diagram from database file
- How do ACID and database transactions work?
- what exactly happen when transaction commit but database crash
- Create Postgres database using batch file with [template],[encoding],[owner] and a .sql file
- Saving credit card information in MySQL database?
- How to use contain in GraphQL query
- MySQL: Order by Count(*)?
- Connect PHP to IBM i (AS/400)
- How to permanently modify a dictionary in python?
- Does Postgres support 'ON DELETE CASCADE' with composite foreign Key
- How to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- get number of updated documents mongo
- NameError: name '_mysql' is not defined after setting change to mysql
- How to optimize an "optimize" MYSQL query that takes a lot of time