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
1
vote
1 answer

Fantasy Cricket - How do I handle swapping of players and points retention?

I am developing a database for a Fantasy Cricket league for my Database module in college. I had done the design and was fairly confident that I had a working version, but I suddenly realised that I hadn't handled the swapping of players. This is…
Pindub_Amateur
  • 328
  • 1
  • 6
  • 19
1
vote
0 answers

How to include user type column in data dictionary - Visual Paradigm

Designed a data model with ER diagram. Defined Both user type and data type for all columns. But when i try to generate report and produce data dictionary , user type column is not included. So is it possible to include User type column in the data…
Chatosh
  • 51
  • 1
  • 3
1
vote
1 answer

Some confusion about "One to Many" relationship

Please have a look at the below diagram image. That image represents the "One to Many" relationship. It says "Client is introduced by Introducer". Client can have 1 Introducer or non at all, but Intrudcer can have many clients. So even though it…
PeakGen
  • 21,894
  • 86
  • 261
  • 463
1
vote
1 answer

Database Modelling / ER Diagram - Should Look-up tables be left alone as a separate entity?

I'm trying to create a DB that can manage/record sightings of many differing machinery types, be it Cars, Buses, Trucks, Boats, Trains, etc. which will also record all the characteristics of such a sighting [which would obviously vary greatly:…
MVC Newbie
  • 365
  • 4
  • 9
1
vote
1 answer

Relational Databases - Modeling Unbalanced Hierarchy

I've got some entities that are tagged under different categories. However, some of the categories have various sub-categories (up to 2 levels), but the hierarchy is not uniform - some with heights of 1 - 2. My idea was to create a separate table…
SalicBlu3
  • 1,874
  • 2
  • 19
  • 32
0
votes
1 answer

Data Modeling: Class vs. ER Diagram

I know that both concepts are alot different, and I have had the opportunity to work with both. However, I still don't feel confortable answering the question "when one designs a database system, should one class-diagram or ER-diagram it?"... Can…
User
  • 3,244
  • 8
  • 27
  • 48
0
votes
2 answers

Excel ER diagram SQL Server import data tables using .NET code (Excel Add-in)

I would like to import data from SQL tables into an Excel sheet and upon doing so, I would like to show the ER diagram of these sql tables. Whats is the best way to achieve this?
DotNetDude
  • 73
  • 1
  • 2
  • 11
0
votes
1 answer

Normalisation for database ER diagram

Currently im trying to do an assignment question which is assigned to me which is asking me the normalization process. im aware of the 3 normal form. but im stuck with the 3rd normalisation form because i feel that im going to get the similar…
ganeshwaran
  • 1
  • 2
0
votes
1 answer

Creating ER diagram for SQL Server database

Is there any tool available in SQL Server (or any free third party tool) which will create ER diagram of the database? I have 50 over tables and it's painful to create ER diagram one by one adding tables. I am using SQL Server 2012.
user1497569
  • 83
  • 2
  • 12
0
votes
0 answers

ER Model clarification of my diagram

I want to clarify my diagram that I have created; ER diagram I was wondering what I have made means the following things; - A company can book multiples jobs - A company MUST own a job for it to exist Am I correct in those assumptions from my…
has400
  • 49
  • 1
  • 9
0
votes
1 answer

Transfer mysql to access including relationships and foreign keys?

Is it possible to convert My ER diagram/database from MYSQL WORKBENCH to MS ACCESS? Will it include all the tables with their relationships to each other? (foreign keys, data types one to many designations etc. ?)
Gabriel
  • 405
  • 1
  • 6
  • 16
0
votes
1 answer

relating entities in an ER diagram

can i relate an entity with three other entities(weak) over an identifying relationship. For example, an entity item is related to three other entities book_item,cd_item and magazine_item over a "is a" relationship.(book_item,cd_item and…
Hope to learn something here
  • 59
  • 1
  • 6
0
votes
1 answer

Relational Schema to ER Diagram

I have designed a relational model for a university database which is given below. now I am asked to make an ER Diagram of this database. I just want to know that is there any tool using which I can generate the ER diagram from the relational…
Sadman Rizwan
  • 189
  • 1
  • 2
  • 14
0
votes
0 answers

How to create relational mapping when an entity has more than one multivalued attribute in ER Diagram

We know that if there's an multivalued attribute in any entity - A different new table must be created. My ER Diagram has an entity named 'Restaurant' which has 2 multivaued attributes - 1. Location 2. Contact_no Restaurants may have more than one…
kfoozminus
  • 136
  • 9
0
votes
1 answer

Relations in ER diagram

I am trying to create a database for a software development company (as a free time project) I've been struggling with this for quite a while now, it's time to ask you guys for help. I have 3 entities, PROGRAMMER, PROGRAM and PLATFORM. A programmer…
The Gramm
  • 118
  • 2
  • 12
1
2
3