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
1answer
64 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
66 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
119 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
50 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 ...
1
vote
1answer
325 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 ...
1
vote
1answer
180 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
1answer
169 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 ...
1
vote
1answer
223 views

Normal Form question [closed]

Hey guys I am trying to study for an exam and I cant seem to get my head around normal forms. here is one question: R1 [a b c] fd1: {a,b} -> {c} fd2: c -> b I know the candidate keys are {a,b} {a,c} ...
1
vote
1answer
76 views

Transforming a relation to 3NF

I'm trying to transform the following relation to 3NF but can't figure it out. The relation is (a student can only have 1 major): STUDENT (StuID, StuName, Major), Primary Key = {StuID} I tried the ...
1
vote
1answer
352 views

No-SQL Database Design for restaurant app

I've been working with SQL databases all my life and I am now trying to get into the NoSQL world. I am a looking for a piece of advice on whats the best practice in order to achieve this. Suppose I ...
1
vote
2answers
1k views

How to break table into two without losing performance?

According to http://stackoverflow.com/a/174047/14731, splitting away infrequently-needed columns frees up the cache allowing faster retrieval of the commonly-used columns. I've got a table whose ...
1
vote
1answer
63 views

Denormalization Strategies: When is it appropriate to create redundancy for faster querying?

So I sometimes see databases purposely add redundant information for faster querying. I saw that this was mentioned here but I was wondering when would this be better than indexing, or creating a view?...
1
vote
2answers
62 views

Is this table in third normal form?

I have a table L(A, B, C). Functional dependencies are: A->B, A->C, B->A, B->C. Is this table in 3nf? My thoughts: A and B are keys of this table. Table is in 3nf if there are no transitive ...
1
vote
2answers
224 views

Train Fare Database Normalisation

I have a database to normalize. The database has details of train ticket fares. The trains have different fares depending on the distance and I have to store these fares in the database It is not an ...
1
vote
1answer
175 views

Rules for Decomposition to 2 NF

I am struggling with the concept of 2NF form. Lets say I have a set of functional dependencies for R1(A,B,C,D,E,H,M,K) Where : B -> M,C AB -> D DH -> E H -> K A -> H Whenever I ...
1
vote
3answers
997 views

Does 3NF require 2NF?

I am a bit confused with the definition of 3NF. According to Wikipedia: The third normal form (3NF) is a normal form used in database normalization. 3NF was originally defined by E.F. Codd in ...
1
vote
1answer
56 views

Decomposing into 2NF

