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.

learn more… | top users | synonyms

1
vote
3answers
1k views

Normalization: 'zip code' as a primary key

I've seen frequently that you should not have all address fields (zip, street, city, state, country, etc) in the same table as your user info table (pk_id, name, email... ). This would be in ...
1
vote
1answer
928 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
756 views

To normalize or not to normalize for few distinct values

Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined party_types such as 'Person' or 'Organization'. Would you store the party_type in the party ...
1
vote
1answer
161 views

How to remove data redundancy in product table if multiple suppliers are there for same product

I am designing a database where I have different products and suppliers. For example, I have a product, "mobile phone", say an Apple 5S. This will be sold through my website from different suppliers ...
1
vote
1answer
495 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, ...
1
vote
2answers
61 views

SQL Data warehouse and normalization forms

I don't know if it's a simple question but does a data warehouse have different rules when it comes to normalization forms? At the moment I am creating some tables in a data warehouse, and they ...
1
vote
1answer
61 views

How to design tables such that a person can work for many companies? [closed]

Database design such that a person can work for many companies?
1
vote
2answers
251 views

What and How is the ID antipattern?

What is the ID antipattern and why / under which circumstances is it considered an antipattern? The id antipattern is having a unique ID column in each table. The ID is generated for each new ...
1
vote
1answer
286 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
59 views

Better deffining a parent-child relationship on a table

Our team is developing a new system and it has a Warehouse table that must have a hierarchical relationship between entries since a customer can have 1st, 2nd, 3rd and Nth degree warehouses. We first ...
1
vote
1answer
116 views

Is it ok to create additional column for helping other column to be a PK?

Let's say a Person can have more than one nickname. He(she) must enter his(her) nicknames alongside with other details: Here is the table columns: User_Id, Nickame, Age Of course, for now there ...
1
vote
2answers
95 views

Users Characteristics

I'm really battling an issue where I have a Users table that has a growing number of user characteristics (regligion, smoking preferences, etc). The strategy I've used thus far has been to add a ...
1
vote
3answers
749 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
1k views

Splitting a column to normalized table

