Skip to main content

Questions tagged [normalization]

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.

Filter by
Sorted by
Tagged with
-1 votes
3 answers
251 views

Normalization Problem for drugstores information [closed]

I want to capture all data about 10000 drug stores in my country. I design as follows: Drugstore main info (uniqueid, hi_number, drugstorename, drugstoretype, drugstorerelateuniversity, servicetype, ...
Suarez's user avatar
  • 7
2 votes
1 answer
88 views

Assessing the normal form for a relation with a multi-valued attribute

Assume that you have designed the following schema of relations: COURSES (CID, CNAME) STUDENTS(SID, SNAME, FAV_CIDS) However, you can not have a relation with set valued attributes (Did not really ...
conthoughisck8er's user avatar
1 vote
1 answer
2k views

Attempt to find Transitive Dependencies

Table From this table example I am trying to understand both this dependencies. According to me partial dependencies have a primary composite key and transitive dont have. I try to figure out Partial ...
agam's user avatar
  • 21
1 vote
3 answers
785 views

When is it beneficial to move duplicate data to a reference table?

If there is column with values from some finite set S, for example S = { alive, dead, unknown } for a life_state column in a persons table, when is it beneficial to add a reference table? Options: ...
Adam Thompson's user avatar
1 vote
1 answer
79 views

Now to normalize table when position in group uniquely identifies entity

I need to model charts such as the one displayed below... ... and came up with the following: For the sample chart I originally showed.. charts.name is "Custom transactions", charts.y_legend is "...
user1032531's user avatar
5 votes
3 answers
4k views

To Normalize or Not to Normalize

In general, I understand that normalization is usually beneficial even with the join costs. However, I came up with an interesting dilemma recently. What if the data is duplicated but unlikely to ...
Adam Thompson's user avatar
2 votes
2 answers
57 views

Schema For "Other - Add Comment"

Many user forms contain an option for "Other - Add Comment" where the user can provide an item not found in the given list. In other words, the developer sets the list of items. The user must either ...
Steven's user avatar
  • 319
0 votes
1 answer
279 views

Checking if a transitive key dependency is in 3rd normal form

I'm currently trouble determining if one of my schemas is in third normal form. I have a table with columns image_id (A), upload_time (B), uploader_id (C), and image_file (D). A is a key (unique ...
theasianpianist's user avatar
1 vote
1 answer
548 views

Best Practice to Normalize Unoptimized SKU Table with 27 Columns (20 Alike) Columns

What a learning experience this has been. Started out not knowing a damn about SQL normalization or database techniques in general. As time has passed I'm beginning to see the pitfalls of trying to ...
Brian Bruman's user avatar
2 votes
3 answers
194 views

Storing Procedure Fields That Were Used

I am creating a database for production work (specifically lab testing). Most Work is for production, therefore performed strictly according to the Procedure for that Product. By itself, this is easy ...
Steven's user avatar
  • 319
2 votes
0 answers
148 views

How to design normalized relations to store “global/generic” data?

Context I was designing a relational database model to store data about a company and its production facilities. I had a facility relation and many other relations referencing it, most of the time ...
soliz's user avatar
  • 293
0 votes
1 answer
243 views

Is this table in 1NF?

Here are the columns of an SQL Table: Course_Code Course_Name Tutor_ID Tutor_Name Student_No Student_Name DateOfBirth Gender LastAttDate By checking all the NF1 requirements below, I believe this ...
HOY's user avatar
  • 121
0 votes
2 answers
1k views

Database normalization, should I combine these two tables? [closed]

I am sort of new to database normalization and working with a database that I did not create. The database has a table for users, and a separate table for user addresses. Both tables use the user id ...
Caleb M's user avatar
2 votes
1 answer
247 views

Assessing statement about third normal form

Consider the following statements: A relation R, is in 3NF if every non-prime attribute of R, is fully functionally dependent on some key of R. State True or False. The answer given is true. But I ...
abnvanand's user avatar
  • 123
0 votes
0 answers
163 views

Normalization of database according to the given data

I'm creating new database based on existing database, performing some normalization. Here is the table containing multiple information, it's basically for booking trips etc I've divided all the info ...
M. Adeel Khalid's user avatar
3 votes
1 answer
665 views

In which normal form is the relation R?

Hello Community, To prepare for my exam I have completed many exercises. Most of them were solvable without any problems. But the following task I could not solve until now. It is: You are given the ...
VPOBS97's user avatar
  • 51
6 votes
2 answers
24k views

How does normalization fix the three types of update anomalies?

I have been reading 'Database Systems: A practical approach to design, implementation and management' by Connolly and Begg in order to understand database normalization (chapter 14). The three DB ...
the_butler's user avatar
2 votes
3 answers
2k views

How to create a normalized database to manage inventory for a small business? [closed]

I am writing a Java application to manage the inventory of a small furniture business. I know little about databases, I have a bit of experience with SQL queries and more experience with Java ...
badProgrammer's user avatar
1 vote
2 answers
2k views

Help with Normalisation

I'm having difficulty understanding how to go from 1NF to 3NF. All the tutorials I've looked at are very technical and I just need someone to tell me in plain English how to do it. I have this table ...
somers's user avatar
  • 21
0 votes
1 answer
156 views

Database design: How do i connect these two tables of my database in a normalisation way

I want to let a user create a food schedule(schema table) let him create his own food (userProduct) or choise from the supermarkets(supermarketproduct) the user should be able to make many food ...
user3244534's user avatar
0 votes
2 answers
476 views

How to design database tables using normalization in better manner in SQL?

I have designed my tables in below manner. Countries Table:- PkId --- + Country Name --- + StatusFlag 1 | India | L 2 | China | L 3 | Sri Lanka | L ...
RGS's user avatar
  • 135
2 votes
1 answer
367 views

BCNF decomposition excercise

I have a relation R(A,B,C,G,H,I) with the functional dependencies (FDs for brevity) F = {A→B; A→C; C,G→H; C,G→I; B→H}. I want to decompose it into BCNF. So, we have AG as candidate key. I consider ...
Zubin Kadva's user avatar
-3 votes
1 answer
524 views

Normalization to 3NF Homework Help [closed]

How would I normalize the following data to 3NF. Can someone tell me or set up an example of at least the 1NF and show the steps? Any FKs and PKs need to be used accordingly. A picture of the normal ...
topochica's user avatar
0 votes
0 answers
1k views

3NF Decomposition Check

I've solved, or I think I have, two book problems an 3NF, but I'm still a bit unsure about my understanding of it all and want to be sure I did it correctly. For the first one I have R(ABCD) and ...
windy401's user avatar
  • 169
3 votes
1 answer
279 views

Is a Self-defining Table of Domains Normalized?

I don't really know the official name of what I've made but it can't be the first time this has been made, so apologizes up front for not knowing every term. My question, is a table as outlined below ...
UpTide's user avatar
  • 271
1 vote
1 answer
142 views

Designing a database for a business context involving orders, payment methods and shipping addresses

Our group has been developing a webapp to take it live in the future. We got stuck at normalizing a few tables, as it could involve redundancy. We have some tables that I describe as follows: ...
negan's user avatar
  • 11
2 votes
1 answer
1k views

Transitive dependency with foreign keys

For an assignment, I had to design a database from a given problem (based on a fictional health service organisation with 3 medical centres). Three of the entities I had (among many others) were: ...
OKCFC's user avatar
  • 35
4 votes
2 answers
284 views

Is combining independent tables called normalisation?

So, at workplace, we currently store our audit logs in different tables, depending on what it is e.g. login/access info, configuration changes, etc. These are all independent data with no foreign ...
yihtserns's user avatar
  • 143
1 vote
1 answer
96 views

Why does key "concatenation" help to bring an unnormalized table to 1NF?

This question is about the proposed technique to bringing an unnormalized table to first normal form (1NF) that my textbook "A Guide To MySQL" presents. It gives an example of an unnormalized table ...
lonious's user avatar
  • 111
2 votes
0 answers
180 views

Understanding multivalued dependencies

This is my first time studying multivalued dependencies and there is a question that was posted by my lecturer as a class exercise. I have an answer, but I'm not 100% sure it was right. Please let me ...
Nick's user avatar
  • 21
1 vote
0 answers
169 views

Protocol for Converting External Unnormalized Data to Normalized Tables

I'm working through the fundamentals of bringing data from Excel (or any single unnormalized form table model) to SQL (MySQL or SQLite). These are the steps I've extrapolated from reading: Import ...
J.P.M.'s user avatar
  • 111
1 vote
1 answer
684 views

Best way to save mouse clicks in MySQL

I don't have any experience with large amount of data and I'm trying to figure out the best way to save the mouse clicks (navigation) of web visitors into a MySQL database. The DB will be used by ...
mattjon's user avatar
  • 13
3 votes
3 answers
323 views

How to normalize a table with common and non-common fields?

and thanks in advance. I am trying to normalize a table "People", where each entry (person) belong to one of many different categories (e.g. "lawyer", "client", "judge"). Some fields are common ...
Luca Nanetti's user avatar
1 vote
1 answer
4k views

Converting a relation into BCNF

I understand that to convert to BCNF, we need to take into account all violations and decompose as necessary with each FD. For example, if we had R(A,B,C,D) with FD's AB->C, B->D, C->A. We can ...
SS''s user avatar
  • 155
3 votes
0 answers
7k views

How do you perform the chase test?

Trying to follow the chase algorithm as I understand it, If two rows agree in the left side of a functional dependency (FD for brevity), make their right sides agree too. Always replace a ...
SS''s user avatar
  • 155
1 vote
1 answer
83 views

Design a db table where rows may have NULL in multiple columns

I am trying to design a database for tour packages. Tour packages contains the detailed itinerary. Tour package duration may be between 3 and 30 days. I need to add the description of each day. If I ...
Saket Anand's user avatar
2 votes
3 answers
949 views

A column value depends on the values of two other columns, of which exactly one is nullable

In the Person table, either the Citizen_IdentityID or the Foreigner_WorkPermitID will contain NULL marks. The PersonID_ID holds either the value of the Citizen_IdentityID or Foreigner_WorkPermitID (...
James's user avatar
  • 111
2 votes
0 answers
326 views

Sparse boolean tags: many columns or multiple tables?

I'm pretty new to database design. I'm storing records which are tagged with some (few) of a (large) number of possible tags (much like StackExchange questions). At the moment I have a single table ...
Samizdis's user avatar
  • 121
-1 votes
1 answer
646 views

Normalizing with "Relational Database Tools" [closed]

I am trying to use the Relational Database Tools to check if my schema is in Boyce-Codd Normal Form and to understand the relevant functional dependencies. However, I am having trouble "converting" ...
Dino Abraham's user avatar
2 votes
1 answer
74 views

Equivalent functional dependencies

I cannot understand why F1 is not equivalent to the other sets of dependencies below given the relation R(A,B,C): F1 = {A → B, B → C} F2 = {A → B, A → C} F3 = {A → B, AB → C} This is question no. 6 ...
 Enq19's user avatar
  • 29
-1 votes
1 answer
2k views

One to many relationship & 2nf

Does the table design below violate the 2nf normalization principle or any normalization rule ( ie. 1nf,3nf)? I have read that 2nf is violated only if there are non key attributes that are ...
 Enq19's user avatar
  • 29
3 votes
1 answer
808 views

Is this normalization done right?

In this normalization question When we convert it into 1NF according to the given site the answer is Is there a need to take out movie category? Won't it cause information lose? Also when we ...
melissa 's user avatar
2 votes
0 answers
167 views

Best Practice - Database design for 'conditional join' [duplicate]

I need to create a database to store Jobs. Each Job can have 1-* Step Each step is classified as one of either Type A, B or C. Each Type has specific details and other tables that join on them so ...
Intern87's user avatar
  • 121
0 votes
1 answer
96 views

How should I design my MySQL database?

I recently read about relational database normalization for the first time and I was wondering how best to design my database. If each entry has a url, some text, and a list of probabilities, what is ...
Matt G's user avatar
  • 103
3 votes
1 answer
8k views

Orders and Quotes Tables - Database Design

Below is the ERD of my current db schema for the orders part of an e-commerce site. The site is based on oscommerce, but has been modified, also I have removed quite a few of the fields from the ...
dading84's user avatar
  • 133
1 vote
1 answer
4k views

Normalization to Third Normal Form (3NF)

I have been given the example data and have been struggling to normalize to 3NF. I think the issue lies with the Tutor Name but this is my final chance at submitting so would like to get it right. ...
Toby Cook's user avatar
  • 119
0 votes
1 answer
1k views

How to decompose the relation R(a,b,c,d,e) whith following FDs into BCNF?

I have a FDs ABC->DE AB->D DE->ABCE E->C My trial : Step 1 : A+ = A B+ = B C+ = C D+ = D E+ = EC AB+ = ABD ABC+ = ABCDE DE+ = ABCDE From above we get ABC,DE are our candidate keys ...
Vindya Veer's user avatar
0 votes
1 answer
111 views

Normalization issue [closed]

I want to normalize a database to third normal form, but I do not know how to deal with start and end dates, knowing that some events can start and end the same day. Should I repeat the dates or allow ...
Salomon Dion's user avatar
-1 votes
2 answers
608 views

First Normal Form, Foreign Keys, and an Invoice entity type

So I was doing some research on DBA Stack Exchange for my Database Design university assignment, and I came across the question entitled "3rd Normal Form violation?", which is quite similar to my own ...
root's user avatar
  • 101
0 votes
1 answer
62 views

Should I combine these tables into one, or keep them seperate?

In a question/answer forum component I am writing as part of a site, I have two tables that theoretically look like this(that is, I want said data kept for each entity): THREAD POST ...
goldenarms's user avatar

1
3 4
5
6 7
14