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
2answers
40 views

Does this break normalization?

I have an order table, and in the order table I have a contact_id. Now, each contact is linked to an account. For my order table, should I have both contact_id and account_id? If I wanted to say, ...
0
votes
1answer
3k views

Airline reservation system [closed]

I'm making a simple airline reservation system. But I'm not sure about the design decisions I made. Concretely, I'm trying to implement following constraints: each Aircraft can have one or more ...
0
votes
1answer
276 views

Attempting to identify transitive dependency

Hello I am attempting to identify a transitive dependency in the following diagram. I think that possibly the determinate of "Subtotal" is "Quantity" and "Price Charged" but I'm not sure if "subtotal" ...
0
votes
1answer
56 views

Design for hierarchical embedded database

The goal is to construct a hierarchical database of Objects having the following format: TypeA -> ObjectA [values, contains ObjectB*, ObjectC*, etc.] TypeB -> ObjectB [values, contains ...
0
votes
1answer
44 views

How to relate 2 tables to a third when the first 2 tables have a relationship?

For once, I find myself at an utter loss in terms of coming up with a good question title. Consider the three following tables. Each has additional columns, but only the columns relevant to the ...
0
votes
1answer
111 views

How can I normalize this database?

I've got legacy ecommerce database, which is awfully designed and I need to move all products from it to new solution. But I stuck with how product properties stored. So it basically has tens of ...
0
votes
1answer
29 views

Effectively modelling extended classes

I have 3 different types of content for a website, 'Article', 'Video', 'Review'. Each of those three types of content contain common fields and type specific fields. For this, I have created the ...
0
votes
1answer
109 views

Normalise an expenditure table in a budget database [closed]

We have a budget database that stores expenditure items per budget. There are over 100 expenditure items each having common attributes: Amount, Frequency, Comment. The table will have over 300 ...
0
votes
1answer
204 views

store country name or country id [closed]

I am designing a database layout for a site. Agents registering on the site will have to enter their address including the country. Later I will build a dashboard where you would be able to ...
0
votes
3answers
112 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
1answer
264 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
0answers
27 views

Is below table is in 3NF, what can we do to make it in 3NF? [on hold]

buyer_id int(11) No fb_id varchar(250) No gmail_id varchar(250) No buyer_name varchar(50) No buyer_email varchar(50) No buyer_password varchar(100) ...
0
votes
0answers
31 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
0answers
26 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.
0
votes
0answers
16 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 ...
0
votes
0answers
26 views

database design for address parts (county, city, district)

I am working on a data model for an application that is being developed and I'm not sure how to handle the address parts. Companies have one address. The address is split into county, city, ...
0
votes
1answer
56 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
27 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 ...
0
votes
0answers
17 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 ...
0
votes
0answers
29 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
0answers
28 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
23 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
56 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 ...
0
votes
1answer
27 views

Using part of a compound key as foreign key

We have the following situation, in which we have three tables: Article ------- - Id (PK) - Supplier_Id - Supplier_Contactperson_Id - Name Supplier --------- - Id (PK) - Name SupplierContactperson ...
0
votes
1answer
54 views

what should be the good normalization for the following scenario?

ITS JUST FAKE TABLE DATA TO SIMPLIFY MY PROBLEM I have tables ,, Users , shirts, pants, belts .... each will have some data... so by some research i have made some scenarios of links between the ...
0
votes
0answers
44 views

Best way to store a function map

I am building a site where data gets filtered through user defined functions to create an output. It is a requirement that the functions are represented in the database as formulas. For example a ...
0
votes
0answers
14 views

Is it proper to make a grand-parent key, a primary key, in its grand-child, in a multi-level identifying relationship?

I'm modeling a DB for a conference ticketing system. In this system attendees are members of an attendee group, which belong to a conference. These relationships are identifying, and therefore FKs ...
0
votes
0answers
31 views

why this FD make 3NF?

Question like this: Consider the relation scheme ABCDEF satisfying the following functional dependencies: BC --> ADEF CD --> B E --> D BC is a key and designated as primary. Explain why the ...
0
votes
1answer
98 views

Decompose Relation R(ABCDE) in 2nf and 3nf

Given relation R(ABCDE) with functional dependencies A->C B->D AB->E Given: AB is the primary key. I know that this relation is in 1NF because of partial dependencies A->C and B->D Now how I ...
0
votes
1answer
86 views

Array column vs another table when the relationship is quite small

The Data I am creating a table of cities and their zip codes for the United States. Some zip codes have a list of acceptable cities, as designated by the USPS. For example, the zip code 36613 is ...
0
votes
0answers
33 views

Fourth Normal Form

It's been about ten years since I paid real attention to fourth normal form, and my understanding of multi-value dependencies has seriously waned. How far is this table from 4NF and why? CREATE TABLE ...
0
votes
0answers
30 views

Closure set of functional dependency

Can anyone tell me what is the use of finding the closure set of a functional dependency? I know how to find F+ from F but don't know the use of F+.
0
votes
2answers
33 views

How can I maintain old information after an update?

I am having an issue figuring out a solution to not lose old information. For example, customers can place many orders. Let's a customer, Mary, makes her 1st order in 2013. Fast-forward to 2014, ...
0
votes
0answers
14 views

Users_With_Messages Table normal form

I have the following tables in my database: Above these tables (not pictured) is a Users table where the SendingUserId and ReceivingUserId are keyed onto (they are foreign keys). Are these tables ...
0
votes
0answers
38 views

Normalization of irregular relations?

I have two tables in MySQL: The orders table CREATE TABLE `orders` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `transaction_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `task_id` ...
0
votes
1answer
337 views

Airport Database Design guidance required

I am trying to make a generic database for airport management and DBMS would be oracle 11g xe. Since, i am amateur and still learning so i have tried to kept the problem statement simple with limited ...
0
votes
0answers
23 views

loading k:v pairs from DB into JS Object

I'm creating a single player web RPG. I'm debating the following method of storing/retrieving quest items per player id: In userstats table, have a quest_items column of type mediumtext, where I ...
0
votes
0answers
46 views

Normalization to BCNF help needed

I have a table with 5 columns as A, B, C, D, and E. The functional dependencies are: AB -> C,D,E BCD -> A BCE -> A,D BD -> E I think AB is the candidate key. I can't find any other candidates. ...
0
votes
0answers
142 views

Database normalization tables

I am creating a database for a very basic website. I have created the tables and put what I thought might be the correct schema, however I am having doubts about it as well as a couple problems. All ...
0
votes
0answers
126 views

How to convert this relation to 2NF?

In my Entity Relationship Diagram, an entity type TEACHER had a relationship of TEACH with another entity type called CLASS. CLASS was a week entity type of TEACHER,so when mapping to a Relational ...
0
votes
0answers
103 views

Normalise the database, struggling to understand how i can normalise this

Cross post warning: I recently found dba.stack exchange so i thought it would be better to post there: ...
0
votes
1answer
57 views

Maximum normalization

I have been studying the normal forms rules to guide me with database design and data storage, the problem I am having is that once I optimize for the first normal form (1NF), I figured I may well ...
0
votes
0answers
235 views

Normalizing data to 3NF

I need some help with normalization. Here is the data in 0NF : **HOSPITAL SERVICES (date_hospitalization , id_patient , id_doctor , name , surname , PIN, duration_of_hospitalization , ...
0
votes
1answer
28 views

Good idea to include summary of frequently accessed data from another foreign-keyed table?

Sorry for poor title, I'll try to explain it in more detail here. I have an application that often gets a row from table A, then looks up a column from that in a foreign key mapping table (table B), ...
0
votes
2answers
782 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
241 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 ...
0
votes
1answer
95 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
votes
1answer
187 views

database normalization to 3NF [closed]

I am just at a complete lost. I need help with this. There should be 12 tables (or perhaps 11 since one table has just a single attribute) when you are finished with the normalization and merging of ...
-2
votes
0answers
39 views

Looking for 3NF conversion of an unnormalized table [on hold]

I have the following unnormalized table: CREATE TABLE unnormalized ( project_id int(11) No project_name varchar(100) No category_id ...
-4
votes
1answer
52 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 ...