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

0
votes
0answers
24 views

Normalize to 3NF Question - Postal Codes/City [duplicate]

Normalize to 3NF and design an ERD for the following data: Name Street City Province Postal Code Home Phone Cell Phone Just want to see if I am doing this right. PERSON NameID Name Phone Number ...
1
vote
3answers
50 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 ...
4
votes
0answers
31 views

Decomposing a relation into 3NF/BCNF

I am having trouble decomposing a relation to 3NF/BCNF. I have determined that for the relation: R (A,B,C,D,E,F,G,H,I) where: {A -> B,C} {E -> F} {D -> I} {A,D -> G} {G -> H} ...
4
votes
2answers
42 views

Anomalous Updates in Normalized Database

I've been trying to understand the three first normal forms of databases and seem to be missing something: Imagine a database with one table consisting of dances. There are 5 attributes: A Dance#, ...
2
votes
4answers
83 views

Normalization for postal addresses in US (address, county, city, state, zipcode)?

I've been trying to understand for the last few years which way is good for storing addresses. I've been getting "normalize all the way" but also "denormalize as much as you can" and I just cannot get ...
2
votes
0answers
39 views

How To Manage Random Data Without Repitition?

We have a database design problem of a Learning System. Please can somebody help us ? These are the requirements : A person can register for a module which has "n" number of questions. The person ...
3
votes
1answer
131 views

Storing created/retired dates for a large amount of different entities

In the db I'm working on now almost every entity has these 4 columns: CreatedDate CreatedBy RetiredDate RetiredBy Usually this is used for logging purposes, and for some of the entities the ...
1
vote
1answer
108 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 ...
2
votes
1answer
32 views

Should I create many ID for a same Person/entity in my DB?

In my model, I must store the name of the teacher of some kids and the classroom in which the teachers work, let’s say. All of the hundreds of teachers in the schools have 1 and only 1 classroom, ...
0
votes
1answer
40 views

Problems in Choosing Foreign Keys :S

I am designing my very first relational database. I am now in the conceptual design, building tables and views, selecting the primary and foreign keys and normalizing everything. But now, I am stock ...
2
votes
4answers
72 views

Row for each date, or 31 columns?

Currently I have a system whose front-end looks like this: The following query: SELECT `l`.*, `s`.`month`, `s`.`year` FROM `summarylines` `l` JOIN `summaries` `s` ON ...
0
votes
0answers
35 views

Am I right about this normalization form?

A given schema R (A,B,C) where A->B, and B->C. a) What normal form is R in? b) If R can be normalized any further please normalize it. My answer for part a) 3NF and b) boyce-codd normal form. Am I ...
-2
votes
1answer
51 views

Is a normalized MYSQL DB faster than one organized with comma strings?

I've always used databases with comma-separated id strings, something like +------+--------------+ | id | users | +------+--------------+ |1 |2,4,5,6,12 | +------+--------------+ ...
3
votes
1answer
30 views

Single table or multiple table design when records have a clear distinction but are queried together?

Let's say I have the following types of recurring data (all types periodically come in). Post (Title, Summary, Text, Timestamp) Image (URL, Caption, Timestamp) Event (StartDate, EndDate, Title, ...
2
votes
1answer
31 views

I created a DB schema for a project relating to collecting comments for web pages, is relational the way to go and how are my relationships?

I'm curious if relational DB is the way to go, if the current relationships in the diagram make sense, and whether it will bode well for coding.
2
votes
2answers
112 views

Modeling invoices and orders

I have a problem in modeling a database that contains orders and invoices. Actually it's more of a problem from a business point of view, but it's related to modeling the database nonetheless. Model ...
3
votes
1answer
44 views

Modeling discounts - Product specific and Customer specific discounts

I have a reasonably simple database but have the following problem: I'm modeling a store + a lot of non-relevant stuff database. I have the following problem. I want to allow for specific products to ...
2
votes
1answer
44 views

Database Table Design

I would like to ask couple of questions regarding my schema table design. I have the following data coming from an external database where I do not have any control over it. PROD_NO PROD_NAME ...
0
votes
1answer
31 views

Nullable Fields to Separate Table?

My website has a form page that has radio buttons yes|no corresponding to 7 questions. When the user selects yes, the user needs to specify a value (either a location, name, or medical condition, ...
-1
votes
1answer
39 views

How to satisfy 1NF with food ingredients?

Take the below table as an example of my situation. How would you organise ingredients so that the values are atomic and satisfy 1NF? Product Code Manufacturer Product Name ...
1
vote
1answer
45 views

Duplicate records referenced across different databases

I have a table holding 'People' data (about 70K records) that coexists with an 'Address' table so there's one AddressID per every person in the 'People' table. The idea was to centralize the data in ...
3
votes
1answer
48 views

Should I create a extra relation-table when I have two columns in one table referencing to one column in another table

My problem is best explained by example: Suppose I have a database about chess games and players. Which one of the following structures should I choose Option 1) player (player_id,name... etc) ...
0
votes
1answer
28 views

Big Size Database and increasing number of users [closed]

Me and my colleagues are using quite big size normalized database. Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations. 80% of the ...
2
votes
1answer
41 views

Does schema normalization enhances query efficiency

I understand the importance of normalization in reducing data redundancy and various anomalies but I am wondering if it can also enhance the performance of your query?
0
votes
3answers
58 views

Is It Needed to Normalize of Date Columns

I am designing a small database with relatively small data. The question is about normalization of Datetime columns. The dates of year occured many times and should I create a Days tables with a ...
0
votes
0answers
53 views

