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
129 views

What would be the Candidate key (s) of this relation?

R(ABCDEPG) F={AB->CD, DE->P, C->E, P->C, B->G} To my consideration, the candidate keys are: AB, AG, CD, DE. Am I correct? Why or why not?
0
votes
2answers
57 views

Normal form definitions

I've had trouble finding a straight definition of normal forms online. I don't want any examples or metaphors, just what each form is defined by in a nice format ! I believe there is more than 4 ...
3
votes
2answers
72 views

Database normalization: Which is the best fit?

I have 3 different types of data set: Notification: start_date end_date notification_type country_id state_id Campaign: start_date end_date user_notification Transaction email ...
-1
votes
1answer
29 views

Help with some references [closed]

Kind help if anyone has detailed of what a amstrong database are and how are they useful any current important changes in this field or advice on where I may get info in which forum any link
3
votes
1answer
82 views

Entity Relationship Design; The best scenario

TLDR; What would be the best design choice for the scenario below and how would each design react at extremely large data volume? I have experience working with large government database systems ...
0
votes
0answers
37 views

Is this pattern named and how to normalize it?

I am given a data table : State ( StateId, StateNme, StateCounty1, Statecounty1Seat, StateCounty1Rep, StateCounty2, StateCounty2Seat, StateCounty2Rep, StateCounty3,...... ) ...
2
votes
1answer
60 views

This database has two foreign keys going to a single field, is it in 3NF?

Firstly, here is a picture of the database diagram generated by SQL Power Architect. I needed to create a user_id pair in order to match friend requests to users, but this has given me two foreign ...
0
votes
1answer
30 views

Struggling to design addresses table for fast querying

I have two tables: addresses and locations. Locations zipcode city county state Addresses line1 line2 city county state zipcode Posts Id Address_id Body All my users are required to provide at ...
1
vote
0answers
21 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
1answer
56 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 | ...
3
votes
1answer
125 views

How can I prove / disprove If A ↠ BC and A → B then A → C

/ From GATE 2007 IT: Consider the following implications relating to functional and multi valued dependencies given below, which may or may not be correct. A) If A ↠ B and A ↠ C then A → BC B) ...
3
votes
1answer
66 views

Does the definition of 2NF prohibit _transitive_ dependencies on a partial key or only direct ones?

We know a relation is in 2NF iff it is in 1NF and no non-prime attribute is dependent on a proper subset of the candidate key. But is "dependent" in this definition strict or loose in the following ...
0
votes
0answers
23 views

ER and Precedence Diagrams

I've been having some difficulties creating a "Cruise Ship" database. Basically, what is known to me: Office has information about: Route (final destination/target) Ships Room Room's class (rank) ...
4
votes
1answer
210 views

Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?

I had very carefully asked the table designer why he had chosen to create CSV columns in multiple tables. The designer's answer was that splitting CSV columns into separate tables was unnecessarily ...
0
votes
1answer
23 views

What adverse effects does a table have when it's not even in 1nf? [closed]

What adverse effects would a table have if it's not even in 1nf ? I googled and read the article on Wikipedia but I couldn't find exactly why a table should be in 1nf. Also, I couldn't find what ...
0
votes
0answers
48 views

Help Normalize Movie Database

I'm creating a small movie database and was wondering if someone can let me know if I'm in the right path: The main entities are movies, people, jobs, trailers, and photos. My main concern is the ...
1
vote
2answers
59 views

SQL Data warehouse and normalization forms

I don't know if it's a simple question but does a data warehouse have different rules when it comes to normalization forms? At the moment I am creating some tables in a data warehouse, and they ...
1
vote
0answers
35 views

is this normalization correct

is this normalization correct for UNF to 3NF
0
votes
0answers
66 views

Hard dba case [schema to store delivery prices for shops]

I want to make a database scheme which would allow me to fetch the delivery price for the different Shops basing on the delivery destination (Address/Region) and order value (price). Here is the ...
5
votes
4answers
381 views

Is it possible to get rid of so-called 'Spurious Tuples' completely?

Is it possible to get rid of so-called 'Spurious Tuples' completely? For example: In this example from a textbook, there is an original table: I don't see anything wrong with the two projections ...
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 ...
0
votes
0answers
40 views

How to map this ER model to actual tables?

Suppose we have an ER-design problem like this: A pharmaceutical company sells its products throughout a country. For the ease of sales, the entire country is divided into some Areas. Areas have ...
0
votes
1answer
46 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 ...
0
votes
1answer
90 views

Normalization from UNF to 3NF

I keep getting confused trying to normalize this data. A company makes and sells a product online. There are ten types of Products, each having a code and price. Their Sales Order department takes ...
0
votes
1answer
22 views

Should i separate ContactInfo (sub-entity) from MyTable (main-entity) or Not?

I am designing a database of a school management system. I have one to one relationship of MyTable with ContactInfo table. I am confused whether I separate contactinfo from MyTable or not. ContactInfo ...
1
vote
0answers
24 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 ...
0
votes
0answers
66 views

