Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency.
1
vote
2answers
26 views
One-to-one relationship or NULL field for optional column?
I am working on a database design and would like to store user addresses. Consider the following: Many times when you register your address with a website there is 'address line 1' and 'address line ...
0
votes
1answer
36 views
Normalisation from 1nf to 2nf
I have converted the following 1NF table to 2NF as follows. Still having doubt if I have done it right and also unable to determine the transitive dependency.
I believe - cdName is transitively ...
0
votes
1answer
37 views
Normalization: is it done good?
I am creating game review database. I am new at this, but I am trying my best. Little bit about database: The system is simple, user fill out php form, where he is insert his name, email when choose ...
0
votes
1answer
51 views
Is this database normalized? [on hold]
I am making game review system database. I am new at this, so I am a bit confused is it normalized or not.I am also missing relations, so I would really appreciate for help. Thanks!
My tables:
0
votes
2answers
52 views
Am I normalizing correctly?
I just wanted to see if Im normalizing my table correctly based on the following FD
Here are the tables I came up with after 2NF and 3NF.
Table 1 - (__Client ID__,CLient Name, VetID)
Table 2 - ...
-1
votes
0answers
21 views
4NF/5NF database normalization
Hello i understand the way that normalization takes place in 4NF and 5NF when we have a table that includes a ternary relationship.But what if the table includes a quaternary (and over) relationship?
...
1
vote
2answers
36 views
Normalization of a table (BCNF)
I'm trying to understand how to normalize a database, and one of the exercise given by our teacher was to normalize in BCNF this table:
...
0
votes
1answer
50 views
Third Normal Form
I asked to create a 3NF of a Library System with a min of 5 tables. And with my understanding with normalization, I made this. I just want to confirm if my works is already normalized in 3NF? Or what ...
0
votes
0answers
26 views
Entity Framework with sparse tables
My data table is sparse, therefore the data is stored as such:
RowId | Field | Value
1 ,"Field1", 1.00
1 ,"Field2", 2.00
1 ,"Field4", 4.00
2 ,"Field1", 1.00
2 ...
0
votes
0answers
56 views
How to convert functional dependencies into Normal Forms?
I have a attribute set as - PQRSTUVW
which has the following set of functional dependencies -
P -> T
PS -> QT
PR -> T
T -> Q
QV -> U
QT -> S
QSW -> T
U -> P
S -> W
RS ...
0
votes
1answer
33 views
how to break mapping table in order to faster query result and database size
I have employee number table and one group mapping table.
desc employee_tab;
----------------
empno int;
emp_name varchar(50);
desc group_mapping_tab;
------------------------
empno int;
group_no ...
-2
votes
0answers
82 views
oracle normalisation from 1NF to 2NF and 3NF
I have to normalise from UNF to 1NF, 2NF then to 3NF. I think I managed to do from UNF to 1NF but I don't know how to do the 2NF and 3NF, I apply the rules but I am not sure which foreign key should ...
0
votes
1answer
38 views
Identifying normalisation form
Here's the relational schemas i have:
OfficeCustomer(office, customer, employee)
office, customer -> employee
employee -> office
This is my current analysis,
Minimal super key is (office, ...
2
votes
1answer
93 views
SQL: What is a value?
The Question
One thing that I am confused about is the technical definition of possibly the most basic component of a database: a single value.
Some Examples
I understand and follow (at a minimum) ...
3
votes
5answers
79 views
Is it better to have int joins instead of string columns?
Let's say I have a User which has a status and the user's status can be 'active', 'suspended' or 'inactive'.
Now, when creating the database, I was wondering... would it be better to have a column ...
0
votes
1answer
43 views
Database structure for location
I have 3 tables -
Countries
CountryId | Name
States
StateId | Name | CountryId
Cities
CityId | Name | StateId
These 3 fields are referenced in user table (and some other tables).
Users
UserId | ...
-1
votes
1answer
38 views
Can Someone Normalize this table?
I have this table to normalize for a uni project, now every time I think it should just
be two tables, I then think no it should be three... I am going to throw this out to one of you guys superior ...
0
votes
1answer
59 views
normalization 1NF or 3NF
though after reading many articles online and I know this question have been asked quite a number of time. I'm still having problem identifying if a relation table is in 1NF, 2NF or 3NF
I've found ...
-2
votes
1answer
58 views
How to solve this perticular query in MySql?
Problem Statement To Solve:
You need to store employee information (name, age, gender and address) and Project information (name, client name, client city) in database. Employees can work on ...
4
votes
1answer
54 views
SQL-Show that R is not in Boyce-Codd Normal Form
R = (J,K,L,M,N) with a set of functional dependencies {J->KL,LM->N,K->M,N->J}.
I understand the definition of BCNF. I believe that there exists no trivial functional dependencies and ...
1
vote
1answer
47 views
Customer/Company Address/Phone Numbers
I have a database design requirement that is getting increasingly complex for me to figure the best way of approaching.
Currently, I have "contacts", and I have "companies". A company can have ...
0
votes
2answers
67 views
Android - Complex Databases and Content Providers
I am designing an Android app with a fairly complex (normalized) database structure. My question is, what is the best design pattern for working with my data?
The database has a table Books, a table ...
android
0
votes
0answers
26 views
Dependency preserving
So I am looking over my database notes and material trying to refresh myself on the general concepts and terminology for upcoming interviews.I have gotten stuck at dependency however and lossless-join ...
0
votes
1answer
36 views
has_one and belongs_to together
At first glance, this may look like a simple question. You may even suspect it's been answered before, but not quite. I've done a good deal of scouring the web (including stack overflow) and have been ...
1
vote
3answers
42 views
Database Schema for an almost tree
I have the following structure:
Block A
Foo 1
Bar 1
Bar 2
Foo 2
Bar 1
Bar 3
Bar 4
Block B
Foo 3
Every Foo belongs to exactly on Block.
Every Bar belongs to exactly on ...
0
votes
2answers
61 views
Tool To Normalize A Database? [closed]
I have a huge table with a lot of records that I want to split into smaller tables to make it normalized. I already have the model for the normalized table. Now, I want to take all the records from ...
0
votes
0answers
19 views
CakePHP Database Normalization Amount [duplicate]
I am debating over the amount of normalization to use in my tables.
For example, if I have a database table called players with columns name, hometown, etc...
Additional columns are options bats ...
0
votes
1answer
36 views
CakePHP Normalization
I am debating over the amount of normalization to use in my tables.
For example, if I have a database table called players with columns such as name, hometown, etc...
Other columns are options ...
0
votes
1answer
27 views
Efficient read and write in mysql database
I have a mysql table which stores a set of queries (strings).
The table with its contents looks like this :-
query_id queryString
1. Query 1
2. Query 2
3. Query 3
...
0
votes
1answer
24 views
questionaire time spend mysql
Say I have a table where I would store questions.
Now I would like to track how much time people on average spend per question and how many came up with the right solution.
Would I store the time ...
0
votes
0answers
32 views
Database Normilzation to 3NF
I am trying to complete normalization for the following ERD
![1]: http://i42.tinypic.com/fng2a9.jpg
I have completed 1NF but, I am stuck on normalizing it any further. Are the structures below not ...
2
votes
1answer
101 views
Can I Have FK in 2NF and 3NF in Relational Schema?
So basically I'm Normalizing an Invoice, is it wrong to include FK *INV_NUM* in all 2NF RELATIONAL SCHEMA'S. This is what I already have.
the * Shows PK
1NF (*INV_NUM, INV_DATE, C_ID, ...
0
votes
1answer
60 views
Redundant data in sql server?
Let's say Microsoft has many CDs and it needs to track (including history) the location of each CD .
So there will probably be a CDs table like :
CD_ID | title | ...
_________________________
...
2
votes
0answers
45 views
BCNF — Impossible to achieve?
Let R be a relation with Schema R(X,Y,Z)
and it's FDs are
{XY -> Z, Z -> Y}
I am not able to decompose it into BCNF .
Because r1(Z,Y), r2(Z,X) will lose FD XY -> Z and
R(X,Y,Z) itself is not ...
1
vote
2answers
82 views
Is there a transitive dependency in the following functional dependencies
Let's say we have the following functional dependencies:
A->B, B->C, C->B, and A->C
Where the functional dependency A->C is explicit, i.e. you don't have to go through B to get to C ...
3
votes
2answers
109 views
Third Normal Form — transitive dependence between two foreign keys?
I am creating a database containing books that I own and have read. I want to track both the book (or "title") that I own and read, and the edition (or "physical bound paper") of that book that I own ...
3
votes
4answers
94 views
Normalizing a database column
The objective here is to be able to query a database providing it with a Journey, based on the Journey the database will return all of the Stop Codes that run through this journey.
So for example I ...
0
votes
1answer
136 views
RDBMS - Normalization
I've been asked a question in an online assessment test, the question goes like this..
"In normalization, the tables are linked using?"
a) Relationships
b) Records
c) Triggers
d) Transactions
I ...
0
votes
0answers
56 views
Please help me with Normalization 1NF, 2NF and 3NF
Contract
Conrtact Id -- ContractServ Id -- ServType-- Qty -- Staff Skills
1 80003 Cleaning 4 Clearners
2 80004 Cleaning 5 Clearners
2 80005 ...
0
votes
1answer
23 views
1
vote
0answers
95 views
BCNF vs 3NF technical questions
There are many related questions on SO, but none that I can find that answer this question:
Is it possible to have a 3NF relation that can be lossless-join
decomposed into BCNF relations while ...
1
vote
1answer
129 views
Correctly place table into 4NF?
Question:
Place the PERSON relation into 4NF where
PERSON (Name, Sibling, Shoe_Size)
Assume the following functional dependencies exist:
Name -->--> Sibling
Name --> Shoe_Size
..................
...
0
votes
1answer
91 views
Identifying possible multivalued dependencies in Tables
Background on the Data Tables:
The Elliot Bay Sports Club owns and operates three sports club facilities in Houston, Texas. Each facility has a large selection of modern exercise equipment, weight ...
1
vote
3answers
171 views
Why should zipcode values not be placed in Boyce Codd Normal Form?
Can someone explain to me why it is that zipcodes should not be placed in Boyce Codd Normal Form? Is there really any more to it other than that zipcodes are unlikely to change in any foreseeable ...
0
votes
2answers
35 views
Confused about the thrid normal form
I was studying normalization and trying to implement in on some examples,was doing the third normal form, and from what I understand is:"A relation is in the 3NF if its in 2NF and doesn't have any ...
1
vote
2answers
618 views
MySQL: stored procedure to split column(with delimiters) and insert into new table
There is a un normalized table in my database with name details structure and sample data as below(apologies for image, just thought it would be more comprehensible):
My challenge is to split ...
1
vote
2answers
66 views
How to auto insert values in dependency table?
I have created three tables. One is named as User and second is Folder and third one is User Folder Rights Table . I have inserted values in table by using Query
Insert into Users values ...
1
vote
1answer
48 views
MySQL Database - Table to share contents between users
I just wanted to know which one you think it's the best solution to this situation.
I've got an application in which items can be shared. These items, however, can be of different types: photos, ...
1
vote
2answers
83 views
3rd Normalization Form --
There are two tables in my database one is named as folder and second is User. Now user has few rights to these folders that which folder will be visible to user and which will not visible to him. By ...
1
vote
2answers
54 views
Full functional dependecies
Alright I can't seem to wrap my head around the subject normalization.
I have this table
Now I need to find the full functional dependencies.
FilmID, Actor -> Title, Year, Director
Publisher ...
