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.
3
votes
2answers
121 views
Which tables to create according to relations
We are planning a new system with a new DB (MS SQL Server).
We have the following entities and the following relations:
Entities:
Clubs,
Chains,
PaymentTypes,
etc...
Relations:
Clubs-Chains (M-M);
...
2
votes
2answers
178 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 ...
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 ...
3
votes
1answer
68 views
Reporting Table Design
I'm writing a system that allows users to store values against each week in October and November and each day in December - starting from the first Monday. I'm holding the raw data entered by the ...
9
votes
5answers
1k views
Is database normalization dead?
I've been brought up old school - where we learned to design the database schema BEFORE the application's business layer (or using OOAD for everything else). I've been pretty good with designing ...
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
3answers
276 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 ...
3
votes
2answers
375 views
Database Schema for an address book with different mailing lists
I'm helping a friend out with taking an old excel, single-page database which contains around 12 different columns that store information about:
person first+last name
email(s)
current address ...
3
votes
2answers
159 views
Migrating and normalizing data
We are rewriting a large Django application which uses a MySQL database, and the database schema needs to undergo major modifications. We're also porting the app to use PostgreSQL, for a couple of ...
3
votes
2answers
406 views
Good reason to denormalize?
I have a database with about 40-50 tables. All but 5 are part of a giant hierarchy of 1:M relationships that all point back to one solitary parent (call it "Project"). Each table is joined to its ...
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 ...
3
votes
3answers
112 views
Optimisation Newbie: How much of a 'sin' is redundancy?
I've been developing for a while, but never really had to deal with DB/scaling issues before. That's suddenly changed and I've found myself in the deep end.
I have 2 SQL tables, as such:
VOTES
...
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 ...
2
votes
3answers
369 views
What normal form does a surrogate key violate?
I have following question:
"What normal form does a surrogate key violate?"
My thought was the 3rd normal form, but I'm not quite sure it's just an assumption i am making. Could someone explain that ...
4
votes
1answer
813 views
2NF decomposition + database normalization
If anyone knows about 2NF I'd greatly appreciate if you could tell me if my understanding of it correct my book does not even mention it (except to say is of "historical significance") and I haven't ...
0
votes
2answers
88 views
Mysql Normalization [closed]
I have three tables
USER TABLE
userid, username
1 alpha
Email TABLE
id userid email
1 1 alpha1@test.com
2 1 alpha2@test.com
3 1 alpha3@test.com
Phonenumber TABLE
id userid ...
6
votes
2answers
968 views
Is one-to-one relationship normalized?
Consider we have a large set of statistical data for a record; e.g. 20-30 INT columns. Is it better to keep the entire set in one table as they all belong to a record OR creating a another table ...
7
votes
1answer
747 views
Generating Invoices and Tracking
Every 2 weeks, the system will generate the invoices for the companies.
Company will receive an invoice on the 1st and 16th every month. (It will run via Cron Job every 2 week. It scan through the ...
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 ...
5
votes
2answers
336 views
Unexpected extremely long query time (~5 minutes using nested WHEN-INs)
For the first time, I am running up against a horrifically long execution time of a MySQL query (~5 minutes).
The data in the database is highly (and not arbitrarily) normalized. It very efficient ...
1
vote
2answers
481 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 ...
2
votes
2answers
118 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 ...
4
votes
1answer
372 views
2NF and 3NF How to do it
Given E(ABCDE) ABC are candidate keys
Normalize into 2NF and 3NF
As far as 2NF is concerned the solution is quite easy:
E1(BD), E2(DE), E3(ABC)
But with regard to 3NF I think I'm wrong if I say ...
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 ...
1
vote
2answers
360 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
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 ...
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 ...
1
vote
5answers
459 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 ...
3
votes
3answers
2k views
SQL table design for primary keys (best practice)
I have a User table that contains the following fields
ID (Auto-generated GUID)
UserName
Password
FirstName
LastName
Email
AddressID (GUID)
This is linked to the table Address (1-1 relation) which ...
0
votes
1answer
83 views
What model design supports both data store backed and free form entries?
I have an application where users are tracking a workflow around producing a derivative work from an existing Book. The derivative work, we'll call "BookDerivative" must have a book that it relates to ...
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. ...
4
votes
2answers
346 views
Constraint many to many table between two child tables
New to this exchange site so I hope my question isn't inappropriate.
Creating a somewhat normalized database I had one design problem I'm not sure how to handle efficiently.
One table has a ...
2
votes
2answers
307 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 ...
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 ...
7
votes
1answer
452 views
Is DB Normalization done purely based on the primary key or is it done based on all the candidate keys?
I have come across two flavours of the normalization procedure while referring the internet and textbooks. viz.
Type 1. Normal forms based only on the primary key.
In this type,
-> 2NF disallows ...
1
vote
1answer
671 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
1answer
201 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. ...
12
votes
6answers
249 views
Normalization: Is it considered compliant to split static, numeric values like a year into their own table?
I am having an interesting discussion with another database designer about normalization. In this example, we have a GameTitles table and each record must contain the year in which the game was ...
4
votes
3answers
321 views
Database Design Issues
My question consists of three parts:
When can I be sure that my database design is perfect?
Is returning to the database design to change some issues (i.e, adding new column, deleting a column, ...
4
votes
2answers
533 views
Using IDs from multiple tables in a single column
One of my co-workers created a schema similar to the following. This is a simplified schema including only the parts necessary to address this question.
The system rules are as follows:
...
4
votes
4answers
1k views
Storing arrays of integers in database (for efficient select)
I am creating a database that will store 100.000 (and probably more in the future) users. While this obviously happens in a table with 1 row per user, every user can (and will) store hundreds of ...
6
votes
2answers
160 views
Am I violating any NF rule on my database design?
I am a newbie on creating database... I need to create it for my recruitment web application.
My application needs to schedule screenings, exams and interviews of applicants and save result in the ...
4
votes
3answers
1k views
When to apply normalization in database design
Hello database administrators.
Recently, I have been reading about normalization in order to improve my database design skills. However, I am a bit confused about when to apply this technique. Prior ...
2
votes
4answers
2k views
What is Atomic Relation in First Normal Form
I have read the definition of 1NF which is, "If each attribute of relation is atomic". Please tell me what is Atomic.
4
votes
3answers
1k views
Query to normalize table/combine row text
I have a table (call it oldTable) with columns like so:
ID (int),Rank (int),TextLineNumber (int),SomeText (varchar)
The primarykey is multi-part: ID+Rank+TextLineNumber.
I'm trying to ...
5
votes
1answer
184 views
IIS access log to SQL normalization
I am looking for insert IIS 6.0 access log ( 5 servers, and over 400MB daily ) to SQL database. What scares me is the size. There is a lot of information you are duplicating (i.e. site name, url, ...
1
vote
1answer
500 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. ...
13
votes
5answers
1k views
How far should you go with normalization?
I have a decent amount of data in a database. I have well formed tables and good relationships between them with some redundancy in my data. But how far should I go with normalization? Are there ...
13
votes
3answers
604 views
Duplicate column for faster queries?
The title doesn't make to much sense but i couldn't think a better title for this problem.
I have the following tabels
Projects
id
name
Customers
id
id_project
name
Payments
id
id_customer
...
5
votes
3answers
189 views
Do higher normalized forms always meet the criteria of lower ones?
For example, a database that is 3NF is always 1NF and 2NF; does this hold for 4, 5, and 6?
