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
1answer
48 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 ...
2
votes
0answers
37 views

Database Normalization

If someone could guide me on helping me understand if my results are correct I would appreciate that. Let's say I have the following table: BOOK(BookTitle, AuthorName, BookType, ListPrice, ...
2
votes
0answers
43 views

Problem with reaching second normal form in a database

I'm currently taking an Databases/Database server course as a part of my education, and for this week we have been assigned a simple project to complete. I'm facing a problem regarding normalization. ...
2
votes
0answers
246 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 ...
1
vote
0answers
22 views

Difference in the workload related to data-amount and search option

A couple of days ago I was asked why it is necessary to use the first normal form also for separation of names. We have a table which stores private customers (Name+Surname;Information) and business ...
1
vote
0answers
46 views

Lossy Decomposition meaning

Suppose I have a relation R=(A,B,C,D) and I decompose it into: R1=(A,B,C) R2=(A,D) then if it is said that the decomposition is lossy,then what is the meaning of that statement?I have an ...
1
vote
0answers
110 views

Can somebody check this normalisation workings i think i am missing a step or a dependency somewhere

given these two tables: and: I need to first list them as an un-normalised structure(s) then i need to identify the functional dependencies/primary keys. Once i have done this i must represent ...
1
vote
0answers
76 views

Database Normalization help needed

I have been trying to find the normal forms and bcnf for a few database relations, can anyone help me and tell me if im not the right track, if not tell me where im going wrong In the first questions ...
1
vote
0answers
104 views

Why is dynamic pivoting not supported?

TL;DR What is the reason that in 2013 we still can't define a VIEW that displays some pivoted data with a dynamic column set. TL;DR/2 Is pivoting data a denormalization technique? First: Not going ...
1
vote
0answers
83 views

Unable to decompose this relation to BCNF

I have a relation R = { A, B, C, D, E, F, G, H, I } And functional dependencies F ={ ABC -> DE E -> C AB -> F C -> G F -> H H -> IJ F -> B } I am able to do simple BCNF ...
1
vote
0answers
95 views

Difficulty in finding Candidate Keys

I have an homework which should be submitted tomorrow I normaly know normalization concepts but in some questions I have difficulty. How should i normalize this to BCNF? Can you show the steps please? ...
0
votes
0answers
12 views

Trying to get BCNF out of this relation

The table is: Employee ( EID, Ename, PID, ProjectName, MID, ManagerName ) For the functional dependencies I got: EID==>(Ename) PID==>(ProjectName) ...
0
votes
0answers
12 views

Transforming table to third normal form

I have a table like this: L(A, B, C, D, E) and functional dependencies are: AB -> CDE , C -> D, D-> B, D -> E. I need to transform this table into 3NF. I think it's not even in 2NF. I found 3 ...
0
votes
0answers
13 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
29 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
0answers
21 views

Decomposing table into BCNF that preserves dependencies

I have a relation like R(A,B,C) and dependencies like A->B , B->C , A->C I think the relation is in 2NF as candidate key is A. AFAIK when there is only one candidate key then the ...
0
votes
0answers
12 views

Functional Dependencies Query

I am having a confusion in Functional Dependencies I have a relation R(A,B,C,D,E,F) Where {A, B} is the key And the FD set I have is {A->FC, C->D, B->E} What Normal Form is it in? Basically I want ...
0
votes
0answers
12 views

Normalization is Ease to use or Creating indexes without Normalization

I'm confused in modelling the database my requirement is Below two schema's I thought to implement #1 First colleges(id,name) col_course_relation(colleges.id,courses.id) ...
0
votes
0answers
17 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
26 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
76 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
44 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
37 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
0answers
174 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
0answers
39 views

Decomposition into BCNF where an attribute appears in multiple functional dependencies

I am trying to decompose my relation: R = (A, B, C, D, E) with Functional Dependencies F = {D -> BC, E -> B, A -> B, B -> D} The problem is that D appears in two dependencies and in ...
0
votes
0answers
46 views

3NF decomposition

Can anyone tell me how and/or why I'm getting stuck here? I have scouted around on the web for examples of 2NF and 3NF decompositions and they all seem to make more sense than the one I'm working on. ...
0
votes
0answers
61 views

Figuring out determinants when converting table into 1NF form

I have to figure out the determinants in the region for the following table. St ID L Name F Name Phone No St Lic Lic No Ticket# Date Code Fine 38249 Brown Thomas 111-7804 ...
0
votes
0answers
28 views

How to find a projection on the functional dependency?

I have below dependencies on attribute PUT: P -> QR T -> WV R -> UV V -> P Now how to find a projection on the above functional dependencies? I am trying to find a article which can ...