Questions tagged [erd]
Entity Relationship Diagram
114 questions with no upvoted or accepted answers
0
votes
0
answers
2k
views
Creating a Database for Multiple Calendars Support
I am trying to create a calendar application that can support multiple calendars, for instance Indian, Nepali, Russian etc. Users can enable or disable the calendars according to their needs.
I have ...
0
votes
0
answers
513
views
Can an entity be an attribute of another entity?
For ER/EER Diagram:
I have one entity Stadium and another entity Match. In Match entity I have the stadium as an attribute.
The SOCCER database shall keep information about the stadiums used as ...
- 9
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 ...
0
votes
1
answer
51
views
Statistical Database Optimization
My friends and I are building a database for statistical research.
So we have a user that answers 10 questions in a row.
The questions are face-images, one is mirrored and the other one is the ...
0
votes
1
answer
64
views
Relationship issue
I'm working on a ERD with mysql workbench, and i have a little question.
I have a Database with this tables:
company_address
country
state
city
I want to store the address of the company with all ...
- 101
0
votes
1
answer
2k
views
How to design a complex multi approval expense db schema in MySQL
I'm very beginner in database design and had the following problem to solve.
DB schema design for an expense approval system with these cases
approval system, every company has 1 or many teams where ...
- 59
0
votes
1
answer
476
views
Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?
I'll keep it nice and short and simply link to the ERD:
Users can be assigned a role, one of those is student.
So for the sake of this, Students are the same as Users!
A Student can be enrolled in ...
-1
votes
1
answer
272
views
ER Diagram Design
I need Help in making ER diagram that i made a ER diagram of each seperate or making it combine I made it seprate as image attached but how to combine and make it one ER diagram.
Module – 1: User ...
-1
votes
1
answer
262
views
Database design for 'pay at table' product (integrating with restaurant APIs)
I am doing a database project for Uni and am trying to figure out how a 'Pay at Table' app would work for restaurants. I Have found this example company that does this https://readytopay.com/ but i ...
- 1
-1
votes
1
answer
3k
views
What does this diamond shape represent in this ER diagram?
And what is testlog in this diagram is it attribute on relationship.
Thanks
- 15
-1
votes
1
answer
957
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 ...
- 99
-1
votes
1
answer
286
views
Understanding Enhanced Entity-Relationship Generalization Hierarchy Principles
I was given this exercise:
(T/F and justify)
It can be said that an entity related to another entity through a
generalization hierarchy:
a) will always have a total participation with ...
- 101
-1
votes
1
answer
382
views
How to create a SELECT statement involving a subtype
Okay, so all I'm trying to do here is "list" the managers who supervised the employee that charged a customer $100 for a rental on November 1st, 1998.
My issue is that I don't know how to select the ...
-1
votes
1
answer
2k
views
Use the following business rules to create a Crow’s Foot ERD
Is there any mistake in the ERD???? it looks weird.
- 1