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

2
votes
1answer
2k views

Decomposition of a relation to 2NF then to 3NF

I'm currently studying for my exams and the trouble I am having is how to decompose a relation R with given functional dependencies into 2NF then 3NF. For example for the following R and functional ...
2
votes
4answers
263 views

Does my table violate normalization rules?

I am developing an emulator for a game. My item table looks like this: -- ---------------------------- -- Table structure for `items` -- ---------------------------- DROP TABLE IF EXISTS `items`; ...
2
votes
2answers
218 views

Writing to a DKNF database, but reading from a de-normalized table for performance?

Would the following approach be reasonable? The Goal: queries have to be relatively fast, but without the hassles incurred by writing to a de-normalized database. The Context: A database for ...
2
votes
2answers
377 views

What are the pros and cons of using my customer codes as a primary key?

I am designing a database for one of my sales teams. Right now, the goal is to get a master list of customers and their mailing addresses, but the DB will eventually expand to track some other ...
2
votes
2answers
120 views

Normalizing nearly identical tables

Background I'm managing a relatively small database project in which we are adding support for reporting involving status updates for items in out product table. I was bit thrown into this and I've ...
2
votes
3answers
162 views

Database design for conditional detail table

I have an expense management system for monthly expenses. Expenses are of two types: one-time monthly expenses, and daily expenses for each day of month. I have created the following tables: ...
2
votes
3answers
628 views

Simple scenario needs to go from Unnormalized Data to 3NF - Review Please

NOTE: The Question has been updated. View Edit Revisions to view original question. The scenario. An animal charity that at the moment, track their establishment's costs via a spreadsheet like so: ...
2
votes
2answers
412 views

Why is this relation in 3NF?

I have a relation: R4 = {{T,U,V}, {T → U, U → T, T → V}} I know from looking at the answer key that this relation is in BCNF. I'm going through the process of rigorously determining what normal ...
2
votes
2answers
149 views

design of maintenance database

Lets say i am designing a database that tracks maintenance of equipment. Each piece of equipment has various fields that usually don't change eg. ID, model, serial number etc. Some fields change ...
2
votes
1answer
83 views

Normalisation of practise database [closed]

I am a newbie to database design, and I'm a bit confused about how to create a database with minimum redundancy. Suppose I have a table abc with repetition of data in it and no two rows are same. Now ...
2
votes
2answers
795 views

MySQL Database Normalization Foreign Keys. One to Many relationship. With Diagram

Here is my database design. I've been doing a lot of reading and still don't really know what I'm doing. Hoping you guys had tips! My DB will have millions of entries. Many "People" rows will have ...
2
votes
1answer
929 views

Why is a Star Schema more normalized than a 3NF Schema?

According to Oracle's documentation, third normal form schemas "may require less data-transformation than more normalized schemas such as star schemas". I'm confused, I thought 3NF is the most ...
2
votes
3answers
219 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
3answers
125 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 ...
2
votes
2answers
129 views

Design consideration regarding state handling: how to store multiple, variable states for one entity [closed]

First I have to admit that I'm not a database professional neither are my colleagues. For a new project my colleagues and me came to a design question we couldn't really solve easily. And all the ...
2
votes
1answer
788 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
306 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
1answer
363 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
325 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 ...
2
votes
0answers
36 views

Problem with reaching second normal form in a database

I'm currently taking an Databases/Database server course as a part of my education, and for this week we have been assigned a simple project to complete. I'm facing a problem regarding normalization. ...
2
votes
1answer
98 views

To normalize or not to normalizde? (10 fields)

I'm helping someone to design a database and for a specific case I'm not sure. I have 10 fields - this will never change - that will always be filled and used in every query that could be coming up. ...
2
votes
1answer
133 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: ...
2
votes
0answers
231 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 ...
1
vote
1answer
192 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
88 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
3answers
146 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
2answers
403 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
296 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
234 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
276 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
1answer
452 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
3answers
202 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
182 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
477 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
56 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
2answers
104 views

Can somebody help me normalise this database/check my workings

I am new to database design/normalisation and functional dependencies. I have started a new database class in school this week and we have been given a worksheet that requires the following: This is ...
1
vote
4answers
91 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 ...
1
vote
1answer
140 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
2answers
100 views

Relations, dependencies and normal form

I have some issues in understanding about relations and dependencies. I will show two examples and what I want to know: Assume the relation GTX {G,T,X} with the following dependencies: G,X -> T ...
1
vote
1answer
92 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
284 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
1k 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
106 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
155 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
614 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
260 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
633 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
17 views

Given the functional dependencies of a relation is there more then one way to normalize it?

I"m studying normalization and have been reading through descriptions and examples online. One Concept that isn't clear to me is if the process can be automated at any point. I understand that a ...
1
vote
1answer
51 views

Need some recommendations on organizing data

I'm new here. This question, to my mind, is allowed by the rules I saw in the "2 minute tour". If I got it wrong, no need for nasty grams. I'll delete if enough people say so. But anyway, I have a ...