All Questions
Tagged with table normalization
9 questions
1
vote
2
answers
102
views
Help - Database design
We are implementing the new requirement in our current web application. If we discuss the database design for the new requirement, it appears to be more complex.
Requirement -
We have two webforms; ...
- 165
-1
votes
1
answer
22
views
Table normalization of given table
I've got a table and I'm supposed to figure out why it breaks with 1NF, 2NF and/or 3NF.
I know the differences between these three, but I'm bad at telling what attributes are primary keys and what is ...
- 11
1
vote
1
answer
4k
views
Strong vs weak entity types on SQL
I have a 3NF normalized database design and was trying to understand the concept of strong vs weak entity types and my understanding is weak entity types are tables that don't have a primary key. ...
- 31
0
votes
1
answer
678
views
Database Model for Various Type of Sensors
I am planning to build a database that will store sensor value for various type of sensors in a factory building. Is there any best practice on how to do this?
-
Option 1 : should I integrate all ...
- 9
0
votes
1
answer
66
views
Should I combine these tables into one, or keep them seperate?
In a question/answer forum component I am writing as part of a site, I have two tables that theoretically look like this(that is, I want said data kept for each entity):
THREAD POST
...
- 21
3
votes
2
answers
1k
views
Best Way to design a table with different types of attachment
I am currently Building a table for message where user can send a message with different types of attachment,
Sender can:
send text per message
send one location per message
send one or multiple ...
- 33
4
votes
1
answer
938
views
Do I have to (sometimes) sacrifice normalization for data integrity?
I often come up against the following challenge, and end up de-normalizing my table design in order to enforce data integrity. I would be interested to hear if there is a different way of modelling ...
- 315
1
vote
1
answer
45
views
Trying to get BCNF out of this relation
The table is:
Employee (
EID,
Ename,
PID,
ProjectName,
MID,
ManagerName )
For the functional dependencies I got:
EID==>(Ename)
PID==>(ProjectName)
MID==>(...
- 11
20
votes
4
answers
38k
views
How to handle table design with variable columns
I have a table design scenario and as a non-DBA type, would like opinions on which is more scaleable.
Say you are asked to record information on houses for a metro area, starting with a small ...
- 301