Exam question about BCNF

I am trying to unravel the following question about BCNF from a past exam paper that is available online. The question, which is on page 7 of the linked PDF, says: Suppose that R(A,B,C,D) is a ...
1
vote
0answers
29 views

Understanding Normalisation [closed]

I have a test coming up regarding the 1,2,3 and BCNF Normalisation. The biggest problem understanding I have is from how to convert from 3 -> BCNF. Firstly how to know if the tables are already in 3NF ...
3
votes
2answers
165 views

Is this in 1NF?

I'm an A-level Computer Science student, and my teacher can't explain how to get me from UNF to 1NF. I've researched a little, but I'm not sure as to whether this table (below) is in 1NF or not. I've ...
1
vote
1answer
55 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: ...
0
votes
0answers
45 views

How much normalization is too much

I am working on designing a database for a site I am trying to build, I created what I believe to be the best normalization strategy, to limit the size of particular tables, and the number of tables ...
0
votes
0answers
26 views

Finding the closure of functional dependencies?

I am working on a problem in which I have to look at the relation R with schema R(w, x, y, z), and the three functional dependencies: w -> z ; x,y -> w ;z -> y For every non-empty subset X of the set ...
1
vote
1answer
74 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
45 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 ...
0
votes
0answers
45 views

Creating a database to analyze transaction data for sports events

I would like to create a database to analyze transaction data for sports events. There is already a transactional database from which I can get raw data into excel. I want to transform this raw data ...
0
votes
0answers
62 views

How to design relationship for racing team trades?

I'm working on a fantasy racing team project. I'm having trouble laying out the schema when it comes to the team table and the trades. I think I have the race, driver, and result tables laid out okay: ...
1
vote
0answers
28 views

Beginner Question: Normalization

We know that we can normalize 1NF to 2NF by removing the partial dependencies. But I saw a lot of examples only show partial dependencies with 1 one of the PKs. If a table (in 1NF) has 3 PKs, and ...
0
votes
2answers
74 views

Making database tables 1NF

I am creating a database for a DVD rental shop, I have various entities that are related to this question, such as Film, FilmStar. For each film, you record its unique number, title, the year in ...
0
votes
0answers
40 views

How do you create a custom replication between normalized and denormalized form using SQL Server

I have a table (on SQL Server 2008) that is denormalized like so: Table: PhoneNumbers Field: Partial varchar(8) -- 123-1234 Field: [Data] -- Refers to 800-123-1234 Data Field: ...
0
votes
0answers
16 views

custom field related to usergroup and products

We need to create dynamically custom fields and store values related to each user or product in database we have product table related to category table and also user table related to usergroup and ...
0
votes
1answer
24 views

Normalising a database for monitoring stations

I have data about monitoring stations. For now it is stored in Excel tabs. I have decided to try to make a database. It will be my first contact with databases. Here is an example how it looks now in ...
2
votes
2answers
60 views

Table “normalization” and tradeoffs

It's been a while since my databases course in university, so bear with me as I try to be unambiguous here. In the domain I'm working in, there are Sources and Destinations. Both have 2D coordinates ...
1
vote
1answer
73 views

1NF vs BCNF cons and pros [closed]

I have a clue what 1NF and BCNF are, but I wonder why should someone prefer 1NF instead of BCNF? What are cons and pros with having relation in 1NF and BCNF?
10
votes
6answers
1k views

Explaining 2NF vs 3NF with an example

I have a problem with second normal form (2NF) and I have been unable to solve it by using Google. It is making me crazy because I am a teacher and I don't want to teach wrong stuff to my students. ...
1
vote
1answer
69 views

Converting table to a 2NF relation

I'm currently going through the process of learning about database normalization & having a crack at creating my first relational database. It was going well until I hit the following problem. ...
1
vote
0answers
32 views

does solution of Normalilization causes duplicacy in NoSQL?

i am currently using mysql as a database but now i have decided to switch rdbms to nosql probably on mongoDB. i have an doubt that nosql removed the concept of normalization from database so in such ...
0
votes
0answers
67 views

Design database table for property listing

I want to design a database for a listing website, this is the first time I design the database, so I am not sure if I in the correct path. Here is the fields that needed in a listing, title - ...
0
votes
0answers
28 views

Database normalization - Must all depedancies be preserved?

When converting to a higher normal form, must all functional dependancies always be preserved? for example: R(W,X,Y,Z) WX --> Y XY --> Z ZY --> W R1(B,C,D) XY → Z R2(C,D,A) YZ → W The ...
2
votes
0answers
44 views

Is there any literature on “re-normalisation” of denormalised data?

I'm involved in a project, the core of which might be generously described as "re-normalisation" of denormalised data. (To be fair, the initial implementation took only the first 90% of the time ...
0
votes
0answers
27 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 ...