Skip to main content

Questions tagged [erd]

Filter by
Sorted by
Tagged with
6 votes
2 answers
18k views

How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?

I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud). How can I use Azure Data Studio to generate ...
Sybil's user avatar
  • 2,558
0 votes
1 answer
1k views

Designing a data model for a survey; building the relationships

Let's say I have a survey that will be handed out to many people. I have a hypothetical diagram with User, Question, and Response entities. Should my relationship be one-to-one from question to answer?...
brennvo's user avatar
  • 91
0 votes
1 answer
251 views

Entity-Relationship Diagram problem: trying to resolve a tentative many to many relationship

The case study states "each car belongs to a car type" and "each mechanic specializes in a car type or many car types". My current entity type definitions: Car CarType Mechanic My Entity-...
B.Morrison's user avatar
0 votes
2 answers
2k views

How to maintain customer addresses for Orders?

The database I am designing is part of a project I am working on. I have come up with 3 simple "business rules": Customers must either be Individuals or Businesses (a business belongs to a certain ...
ProGrammer's user avatar
2 votes
0 answers
270 views

Designing a message system

I want to create a messaging system but I'm stuck in the relationships between the sender/receiver of the message and the message itself. This is a list of requirements for this system: Allow both ...
TJ is too short's user avatar
5 votes
2 answers
3k views

Should a composite primary key out of 3-4 attributes or a unique artificial ID should be used for the situation below?

For a small beginner project to start with databases and system development, I'm trying to develop a system that represents the classic case of an administration system for students and exams. This is ...
JohnDizzle's user avatar
1 vote
0 answers
2k views

Gaming shop database schema

I'm trying to design schema for my personal project that would be an online gaming shop. I would like to ask you guys for any suggestions/tips on how could I maybe improve my current draft. Concerns: ...
mist's user avatar
  • 29
5 votes
2 answers
4k views

How do you read a one-to-many relationship in both directions?

I'm having issues with reading this relationship. Let's take the Professor and Class entities in this example. If I read this from Professor to Class, I would say, "A Professor teaches one to many ...
brennvo's user avatar
  • 91
-3 votes
1 answer
144 views

I need help with normalising the data derived from a survey

Background information: I have been assigned to make a survey on E-sports and build a database. My survey can be accessible here https://devpatel6.typeform.com/to/MB1DYP . In brief, this survey ...
Dev Patel's user avatar
1 vote
1 answer
3k views

Extended Entity-Relationship Diagram: Do the sub classes have foreign keys or primary keys?

Consider this example (they are disjoint, by the way): There are two scenarios which I am guessing: While translating it to relational tables, the rows in PROGRAMMER are unique which do not exist ...
MrRobot9's user avatar
  • 143
2 votes
0 answers
330 views

Modelling a database for a simple IT device tracking scenario

Sorry, my English is not that good. I need a simple IT device tracking sytem at work. For each device I need to know its current location, status and ownership (employee to which it is assigned). ...
liuc's user avatar
  • 21
-1 votes
1 answer
960 views

Is there an open source PostgreSQL IDE that allows for model generation? [closed]

I have done quite a lot of SQL Server work where I could use SSMS. Now I'm working with Postgres and I miss the ability to generate models (diagrams) from existing relations (taking into account ...
Zach Smith's user avatar
  • 2,410
3 votes
1 answer
8k views

How can a weak entity be related to a weak entity?

As we can see in the entity-relationship diagram (ERD) below, the ATTENDANCE entity is related to the TRANSCRIPT entity. But how can entities in TRANSCRIPT be identified if there is no primary key in ...
MrRobot9's user avatar
  • 143
1 vote
0 answers
705 views

Modelling an entity-relationship diagram for a scenario involving companies, services, and clients

I am creating an entity-relationship diagram (ERD) for managing workflow and other details of Company X in which I am maintaining details of the following objects: Employees of Company X Services ...
Sharad Gaur's user avatar
1 vote
0 answers
175 views

Creating an entity-relationship diagram about an art fairs and galleries business environment

Scenario description The charactheristics of the business domain under consideration are: Each and every art item has a unique identifying number, and also a name and asking price. Art galleries ...
Dinomite07's user avatar
0 votes
1 answer
660 views

Entity-Relationship Diagram Software [closed]

I saw this E-R diagram in an answer on Stack Overflow: Does anyone know which software was used to create it? I use LucidChart but that output is really nice!
Martin Jech's user avatar
1 vote
1 answer
2k views

Clarification on Cardinality and Participation

I'm currently redesigning a schema with 20 or so tables and my first task is to create an ERD from the existing tables/constraints/relationships. This has proven more difficult than I expected because ...
nojohnny101's user avatar
1 vote
0 answers
446 views

How to create entity-relationship diagram for tables that can potentially be united by an "IS A" relationship?

I have this schema: create table hall( building-id int, hall-id int, capacity int, primary key(building-id, hall-id) ); create table semester( sem-id char(5), start-date date, eend-...
Yos's user avatar
  • 195
4 votes
1 answer
2k views

Designing a database which can track stock movements

I work for a manufacturing company which sells machines to customers which have a control unit installed in them. We need to keep track of the locations of all the Machines after they are sold to the ...
Bruno Aloe's user avatar
1 vote
0 answers
68 views

Local Transport Fare design: how to relate departures, destinations and locations

I am doing a conceptual model for local transportation fare app The goal is for users to quickly check the current fare and the previous fare from one location to the other. Sometimes, the ...
A. Camara's user avatar
0 votes
1 answer
211 views

Skip ERD in database implementation [closed]

AS we know that entity relation diagram(ERD) is an important concept in database implementation, But I was wondering that can we skip this step when creating a small database containing a few tables i....
Tom 's user avatar
  • 9
1 vote
1 answer
48 views

How to express a "some of which are" and "not all are" relationship with enhanced entity-relationship diagrams?

For example: Gardens have attribute gate, Condos have attribute door. Some of the Gardens and Condos are Private_Properties. On the other hand, Private_Properties are not restricted to only Gardens ...
jexplorer's user avatar
1 vote
3 answers
2k views

What can be best database schema for multiple project and one database? [closed]

I am working on multiple projects but the back-end will remain the same. I have a different server for auth, data, etc. and one database to store all the details. If one projects are creating any ...
Vidhya's user avatar
  • 119
2 votes
0 answers
678 views

Composite attributes in Barker notation

I would like to know how to draw set of entities with composite attribute in Barker's notation. In UML you can do this in that way: and in Chen's notation: Please, help. I have final exam day after ...
Przemek Sulecki's user avatar
1 vote
0 answers
194 views

ERD mostly in text

In LaTeX I can replicate database tables similar to the ones in the diagram below, but I do not want to deal with figuring out how to nicely draw the relation diagrams between the tables. Is there an ...
blackened's user avatar
  • 111
2 votes
2 answers
130 views

Enforcing existence of records while avoiding circular references

I'm having issues designing a satisfactory solution for the following problem. There are two main entities: Customer User A customer can have many users associated to it. A user can be associated ...
Willem-Aart's user avatar
9 votes
0 answers
4k views

Working on a decision tree database design

I'm doing the conceptual model for a Decision tree database. The goal is store any Decision tree. I have four entity types: DecisionTree, Node, Branch and Leaf. Each Decision tree is composed of ...
Amater90's user avatar
1 vote
1 answer
95 views

Can i make a relationship between two relationships in the database?

I am making a database system where there are patients, doctors, categories and medical records. doctor and patient has a relationship called treatments ( many-to-many ) patient and a relationship ...
ahmed nader's user avatar
1 vote
0 answers
419 views

Basic ERD analysis for a martial arts business domain

I am working on a basic website in order to support querying results from martial arts tournament data. We use participation data to determine things like who gets to host tournaments, regional awards,...
JohnP's user avatar
  • 159
2 votes
0 answers
50 views

Modelling a scenario involving architecture firms projects

I'm very new to Database Modelling (using the Finkelstein methodology) and I'm getting confused on a modelling scenario in particular. I am able to draw out the basics, however am running into some ...
Katie's user avatar
  • 21
1 vote
1 answer
107 views

How to make Event (like a Party) Sources mutually exclusive?

I'm designing an entity-relationship diagram (ERD) for a marketplace of events. An event can be created by a user, in which case the Event table must have owner_id or we pull it from an API in which ...
Seio's user avatar
  • 11
1 vote
0 answers
62 views

ERD Design issue - general/central projects table

I have multiple different “project manager” apps as: Work Projects app manager, Home Projects app manager,... Each app has its own DB i.e separate ER diagram. Each app has it's own [projects] table(...
Goce Ribeski's user avatar
0 votes
1 answer
57 views

Basic Geometry Representation

I have an assignment in my introduction to database course. I chose to try and do a database model to represent basic geometric figures and mathematical objects (functions, polynomes, etc). For ...
Carlos Miranda's user avatar
1 vote
0 answers
189 views

How to draw an entity-relationship diagram with "at least" and "exactly" relationships

The business rules are: An order must have at least one product, and a customer must have created exactly one order. How can I draw an entity-relationship diagram for this?
thomassachin's user avatar
3 votes
0 answers
217 views

How to design a database for my entity-relationship diagram about Projects, Tasks and Developers

I'm new to database and my entity-relationship diagram is as follows: According to that I designed my SQL-DDL database statements as shown below: CREATE TABLE Developer ( DeveloperID int NOT ...
Gamma's user avatar
  • 131
6 votes
3 answers
5k views

How to model Parent -> Child -> Grandchild if the Child can be removed

I'm dealing with a set of relationships where the child can be removed, but I obviously don't want to lose the connection between the grandchild and the parent. I did think about marking the child as "...
fgblomqvist's user avatar
4 votes
2 answers
2k views

Entity-Relationship Diagrams: Identifying which way a relationship flows

I am having trouble grasping the "relationship" concept of an entity-relationship diagram. For example, you have Classroom and Furniture as your entities. If you were to put a relationship diamond ...
applaps's user avatar
  • 41
1 vote
1 answer
5k views

Feedback on an entity-relationship diagram for a movie theater business domain

I have an assignment due next week, and for that assignment I am supposed to learn MySQL and create an entity-relationship diagram (ERD). My current attempt Now I've made this ERD The issue I ...
user avatar
1 vote
1 answer
2k views

Translating ERD diagrams into SQL DDL statements

I am currently establishing a database for Students and Courses using ERD. The style of ERD I am using is similar to the diagram below from the ERD Diagram Question: Note: The picture above is NOT ...
isakbob's user avatar
  • 217
1 vote
0 answers
304 views

Working on a scenario where two entity types have two kinds of relationship, one of which is ISA-to-ISA

I am a student of a university, and my teacher thinks my entity-relationship diagram (ERD) is weird. The ERD is about a ramen restaurant. The order receipt looks like this: Tofu Ramen $3 ...
Yudi Supriyadi's user avatar
0 votes
1 answer
12k views

How do we express a weak entity to be dependent on another weak entity?

Perhaps I am looking at my entities as a hierarchy rather than a set of relationships; for sake of an example I have three tables: Authors Books Content Where Authors writes Books and Books contain ...
the noobish undergrad's user avatar
1 vote
1 answer
3k views

Modeling an entity-relationship diagram about Clients, Orders, Payments and Bills

There is a part of an entity-relationship diagram creation that troubles me, I don't know if it's ok. I tried to follow these instructions: A client makes an order (which has products). When the ...
pagnum's user avatar
  • 23
2 votes
1 answer
108 views

Troubles with an attribute that depends on the value of another attribute

I'm redesigning a health insurance costs database (actually they're not really insurance plans in my country but I think that for the sake of the example it doensn't matter). We're the health plan ...
rschpdr's user avatar
  • 121
3 votes
2 answers
4k views

Does my entity-relationship diagram reflect the relevant business rules?

I'm new to database design and I need some critiques, feedback, suggestions, advice, etc. regarding a) some business rules, b) the entity-relationship diagram I have developed to represent them, and c)...
Jinro's user avatar
  • 33
0 votes
1 answer
2k views

Foreign Key as Primary Key when "converting" conceptual entity-relationship elements to logical relations

Hi guys I'm trying to implement database models using MySQL. One thing struck me when I was trying to "convert" an entity-relationship diagram (ERD) to relations (or SQL tables). Note: Please keep in ...
ylee's user avatar
  • 1
-1 votes
1 answer
956 views

Designing a database with a single valued attribute related to multiple entities

Here a customer can submit an order for one or many products . so, there is a one to many relation between customer_order and customer_ordered_products entities. Inside customer_ordered_products a ...
Utshaw's user avatar
  • 99
1 vote
1 answer
656 views

What is an "operational master" with respect to entity-relationship diagrams?

I have a college assignment to create an entity-relationship diagram (ERD) for a database we're going to build. That's fine, but I have to include something called an "Operational Master" in the ERD. ...
Brian McNamara's user avatar
2 votes
3 answers
4k views

How to interpret ternary relationship?

I have tried to search online on how to interpret these ternary relationships but haven't found any clear answer. Since I don't understand how to interpret it I am having trouble changing it into ...
CapturedTree's user avatar
2 votes
1 answer
1k views

Designing a Multiple Reflexive Relationship

I'm making a database diagram and I'm facing the situation explained below. Business rules: A device could have multiple connections with others devices (It's a graph). A device could be a server, a ...
ByteBat's user avatar
  • 121
5 votes
2 answers
30k views

Can a weak entity have a primary key?

Sorry for probably a very basic question, but in the literature and online, I have came across two different definitions of weak entities, which may sometimes be contradictory. 1) Weak entity is an ...
shiftyscales's user avatar

1 2 3
4
5
8