I'm currently studying normalization. I know how to normalize the data for given unnormalized list. But I found this question in our past papers. I don't know how to answer to it. Q. Decompose R{a,...
1
vote
1answer
130 views

UK Addresses in 3NF

I am in the process of creating a UK only database which holds information for various sets of people i.e. Staff, Clients etc. The tables for each of these sets of people have an Address, City and ...
1
vote
1answer
129 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
64 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 ...
1
vote
1answer
176 views

Scheme review/Normalization level/query optimization

So I have a relatively complex database I'm designing - basically full in-house accounting setup. In one section I have some concern that I'm over-normalizing; the 'directory' - I'll example the ...
1
vote
1answer
30 views

Normal form for a relation where the number of tuples having the same value in a column is the same for all the possible values in that column

Is there a normal form for a relation that would permit the following table : id | alpha ---------- 1 | a 1 | b 1 | c 2 | g 2 | u 2 | k . . . n | x n | y n | z But not this table : id | ...
1
vote
1answer
57 views

Is this table designed properly

I am trying to model the process of where one co-worker enters a statement of their proposed work procedure and another co-worker commenting and approving the statement. Currently I have one table as ...
1
vote
1answer
318 views

Should I extract / normalize the mailing address despite requirements limiting number / type of addresses?

I currently am working on a contacts application (similar to Outlook contacts combined with eVites and LinkedIn). The requirements for the application are to limit the addresses (and phone / email ...
1
vote
2answers
209 views

How to normalize data en-masse?

Goal: Extract address fields from a users table into a separate addresses table linked by foreign key. I have created the structure below, and have millions of rows to deal with. I need to do this ...
1
vote
1answer
3k views

School database design

I am trying to design a database management system with my PHP and intermediate MySQL knowledge, keeping normalization in mind. These are the assumptions: The school has many students from grade 1 ...
1
vote
1answer
675 views

UNF to 3NF is this relation workable?

I've inherited a flat table of data consisting of around 2 million records. Looking at the data its already in 1NF, i'd like to get this into 3NF. The data is Australian so suburb can't determine ...
1
vote
3answers
2k views

how to convert a table into second normal form

I am really struggling to convert the table into second normal form ive tryed examples which are much easier however i can't seem to be able to identify the keys for this one and work my way forward. ...
1
vote
1answer
193 views

Approach to Analyzing Database Requirements

When presented with requirements for a database driven system, I always find it useful to imagine a world with no computers, where data records were kept in filing cabinets and data was collected by ...
1
vote
1answer
314 views

Does my design adhere to 3NF?

I created this schema with OpenOffice. Does this design adhere to 3NF ? (A relationship link between Equipment and Supplier_Equipment , Customer and Membership should be created but OpenOffice ...
1
vote
1answer
374 views

Are these database tables normalized?

I am developing a webapp for an institute and I designed these tables: Are these tables normalized?
1
vote
1answer
178 views

Database Design - When to use “attributes” rather than additional columns

I'm wrestling with a schema design issue. I'm attempting to determine when I should add another column instead of making it an "attribute". Rather than adding a numerous columns to a table, I ...
1
vote
1answer
578 views

Does this normalized model for artist music records make sense?

I want to make a database about one artist's music records... CD, Vinyl, Cassette, 8 Track, Singles, Ep, Lp, etc... I believe I have a good normalized model that will achieve my needs, however before ...
1
vote
3answers
618 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 ...
1
vote
1answer
484 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 "...
1
vote
1answer
2k 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
0answers
30 views

Normalization problem

Let's suppose a database table such as this: Table = {Competition, Sport, Game, Player, Score} And we have these functional dependencies: Competition + Game + Player -> Score Game -> Sport Player ...
1
vote
1answer
35 views

Decomposition and lossless joins

If someone walk me though the following questions I'd be very grateful. Consider a relation R(A, B, C, D, E) with the following functional dependencies: A, B → C D, E → C B → D i) ...
1
vote
1answer
22 views

Decompose this relation into BCNF

Today, I'm reading about BCNF decomposition algorithm. It says that: BCNF Decomposition Algorithm Input: a relation R0 with a set of functional dependencies S0 Output: a decomposition of ...
1
vote
0answers
30 views

Is this database in 1NF, 2NF and 3NF?

I'm doing a software development course and I have to normalise my tables as part of it. Can anyone double check that my data is normalised correctly? The database is for a gym. It has these tables ...
1
vote
0answers
28 views

Is this a violation of Normal Form?

Assume a cash register system where some users have access to a cash drawer, while others do not (they can only close by some kind of card payment). Keep in mind that a user who closes a check a one ...
1
vote
0answers
19 views

Clustered index on last_update_at timestamp

I have a Votes table , which can be considered a wrapper. I have a sub_items table, which holds one votable item. One Vote has many sub_items. On sub_item is owned by only one Vote. I have a ...
1
vote
0answers
31 views

How to improve on this database design

I have different 'modules' . Currently , they are: Votes Chats To-do lists I am using mysql and long polling to get updates about these modules in near real time. I have also have a table called ...
1
vote
0answers
21 views

Help needed designing a 'Group' concept for students in a class

I've been wracking my brain for a while now trying to figure out how to fit this part of my domain model into the database, but whatever I come up with just feels wrong. I've attached a picture below ...
1
vote
0answers
28 views

Design improvement on multiple references

Im having some 'perception' problem, maybe... I got this table linked multiple times with another small table and maybe is more of a personal problem with the way it looks but I feel there might be a ...
1
vote
0answers
22 views

General Definition of/for Primary Key for Table with Repeated Entries (i.e., not in 1NF)

my first post, my apologies if this does not belong here, please refer me to the/a right site. So I am looking for a general form for a primary key given a table containing non-atomic repeated ...
1
vote
0answers
36 views

is this normalization correct

is this normalization correct for UNF to 3NF
1
vote
0answers
27 views

PostgreSQL: labels vs columns

I have a data structure similar to this: date foo bar baz boo ---------------------------------------- 2015-11-18 1 null 2.5 81.0 2015-11-19 1 78.4 12.8 ...
1
vote
1answer
48 views

Need help on database design

I have a huge database of library system but I have a problem on how to design tables on this database. This is because I have under one entity (for example AUTHOR) a lot of repeatable fields. So I ...
1
vote
0answers
25 views

DATE - Normalization, a multiple ranged query, multiple inserts and multiple update

I have a booking system, airbnb style. TABLES -> prices, house, available_date A house has available days and not available days, but sometimes the days have different prices. A weekend is more ...