Questions tagged [erd]
Entity Relationship Diagram
334
questions
0
votes
1answer
14 views
How can I categorize entites by their age in an entity relational diagram?
I am designing an entity relational diagram and I need to categorize entities in groups by their age.
What I have is an entity of Person and some personal attributes about it. But I want to have ...
0
votes
2answers
51 views
How to model weak entity in ER diagram?
I was going through the weak entity concepts and was trying to model the relation Hotel has many rooms. I have come up with the partial solution presented below but i'm having a problem to uniquely ...
0
votes
2answers
21 views
multiple entities that share a table
I have this situation where i have two different entities, Researcher and Lab Manager and i want for a both to have a profile.
When a user logs in he could be one of the two entities, and searching in ...
1
vote
1answer
30 views
What will be the relation between Employees and Players, given that some players are also Employees?
I have a requirement where I need to store information on Employees in a company that owns(?) a sports team and also store information on Players from other teams that are not Employees of this ...
0
votes
1answer
23 views
Help needed to design an ER diagram [closed]
I want to design an ER diagram in order to create a database for a small local business. My problem is that the bussiness sells merchandise to persons and businesses both. How can i differentiate ...
0
votes
1answer
22 views
Designing User & its Sub User Database Diagram Problem [duplicate]
There are some business category e.g. Travel Agency, Hotel, Car Rental etc.
Roles:
Management rolesSuper Admin, Staff
Customer side roles are Owner, admin and sales counter
May be etc. customer side ...
0
votes
1answer
25 views
B2B application: users has its own users
B2B Scenario I am trying is that:
The following Roles exists in the system:
Super Admin
Super Admin Staff
Owner (client)
Admin (owner i.e. client and creates admin to define sales counters)
Sales ...
-1
votes
1answer
19 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 ...
0
votes
1answer
38 views
Non-product invoice items
I am having difficulty representing additional charges in an invoice. I understand how to represent the association between an invoice and individual items in that invoice with the use of a ...
0
votes
2answers
35 views
Anonymous and Public User Table Design in twitter like application
I have schema design problem which I am not 100% sure if my assumptions are correct.
So the requirements are:
I need to have 2 different type of user, anonymous and public.
A user can have both ...
0
votes
2answers
34 views
MySQL - Many to Many relationship, or one to many with additional columns
Our product contains some constraints that made us contemplate which table design will yield the best performance.
Our model:
Question table which contains fields like id, body, difficulty, and tags.
...
-1
votes
1answer
114 views
Is my way of creating a entity relationship diagram correct?
From what I understand, 1)table customer and table order should have a one to many relationship since customer has orders. 2)table order and table payment should have a one to many relationship since ...
0
votes
1answer
21 views
How can instructors add users to their classes and at the same time not know all of the institution users?
I have the following entities
Institutions - with institutionID and userID
Institution Users - with institutionUserID
Institution Classes - with institutionUserID, institutionID
Institution Class ...
0
votes
1answer
32 views
Entity whose possible types differ in the FK
I have one entity called "Groups".
"Groups" can be of different types and the difference between each type is the FK.
For instance, if a "Group" is of type "Event ...
0
votes
2answers
69 views
Financial database model
I am completely new to database modelling (except for some academic knowledge from a long time ago) but for my new project I want to build a database for the following application.
I am collecting ...
0
votes
1answer
36 views
“Tuples in a weak entity set are partitioned according to their relationship with tuples in a strong entity” - meaning?
http://web.cs.ucla.edu/classes/fall04/cs143/solutions/chap2.pdf
In the above link, there is the following statement - "Tuples in a weak entity set are partitioned according to their relationship ...
1
vote
1answer
54 views
Weak entity having n instances as the 'one'
I'm struggling with a question, I'm just trying to figure is it even valid , if not where does it violates the rules of a weak entity relationship, I think it's not valid because how can a weak entity ...
3
votes
2answers
215 views
One and only one relationship - ER diagram to relational schema
I'm taking this term a DB course as part of my CS studies.
This week we began studying the subject of ER diagrams, which I find a bit confusing.
I have some uncertainty about the picture above (Note: ...
1
vote
1answer
47 views
Determining Cardinality in a Logical Model
How should one determine Cardinality in a Logical Model ?
Should it be based on how the rows of an entity relate to another entity or should we consider the natural relationship between the entities i....
0
votes
2answers
28 views
Multiple Primary-Foreign Key connections between Tables Redundant?
I have two tables, Reviews and Critic
I'm pretty new to RDBMS and I was wondering if the connection between Review.rID and Critic.Review is redundant?
My reasoning is that a single critic can have ...
-1
votes
1answer
37 views
Database scheme design for complex movie system
I'm creating a complex app for cinemas including frontend and reservation system. I struggle with a DB scheme and this is a worst part for me, I was never good in designing DB's.
Easily said it's a ...
4
votes
0answers
75 views
Accounting database model
Need to build a service with an internal wallet function.
Here is a simple use-case diagram:
I have made a DB model
But I don't like it for the next reasons
No guarantee there will be only 1 sub-...
0
votes
1answer
37 views
Issues Designing ER Diagram
I'm trying to design an ER diagram in the relational database module of my course. We were given a scenario to draw a diagram for and then create a database within Access. I have the database covered, ...
0
votes
1answer
24 views
Domain of Attributes for an Entity?
I am new to DBMS and was reading about the ER Model and entities-attributes. I found the following line in the book which I was reading:
The domain of Composite attributes is the cross product of ...
0
votes
0answers
13 views
MySQL: create ER diagram, but in text only
With MySQL Workbench it is possible to create a graphical ER diagram; however, this can become very messy when there are many tables and relations, so it might be good to have something like one or ...
1
vote
1answer
2k views
How to represent foreign key in an Extended ER Model in Chen notation?
This is a spin-off of the question at How to represent foreign key in an ER diagram? which is too vague about the needed notation.
There the idea of underlining FKs with a dotted line is stated. I ...
0
votes
0answers
7 views
ERD - [range] : [range] relationship
Could someone tell how to give a description on the following relationship?
One (or each?) Operator is managed by [how many?] Supervisors?
And one (or each?) Supervisor manages [how many?] Operators?
...
2
votes
1answer
20 views
Modelling a relationship which has multiple one-to-many parents
I am attempting to model a relationship which could have two parents, one of them being optional, and the other being mandatory. The design should have the following rules,
A House must exist as the ...
1
vote
1answer
911 views
Chat/conversation history, entity relationship diagram
Totally aware that there are very similar questions, went through each of them, but those are pretty simple/basic solutions from where i took some things and ideas to create below entity relationship ...
0
votes
0answers
25 views
Question about Ternary Entity Relationship Model
I can't wrap my head around these claims concerning this Ternary ER Model.
Unfortunately this is in German so here are the translations:
Prüfer = Examiner
prüft = examines
Fach = Subject
Datum = ...
1
vote
1answer
163 views
Is it possible for total participation constraints to be enforced by an attribute?
For a school Food Delivery application I am developing, I've been told to use the most accurate ER model that captures as many constraints as possible. In particular, I have decided to enforce a given ...
0
votes
1answer
453 views
What is the Relationship between Instagram users and user followers
I'm building a blog project, which each user can follow other users. I'm still figuring out the design and creating the diagrams first. I know that the relationship between users and followers is many ...
0
votes
0answers
25 views
Simple ERD problem
I am a first year in university and just started learning simple concepts about ERD, was just wondering if a foreign key can be given to a table that has a minimum of one, maximum of one cardinality. ...
0
votes
1answer
185 views
Weak Entities + Partial Keys + 2NF [closed]
I'm a bit confused on the concept of weak entities and normalization and couldn't find any answers online. I know that generally weak entities have a partial key to uniquely identify its own records ...
1
vote
0answers
33 views
How to structure SQL data model to maintain data integrity
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
0
votes
0answers
58 views
Use the following business rules to create a Crow’s Foot ERD
Is there any mistake in the ERD???? it looks weird.
0
votes
1answer
51 views
Can someone give me feedback on my ER diagram?
I am new to creating ER diagrams and was wondering if anyone could review one that I constructed for an assignment. I used min, max notation in my design but I am not entirely sure if I did everything ...
1
vote
0answers
290 views
Food Delivery Service Database Design Questions
For a school Food Delivery application I am developing, I’m facing some problems during the ER model design stage. I have to fulfil many requirements but my main issues I’m having are the following:
...
0
votes
0answers
32 views
Need an ERD of the schema mentioned
Need the erd of the schema for doctor, patient and appointment database. scenario is given as under:
Clinic Management Entity-Relationship Model
-Doctor has a unique id, name, address, qualification ...
0
votes
1answer
377 views
ER model for barber shop
My team and I are designing a database for a barber shop. The main focus of the project is to allow customers to schedule appointments with barbers for some sort of hair service.
Our problem is that ...
1
vote
1answer
782 views
Alternatives to EAV model
I am looking for a design pattern that would allow me to capture metadata relating to columns on a table. More specifically, here is my situation.
I have a database with fields in a field table, ...
1
vote
1answer
1k views
Does a weak entity always have a weak relationship and total participation in ER diagram?
I've found in some videos that say a weak entity has a total participation and weak relationship in er diagram. In other videos it isn't. I couldn't find a clear explanation for this. Please can ...
-2
votes
1answer
383 views
I need to put the data from the diagram in 3NF [closed]
This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database but a flat one table file).
You will design a database for ...
0
votes
1answer
94 views
Survey Database Structure
I am building a database to feed into a PowerBI dashboard.
The data is extracted as CSV (SurveyResults) from Survey Monkey which will be loading into the MSSQL database.
The outcome i am after is the ...
-1
votes
1answer
110 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 ...
3
votes
0answers
265 views
ERD Cinema help [closed]
Im in need of some help. Most of all in the way i think when creating the ERD. I have searched online and asked some people but i think i formulate my question wrong which in turn confuses people. (...
-1
votes
1answer
1k views
What does this diamond shape represent in this ER diagram?
And what is testlog in this diagram is it attribute on relationship.
Thanks
3
votes
1answer
369 views
“Diamond Shaped Relationship” What's the formal term?
Consider the following "Diamond-Shaped" entity relationship diagram:
I'm trying to find some formal readings on why this is a bad design - but Googling "Diamond Shaped Table Relationship" only turns ...
1
vote
0answers
104 views
ER Relationship Total and Partial Participation Example
I am trying to understand partial and total participation.
Given the statement:
"Each restaurant must have one or more dishes and each dish must be provided by exact one restaurant."
The below ...
-1
votes
1answer
261 views
ER Diagram Question [duplicate]
I am reading a book about database systems and in the chapter covering database design using ER, the author aims to explain when to use aggregation versus ternary relationship. In short, each Project ...