Find the Minimal Basis

Suppose we have relation R ( A ,B ,C ,D ,E ) , with some set of functional dependencies, and we wish to project those functional dependencies onto relation S(A, B, C). Given the functional ...
0
votes
1answer
57 views

Find the functional dependencies that hold in a relation

There is a question in my book that asks the following: Suppose we have relation R ( A ,B ,C ,D ,E ) , with some set of FD’s, and we wish to project those FD’s onto relation S(A, B, C). Give the ...
0
votes
0answers
36 views

3NF to BCNF without loss of any FD?

Can you provide an example of a relation which is 3NF, but not BCNF; and while breaking the original relation into two (or more) relations, no FD loses?! Tanx.
3
votes
0answers
30 views

Superkeys of this relation

I am trying to find the superkeys of this relation, but I am having troubles finding out how many superkeys there are and exactly what they are. I figured out that the candidate keys were ...
0
votes
0answers
22 views

Lose some FDs in 2nf normalization?

Suppose we have R=(A,B,C,D) and FDs are {B->C, C->D}. The only candidate key is AB, then A and B are prime; C and D are not prime. B->C breaks the 2NF requirements because is a partial dependency. So ...
2
votes
0answers
26 views

Method to Obtain LossLess Join BCNF Decomposition

I have been told a way to obtain loss less join BCNF but I don't know how to calculate candidate keys(also called super key in some cases) and trivial Dependency. I have been given a relation R = ...
0
votes
1answer
44 views

Normilsation - 2NF and 3NF

I've been through several questions and youtube tutorials, i understand that 2NF is removing the partial dependencies and 3NF is the transitive ones, but i can't get my head around how the following ...
0
votes
1answer
105 views

Decompose table into third normal form

Tables X and Y are given as below : X (A, B, D, E, F, G, H, J) with A and B as primary key Y (K, L, M, N, O, P, Q, R) with K and L as primary key Now we need to decompose these tables into tables ...
0
votes
0answers
49 views

Normalization and multivalued attributes

I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this 'A relation ...
1
vote
0answers
46 views

Is the table in 3NF?

I am creating a relational database - a library management system. I want to show an example where I normalize the data from 2NF to 3NF. My example of 2NF looks like The definition of third normal ...
0
votes
0answers
41 views

Multilingual Article/ Category database design

I wasn't getting any answers over at Programmers and was advised to go over here instead... I wanted to make a design for a multilingual database and after having drawn it up have arrived at 5 ...
1
vote
1answer
74 views

Data normalization (from 0NF to 1NF)

I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this "A relation ...
0
votes
0answers
36 views

Data-Duplication Vs Data Normalization. Better DB model?

I've 2 tables as follow:- Table UserProfile:- id name age gender phone city state country fb email and UserPoints Table having the following fields user_id activity_date app_point redeem_point ...
0
votes
1answer
27 views

Seeking help for my ASP Project. (ERD Correction Required)

I am doing this simple ASP project for my uni, just wondering if you can guys direct me or give me some advice. Project Idea is to create a recipe website which will allow users to add recipes and ...
0
votes
0answers
47 views

Normalization questions with non-real world examples

I have a few questions regarding normalization. I'm aware these may be terrible examples from a practical point of view, but I need to understand how normalization theory applies to them. 1) Table: ...
0
votes
0answers
38 views

Two id columns in one detail table

Let's I have two tables(I have removed some columns for brevity): ADULTS -> ID CHILDS -> ID And I have one table which includes detials about these persons like that: USERS-> ADULT_ID, ...
0
votes
1answer
59 views

Normalization for three somehow identical tables

These three tables are nearly identical. But, there are some exceptions. But, I can't find best normalized structure. Could you please help me? Here is the informations must be hold in database: ...
2
votes
1answer
49 views

Why wouldn't I put the single preferred option into its own table, instead of having a 'Preferred' column?

In similar spirit to How to implement a 'default' flag that can only be set on a single row I would like to specify that, for any given list of possible names for a business, only one of the ...
1
vote
2answers
74 views

Should I normalize my string arrays, or just keep it a simple string?

I am working on a project involving cards from the Magic: The Gathering game. To be of any use, I must load the basic information about each card into my database, but some of the fields may contain ...
2
votes
1answer
122 views

Reporting on a normalized Key-Value pivot

ERD & SQL Fiddle provided. We're trying to design a reporting tool for our stakeholders around a normalized Key-Value Pair model. We've tried to find a solution using Pivot Tables but can't seem ...
-4
votes
1answer
65 views

Create database unique Surrogate Keys without using GUID’s

What is the best way to get database unique surrogate keys in Microsoft SQL Server when using something like “auto increment” as opposed to GUID's. The purpose is to increase performance over using ...
0
votes
1answer
85 views

Normalising Customers and Employers with a people table

At what normalisation stage is it recommend to split say Customers and Employees into a people table and then link to the unique attributes of Customers and Employees. I cant seem to find the ...
1
vote
1answer
112 views

Normalization to 2NF and 3NF

I solved this example to determine 2NF and 3NF. I would like to check if my answer is correct. Can somebody check the 2NF and 3NF of this example, please? R( A B C D E F G H I J) with functional ...
1
vote
2answers
46 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
109 views

Normalizing: when to apply 2NF and 3NF [closed]

I am taking college classes in relational databases for half a year now. As an assignment get to normalize data with 1NF, 2NF and 3NF. I do not find any difficulties making my schema compatible with ...