I have a de-normalized table as Original De-Normalized Table id text 23 first,second|third,fourth,fifth|sixth I want to normalize the database to create the following tables Table 1: (Split by ...
1
vote
1answer
48 views

Why is this not in 2NF and 3NF form? [closed]

R = {A, B, C, D, E, F} Dependencies: {A} -> {C,F} {C} -> {D} {B} -> {E} a. this relation is in 1st normal form (NF). Explain why it is not in 2nd NF and not in 3rd NF. b. make the ...
1
vote
1answer
33 views

Store a revenue based dataset in a relational database

I have several revenue based datasets with below structure: Subject 2012 2013 2014 2015 online marketing 54 50 60 80 website ads 900 850 ...
1
vote
1answer
34 views

Get one column table when doing localization

I have got only one column for a table when i create two localized tables. Code as bellow. -- Month CREATE TABLE `month` ( `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, ); -- Month Localized ...
1
vote
1answer
30 views

If my understanding of BCNF is correct, how did we know that R1 was not in BCNF?

Given that R(ABCDE) AB->C BC->D CD-> E DE->A Since, B is the only attribute absent on the right-hand side, we would start with B. {B}+ = B . Not a CK. Next, we ...
1
vote
1answer
109 views

Index optimization on a view using a full outer join

Table structure: Foo FooChild Bar --- -------- --- ID ID ID Date FooID Date ...
1
vote
1answer
62 views

Building dependence between regional data (Street -> City -> PostalCode -> Country)

I'm in the process of designing a database to contain regional data to be used inside a CRM system. So, a user suspects that things like the city or country are automatically filled (or maybe just ...
1
vote
1answer
2k 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
2answers
333 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
269 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
2answers
736 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
54 views

How to decompose this relation into 3NF relations?

Today I read about the 3NF decomposition algorithm. It said: Find a minimal basis of F, say G For each FD X → A in G, use {X, A} as the schema of one of the relations in the decomposition ...
1
vote
1answer
26 views

Applying second and third Normal Form

Let be a relation R(NameFile, Size, Directory, DateCreation,HourCreation,Login,AutAccess,DateAccess,TypeAcces F={NF,D→S; NF, D →DC; NF, D→HC; L,NF,D→A; L,NF,D,DA,HA→TA; } Part of ...
1
vote
1answer
113 views

How can I improve this table, and subsequently the performance of the queries I execute on it?

I have inherited this table of POS transaction level data. In my opinion it is terrible. There are 3.5 million rows, which span ~4 years, with a distribution of anywhere between 1 result and 100k ...
1
vote
1answer
44 views

How would you normalize a database that has multiple products to a single transaction ID?

How would you normalize this? I can't find a way to keep multiple products under a single SalesID
1
vote
3answers
137 views

Users vs. People - where to keep the email address?

I'm designing an app similar to Facebook, called Headtome. I want to have users that create public profiles, including email addresses. Then, Mary can choose to message John, and that message goes ...
1
vote
2answers
54 views

How to normalize a table that contains a CK not included in the PK?

I have the following table. The PK is model_ID. Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName ...
1
vote
1answer
131 views

Clarification for database creation and relations

I've trying to make database with few tables and relations between them. As I'm not very good in databases at all I need some clarifications. The idea is to connect table with table_1, table_2 and ...
1
vote
2answers
84 views

Preventing duplicate data when usual normalization only makes sense for some of the records

Background I have two tables, one called issues and the other called status_checks, which both contain (among others) the field comment (VARCHAR). An issue is raised by a user when something needs ...
1
vote
2answers
192 views

Need help about normalizing database to 3NF

I am currently working on a city travel guide application which let users explore places and plan trip. In the account module, the following functions are to be considered: User can register by ...
1
vote
1answer
1k views

3NF Decomposition - I'm not sure about this example

I am trying to make sense of an example of 3NF decomposition using the 4-step algorithm mentioned by Ullman here, but I'm not understanding what my lecturer is doing with the last step (or, worse, I'm ...
1
vote
1answer
69 views

Normalise for a very small database?

I am designing a very small database (c. 250 rows). I have a number of datapoints for each record, which under normalization rules, ought to be in separate tables. For instance: Percentages of a ...
1
vote
2answers
487 views

When normalizing a relational database, should multiple “type” tables be combined into one?

Before making substantial changes to the content, functionality and design of my website (I'll be refactoring everything, almost a complete rewrite), I'm setting up a new PostgreSQL database to hold ...
1
vote
1answer
215 views

Is this design in 3NF? Why to choose another design not in 3NF

Having the following entities: Objects, Parts, Subparts and Items, and given the following design restrictions: A Part belongs to one and only one Object. A Subpart belongs to one and only one Part. ...
1
vote
1answer
102 views

Database Over Normalized [closed]

How can you tell when a database is over normalized? Example: I have a database for employee. These are the following tables involved: User - contains email, password, companyId Profile - ...
1
vote
1answer
377 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 ...
1
vote
1answer
155 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
32 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
112 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
166 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
829 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
489 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
18 views

Determining if a relation is in third normal form 3NF

I have a ralation R(A,B,C) with the functional dependencies as follows A->B A->C B->C with A being the candidate key, is this relation in 3NF? well because by analyzing the first two ...
1
vote
1answer
61 views

Apply Definition of MVD (multivalued dependency) to Example?

Supposedly this multivalued dependency (MVD) and this functional dependency (FD): {W} ↠ {N,D} and {W} → {N} hold in this table: V W N D ================= | v | w | n | 1 | ...
1
vote
1answer
61 views

How to satisfy 2NF and what are superkeys? - Understanding the algorithm for database normalization in general

Given the table: Student_subject(studentid, subjectid, username, grade) Primary key consisting of a combination of: studentid, subjectid Candidate key consisting of a combination of: ...
1
vote
1answer
93 views

How is every binary relation BCNF?

So, as part of my assignment, I have to prove that any relation with two attributes is in BCNF. As per my understanding, if for a relation we have 3rd normal form and one non key attribute ...
1
vote
1answer
46 views

Is it recommend to create a table for addresses? [closed]

I have a table persons with the columns per_id, per_passport, per_name and per_address. Two or more persons can live in the same address (like families or room-mates) so if this happened, the data is ...