Questions tagged [erd]
Entity Relationship Diagram
1
vote
1answer
27 views
Converting (a) an entity-relationship diagram about an airline booking scenario to (b) a relational schema
I am currently following notes on a certain "7 step strategy" to transform an ERD to a relational schema and was wondering some points about step 4, converting one-to-many (1:N) relationships.
The ...
1
vote
0answers
15 views
Cardinality with specialization in enhanced entity-relationship diagrams
I'm currently taking an introduction course to databases and I've come across a problem not described in the textbook.
I'm wondering about the use of cardinality with the use of specialization in ...
0
votes
1answer
22 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 ...
-1
votes
0answers
41 views
Database Design for Study Hall Reservation (with shared chairs) [on hold]
Suppose we have a study hall that we want to implement a reservation system for it. Users could reserve specific time-span as "fromDate" and "toDate" by a calendar.
Every Valid selected time span ...
0
votes
1answer
47 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?...
0
votes
1answer
42 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-...
-1
votes
1answer
49 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 ...
1
vote
0answers
17 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 ...
4
votes
2answers
67 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 ...
1
vote
0answers
92 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:
...
4
votes
2answers
53 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 ...
-3
votes
1answer
25 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 ...
0
votes
0answers
28 views
How does an extended entity-relationship to relational mapping work in case of union type?
(This is not a homework question, this example is for my understanding)
Consider the example shown in the diagram below:
As I believe, Sponsor is a subclass of Club, Team and Dept, and an entity ...
1
vote
1answer
31 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 ...
2
votes
0answers
58 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).
...
-1
votes
1answer
50 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 ...
3
votes
1answer
116 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 ...
1
vote
0answers
77 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 ...
1
vote
0answers
33 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 ...
1
vote
0answers
85 views
Does my entity-relationship diagram about a car service business reflect the given information? [closed]
I am attempting to create an entity relationship diagram given some information, and was just looking to seek some guidance in regards to errors or improvements that I can make to my diagram. Thanks ...
0
votes
1answer
89 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!
1
vote
1answer
147 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 ...
1
vote
0answers
114 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-...
4
votes
1answer
587 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 ...
1
vote
0answers
26 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 ...
0
votes
1answer
66 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....
1
vote
1answer
20 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 ...
1
vote
3answers
219 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 ...
2
votes
0answers
64 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 ...
1
vote
0answers
29 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 ...
2
votes
2answers
61 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 ...
6
votes
0answers
685 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 ...
1
vote
1answer
49 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 ...
0
votes
0answers
116 views
Manage relationship between product and stock using SKU
My e-commerce database model has these tables.
My question is how can i manage relationship between stock and product. Since a product has a color, brand, sub_category and a size, should I use ...
1
vote
0answers
110 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,...
2
votes
0answers
41 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 ...
1
vote
1answer
34 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 ...
0
votes
0answers
29 views
How to solve the problem with usage of messages at many places?
I'm developing an app, that provides games/quests for users.
A Quest is something like a game and contains multiple Checkpoints. Every Checkpoint contains multiple Steps. Every Step either just ...
1
vote
0answers
43 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(...
0
votes
1answer
21 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 ...
1
vote
0answers
46 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?
3
votes
0answers
26 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 ...
6
votes
3answers
371 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 "...
4
votes
0answers
153 views
Making a Database for a School Cafeteria [closed]
Scenario:
The school Cafeteria requires a database for a web app.
This database meant to store:
Registered users
The orders which the user can make from the web app.
Data about the products ...
0
votes
0answers
35 views
Question on deriving functional dependencies
From the ER diagram, am I right to say that {First Name, Last Name} -> {Salary, Address} and {Department.name}->{Location}?
Also, I am not sure on how to translate the relationship set "Work ...
1
vote
1answer
62 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 ...
0
votes
0answers
49 views
How to increase diagram print size in Sybase PowerDesigner?
I am trying to print a diagram in PowerDesigner but the font size is illegible it is so small (think 30 tables on single piece of paper, it's useless).
Also there is no export diagram option ...
1
vote
1answer
478 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 ...
1
vote
1answer
304 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 ...
1
vote
0answers
146 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
...
