All Questions
Tagged with erd normalization
13 questions
2
votes
0
answers
73
views
One-to-One? or One-to-Zero-or-One?
Scenario: I am being asked to create an HR training tracker for employees of a business. in this database I am using two tables:
EMPLOYEE(EMPLID, LastName, FirstName, PrimaryEmail) with EMPLID as the ...
-1
votes
1
answer
2k
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 ...
- 1
0
votes
1
answer
971
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 ...
-2
votes
1
answer
1k
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 ...
- 19
3
votes
1
answer
8k
views
Orders and Quotes Tables - Database Design
Below is the ERD of my current db schema for the orders part of an e-commerce site. The site is based on oscommerce, but has been modified, also I have removed quite a few of the fields from the ...
- 133
0
votes
2
answers
1k
views
Modeling a product database and dealing with inheritance
So, to get better at designing databases, I'm attempting to model a database system after the AR15 Builder.
Here is what I have so far:
While it makes sense logically, I'm afraid there may be ...
2
votes
2
answers
633
views
Survey Database - Respondent Table (1NF or 3NF - Pros and Cons)
Building out a Survey ERD ODS layer. Now i'm debating on the design for my Respondent Table. Not sure if its best to have it as 1NF or 3NF. FOr a quick back story I get a survey extract with ...
- 21
5
votes
1
answer
2k
views
Entity Relationship Design; The best scenario
TLDR; What would be the best design choice for the scenario below and how would each design react at extremely large data volume?
I have experience working with large government database systems ...
- 161
1
vote
1
answer
554
views
Can Anyone please review my database after I did the Normalization ?.Any suggestion is appreciated
User:
User_ID,user_name,E-mail
Staff: User_ID,Fname,Lname,DOB
Student: User_ID fname Lname DOB
Lecture: User_ID
Admin: User_ID
Position ID : P_ID,ROLE_NAME,
Staff_position :Staff_position_ID,P_ID,...
- 13
5
votes
3
answers
6k
views
Database design for bookmark system
I am creating a bookmark system where people can save their bookmarks. Each user has its own personal page with bookmarks. A bookmark should have atleast one tag and max five. Each user can create ...
user31574
1
vote
2
answers
477
views
Refactoring/normalization - but almost empty table
I normalized a legacy DB into this structure:
But I'm not sure if it is correctly normalized. I don't feel very comfortable with the almost empty filters table.
The requirements
A group contains ...
- 161
1
vote
1
answer
461
views
ERD directly producing 5NF relational schema - is this desirable?
I have been given a case study of Event Management. I have to develop an entity-relationship diagram (ERD), and based on it check if the resulting relational schema meets the different normal forms. I ...
- 305
7
votes
3
answers
8k
views
When to apply normalization in database design
Prior to learning about normalization I would usually read the scenario/description in the requirements and draw up an ER diagram (using Chen's notation) using nouns as entities and verbs as clues to ...
- 71