Stack Overflow
Stack Overflow

Questions tagged [er-diagram]

Entity Relationship Diagram,also called an entity-relationship model A graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems.

Entity Relationship Diagram,also called an entity-relationship model

A graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems.

37 questions
0
votes
1 answer

Looking for an ERD for this three-way relationship

I am wondering if this can be modeled accurately with an ERD: Each Medal is awarded to only one Player of each winning Team.
vahid
  • 1,118
  • 9
  • 13
0
votes
0 answers

ER diagram relationship and Bridge Tables

I have to design a database for buses timetables. Entities: Bus (idBus*) Stop (idStop*,stopDescription) Line (idLine*,lineDescription) Position (lat,lon) Some constraints are the following: Multiple Buses may operate for one…
yeaaaahhhh..hamf hamf
  • 746
  • 2
  • 13
  • 34
0
votes
0 answers

Retrive related data in a collection of array php

I'm designing a small application using pure PHP. I'm not going to use frameworks. This is my ER diagram. Users can add one or more user notes. And each note can be tagged by user. Users can search by note title, content and also note tags. When…
cha
  • 730
  • 2
  • 12
  • 28
0
votes
2 answers

ENTITY RELATION ? How to relate when one of the component of entity can be the component of another entity too?

There are OWNERS who owns TAXIS and owners provide taxis to a cab company. The cab company have DRIVERS. TAXIS could have one or more allocated drivers and drivers can drive multiple taxis. This means there would be many to many relation between…
user2760858
  • 23
  • 3
0
votes
1 answer

Documenting Excel

We have hundreds if not thousands of Excel files in the organization, with some having dependencies and links to others. So far these Excel files have been used as islands of information, and it is my effort to put some sanity to this. I was…
user1496188
  • 1
-1
votes
1 answer

Database design: multiple unary relationships on same entity

I have three types of user to be stored in the database. school consultancy student (individuals) The idea here is that a student may apply to school directly, or apply through the consultancy. They all have same attributes and hence are stored in…
Sirjan Sharma
  • 79
  • 1
  • 5
-1
votes
1 answer

How to generate database schema for an exiting database in MSSQL?

Please help me letting know how to create a database schema for an existing database in mssql, could this be done through Microsoft SQL Server Management Studio Express? My Boss has asked me generate a database schema for a database of an existing…
Dp's
  • 21
  • 2
  • 4
1 2
3