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

4
votes
0answers
142 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 ...
3
votes
0answers
40 views

Online text based game design - Am I linking the databases correctly?

I'm trying to recreate an old game that I used to play that went offline quite some time ago. I'm doing this as a hobby project for myself with the hope that maybe a few hundred people might enjoy it ...
3
votes
0answers
90 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 ...
2
votes
0answers
46 views

Looking for suggestions to model a database of Electrical Components

We have a database of electrical components and I am trying to make sure I have a good design. I am not a database designer (my comfort zone is designing with these hardware components), so I am ...
2
votes
0answers
54 views

Should I move repeating foreign keys into separate table?

Idea Users can upload lots of items and send them from processing. From the upload settings I can set a channel to which the uploaded items belong to. Channel is a separate entity. Currently I set ...
2
votes
0answers
28 views

Creating UNF for multiple actions

I am creating a database design for manufacture company for my coursework. The database design should be able to do these tasks: Buy items from suppliers. (M - N) Items are used for making products. ...
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 ...
2
votes
0answers
42 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 ...
2
votes
0answers
50 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 = ...
2
votes
0answers
97 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 ...
2
votes
0answers
195 views

Identifying functional dependencies

I'm having trouble understanding the logic in use for identifying functional dependancies. Looking at the sample relation below, I understand fd1 - fd3. But when I look at fd4 and fd5, its logic ...
2
votes
0answers
81 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
611 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 ...
2
votes
0answers
400 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
29 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
29 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
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
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
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 ...
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 ...
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 ...
1
vote
0answers
87 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
130 views

Normalized database table with non-atomic values

I'm creating a normalized table for a questionnaire that the customers fill in and in one of the columns is a field called "extra comments". I realize that with the "extra comments" field, the data ...
1
vote
0answers
136 views

DB Design: Looking for Performance improvement with a Column used in all SQL Queries

I recently got added to a new ASP .NET Project(A web application) .There were recent performance issues with the application, and I am in a team with their current task to Optimize some slow running ...
1
vote
0answers
205 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 ...
1
vote
0answers
26 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
140 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
114 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
110 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
17 views

Third Normal Form (3NF) Decomposition

I want know how the decomposition perform in 3NF I have a relation dept_adviser(s_id, i_id, dept_name) Dependency are in relation I_id---›dept_name S_id, dept_name---›i_id After decomposition ...
0
votes
0answers
15 views

Algorithm of decomposition in Boyce-Codd Normal Form

I have to give the keys of the following relation, say if they are 1,2 or 3NF and give a BCNF decomposition. Yet I think I misunderstand the difference between 2NF and 3NF: R(A,B,C,D,E) with ...
0
votes
0answers
16 views

What is the most efficient way to represent this relationship?

In the database a user can follow many different users. I'm looking for an efficient way to represent this. In the image above you can see my initial idea. This works however results in duplicated ...
0
votes
0answers
41 views

Database design for flights, airlines and aviators

I created two tables Airline(airline_id, name) Flight (flight_id, airline_id) - airline_id contains id of airline which perform flight and I want to create third one Aviator But I can not ...
0
votes
0answers
10 views

Entity Relation in Database Normalization

I'm little confused Entity Relationship in normalization, Normalization will automatically create relation or should we create relation attribute by real world example? Suppose I have these ...
0
votes
0answers
25 views

Schema Design for multiple many-to-one relationships. of which exactly one should exist

Say I have table A, B, and C. B and C can both be related to multiple A's, but each A should have exactly one of either B or C related to it. Which database design is better: A: a_id, b_id NULL, ...
0
votes
0answers
181 views

Database Design for group chat

I am creating a chat system as a RESTful API. This is what my design looks so far A request can be made to fetch the newest 50 messages that are part of a group id. Even if I do get a list of ...
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,...... ) ...
0
votes
0answers
25 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) ...
0
votes
0answers
64 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 ...
0
votes
0answers
70 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 ...
0
votes
0answers
42 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
0answers
78 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 ...
0
votes
0answers
46 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
30 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 ...
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 ...