Normalization is the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.
2
votes
3answers
173 views
Does this database table violate normalization rules?
I’m working with Access 2010.
I’m developing a database for a public art program – we paint large scale murals on walls.
The database tracks blank walls in the city as potential sites for murals. It ...
2
votes
1answer
360 views
Normalisation from 1NF to 3NF
I need some guidance on normalisation from 1st Normal Form to 3rd Normal form. I have already set up my database which is working fine but needed to show some normalisation to show that I did do some ...
2
votes
1answer
237 views
What is best practice to organize / normalize database tables?
I manage group that uses a database that is about 12 years old.
There are more than 200 tables / views that have been created by various people over the years, many of them no longer with us.
Most ...
2
votes
2answers
514 views
Separate archive tables or soft delete for inventory database
I'm building an inventory database that tracks computer equipment and other hardware devices. At some point in any device's life it is retired and gets archived. After it becomes archived it needs to ...
2
votes
1answer
298 views
3NF decomposition + database normalization
I am studying for a test and would like to know if I am on the right track to get the following into 3NF with minimal number of keys for R:
Given relation R(A,B,C,D,E,F,G) and the functional ...
2
votes
1answer
110 views
Can I normalize my experimental data table further?
I am attempting to get a MySQL database to 3NF, but I'm unsure as to how to get there. I'm new to database design, so please correct me if my understanding is incorrect.
I have 6 columns: ...
1
vote
5answers
467 views
Is normalization process needed?
Well after learning DBMS as a subject i got so many questions in mind. Normalization is one of them. As i learnt it there was a lot more confusion and i found that whatever we do in normalization ...
1
vote
2answers
483 views
Database normalization: Describing trait - foreign key to table, or varchar field with value?
My colleagues and I are having a discussion about the normalization of descriptive traits in the database, such as "status" or "type". Let's call the central table of the discussion "Order".
In my ...
1
vote
1answer
83 views
Record with variable number of columns?
I am trying to model a cable mapping for devices. Each device has multiple cards, and each of those cards has multiple ports. Since both the number of cards and ports vary, I am confused on how to ...
1
vote
2answers
167 views
History table design for supertype/subtype
I'm designing an asset management database that tracks IT hardware. I decided to use a supertype/subtype design. I'm at a point where I want to track history of changes for devices. I wanted to use a ...
1
vote
3answers
119 views
Complex query with multiple normalized fields
We have a fairly simple table structure, but with a LOT of fields per table (talking 40+). This data is initially produced in plain-text, user-readable tables, but then it is translated into ...
1
vote
1answer
209 views
Query regarding normalization of the relations
I am given a case study of Event Management to develop an ER model and based on it its normalization forms and relational schema. Now i have developed my ER Model based on the SRS that i have ...
1
vote
2answers
218 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 ...
1
vote
3answers
168 views
Does this design satisfy 3NF, and can any improvements be made?
Does this design satisfy 3NF, and can any improvements be made?
If it does not satisfy 3NF - why?
By improvements, I only care if it will seriously affect scalability, efficiency, etc - I'm not ...
1
vote
3answers
165 views
is id and phone number enough to uniquely identify a row in phone numbers
Was designing a table a customer_phone_numbers table a while back, which only purpose was to allow us to store as many phone numbers as a user wanted to have on file. I originally came to the ...
1
vote
2answers
361 views
database normalization 2nf, 3nf
I am doing homework about database normalization. I have to decompose the table into 3nf form showing the steps
here is the initial table:
...
1
vote
1answer
71 views
Functional Dependencies and Normal Forms
I'm trying to grasp the concepts of functional dependencies and normal forms, specifically first (1NF), second (2NF), and third (3NF) normal forms. The link here was extremely helpful in deciding the ...
1
vote
3answers
172 views
Best practices for history/temporal tables?
Suppose I have an object, with certain fields which I want to track history, and certain fields which I do not want to track history. From a normalization perspective, is the following schema alright:
...
1
vote
1answer
30 views
Stroring a type of an entry
There is a table estate with numeric fields districtru and districthe (for a name of a district in Russian and Hebrew), which refer to primary keys of the table districts. The districts table has the ...
1
vote
1answer
87 views
Expanding contractions/number ranges into separate records [closed]
I am planning the migration of a directory of image files plus a FileMaker-database containing the corresponding metadata into an Imagic IMS database (formerly known as ImageAccess). The vendor ...
1
vote
1answer
146 views
Tick boxes and Dropdown
Have a look at the image below:
This is "Plain Buger" item - customer can select sauces and extras with it. There are different sizes for Plain Burger.
I need to translate this UI into database ...
1
vote
1answer
484 views
Confusion in BCNF
I understood all the three normal forms which comes before BCNF but when it comes to the BCNF i am finding it extremely confusing and difficult and over the net also i found no good tutorial on it. ...
1
vote
1answer
202 views
General Question on how to setup db's for a social networking site
I am currently responsible for designing the entire database setup for a start up website. It is quite a responsibility and I want to get it right, not only for the site, but for my own experience. ...
1
vote
1answer
501 views
Multilingual Dictionary Database question
Let's say someone is coding a multilingual dictionary in PHP, and he wants to let people submit both words and definitions in English and Spanish, but wants to track it so they can be filtered. ...
1
vote
1answer
30 views
How would I change this relational model to fit a nosql database?
Because of things beyond my control, I have to switch from a relational database to MongoDB for the advertising platform I'm helping to build. I've got a relational schema sketched out, but I'm unsure ...
1
vote
1answer
85 views
Approach to Analyzing Database Requirements
When presented with requirements for a database driven system, I always find it useful to imagine a world with no computers, where data records were kept in filing cabinets and data was collected by ...
1
vote
2answers
134 views
Separate or Combine 2 Tables with Similar Attributes?
I have two kind of users in my business system: Customer and Employee.
Both user have Username, Password, Fullname, Phone Number, Email, and other similar attributes.
I have a difficulty to ...
1
vote
1answer
152 views
Does my design adhere to 3NF?
I created this schema with OpenOffice.
Does this design adhere to 3NF ?
(A relationship link between Equipment and Supplier_Equipment , Customer and Membership should be created but OpenOffice ...
1
vote
1answer
212 views
Are these database tables normalized?
I am developing a webapp for an institute and I designed these tables:
Are these tables normalized?
1
vote
1answer
92 views
Database Design - When to use “attributes” rather than additional columns
I'm wrestling with a schema design issue.
I'm attempting to determine when I should add another column instead of making it an "attribute".
Rather than adding a numerous columns to a table, I ...
1
vote
1answer
122 views
Does this normalized model for artist music records make sense?
I want to make a database about one artist's music records... CD, Vinyl, Cassette, 8 Track, Singles, Ep, Lp, etc...
I believe I have a good normalized model that will achieve my needs, however before ...
1
vote
3answers
277 views
shoud we normalize user profile table with fields like interests,musics,videos,sports, etc?
I've read in an article about social networking database schema and saw that they've used varchar for those columns that I mentioned in the question title. It's not normalized! Isn't it better to have ...
1
vote
1answer
233 views
Normalization: Should common columns of two tables be pulled out into a third table?
Should I further normalize my current design to eliminate redundancies?
I have the following tables:
empl: standard user table
empl_cat: employee "category"
empl_admin_cat: administrative ...
1
vote
1answer
250 views
Multiple values in lookup fields
I know newer versions of MS Access allow multiple selections in lookup fields.
For example, if I'm collecting information on my students, I can have a field called Race with lookup values that ...
1
vote
1answer
675 views
Loading multiValued fields into Solr via flat file, and possibly value position preservation in those fields
A hobby web project of mine uses data from many sources, some flat, some highly normalized. My ETL process boils all sources down to one logical table (which is soon to include some multi-valued ...
1
vote
0answers
35 views
Why is dynamic pivoting not supported?
TL;DR What is the reason that in 2013 we still can't define a VIEW that displays some pivoted data with a dynamic column set.
TL;DR/2 Is pivoting data a denormalization technique?
First: Not going ...
1
vote
0answers
52 views
Unable to decompose this relation to BCNF
I have a relation
R = { A, B, C, D, E, F, G, H, I }
And functional dependencies
F ={
ABC -> DE
E -> C
AB -> F
C -> G
F -> H
H -> IJ
F -> B
}
I am able to do simple BCNF ...
1
vote
0answers
68 views
Difficulty in finding Candidate Keys
I have an homework which should be submitted tomorrow I normaly know normalization concepts but in some questions I have difficulty. How should i normalize this to BCNF? Can you show the steps please?
...
1
vote
2answers
44 views
How to change type from one owner to two different types of owners
I currently have (tables changed):
User
UserID uniqueidentifier,
CompanyID uniqueidentifier, (for future reference)
.. more unrelated fields
(PK: UserID)
UserRating
UserID uniqueidentifier,
...
1
vote
0answers
174 views
Help with normalization - Homework
I'm confusing myself a lot here. I did this before however have never got the hang of it. So I really need help, main issue is 2nf I just get the dependencies completely wrong. So I am practising ...
0
votes
1answer
89 views
Is this table in 3NF?
I have a table person with attributes:
id
name
city
state
country
id is the primary key. Is this table in 3NF? If 1000 people live in same city it seems redundant to store the same data for state, ...
0
votes
1answer
40 views
BCNF when no keys are available
I have a problem understanding a particular case of BCNF.
Let's suppose that we have a relation R(B, C, D) with df:{C->D}.
Is my relation in BCNF and if yes why???
Is C considered as superkey?
0
votes
1answer
87 views
Same product name with different price in different states
Consider the price of products in the table differs in each state. If the price varies in district I also have to mention it. How can I do this for more than 5 states?
product Name Price ...
0
votes
1answer
309 views
Boyce Codd Normal Form understanding
I have a knotty (at least for me) problem to solve.
Normalize, with respect to Boyce Codd NF, the relational scheme
E(A, B, C, D, E, F)
by assuming that (A, B, C) is the unique candidate key and ...
0
votes
3answers
51 views
Column partially determining accepted values of another column, should be somehow normalized?
I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
0
votes
2answers
117 views
Question regarding 2NF partial key dependency
If the functional depencies are
AB-->CD
BC-->D
IS the relation still in 2NF?,I mean since AB is the key and the 2nd BC,out of which B is part of the key,is the relation still in 2NF??
0
votes
1answer
91 views
Most efficient way to structure segmented data
I am faced with a set of data which I am currently unsure on how to store efficiently. The data in question relates to a calendar which stores information on two different categories of event which ...
0
votes
1answer
125 views
Mobile Phone & Tariffs
I have designed database tables of Mobile Phones & Tariffs.
It should support multiple mobile networks, sale type and the related affiliate.
Points (for operators) are vary depending on the ...
0
votes
1answer
83 views
Database functional dependency BCNF help
I understand most of BCNF and have been able to complete numerous problems with it, I'm just having trouble applying it to the following situation:
R(A,B,C,D,E) FDs: { A->D; BE->A; CD->E }
Here's ...
0
votes
1answer
119 views
Normalization and Breaking down tables for InnoDB
I'm designing a web application, something small but deals with lots of read and inserts.
Let's say 60% read and 40% writes. My storage engine is InnoDB on MySQL. I have a table
called User which has ...
