Iola1981
asked on
creating a 1NF, 2NF and 3NF
how do i create the 2NF and 3NF?
the un-normalised form i was givien to work with has repetitions in its colums...
Please help!
the un-normalised form i was givien to work with has repetitions in its colums...
Please help!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is this an academic assignment?
ASKER
yes it is @ lsmcONSULTING
Though a very broadly defined restriction, we cannot provide direct answers to academic questions.
Besides, what you posted is not really a single, direct question.
Your question is basically:
"How do I normalize a DB to 3NF?"
Without an intimate knowledge of the Data involved, this is near impossible to answer anyway.
As I stated, there are entire Books written on this subject.
But to zero in on your specific concern...
"the un-normalised form i was givien to work with has repetitions in its columns..."
Then you must create a new table in which these "repetitive" columns are instead, converted to a common "Field".
To quote an old Database design adag:
"Columns (fields) are expensive, ...Row (records) are cheap.
;-)
JeffCoachman
Besides, what you posted is not really a single, direct question.
Your question is basically:
"How do I normalize a DB to 3NF?"
Without an intimate knowledge of the Data involved, this is near impossible to answer anyway.
As I stated, there are entire Books written on this subject.
But to zero in on your specific concern...
"the un-normalised form i was givien to work with has repetitions in its columns..."
Then you must create a new table in which these "repetitive" columns are instead, converted to a common "Field".
To quote an old Database design adag:
"Columns (fields) are expensive, ...Row (records) are cheap.
;-)
JeffCoachman
ASKER
HI! boag2000, is an attachment of the DB im working with, the table called UNF STUDENT INFORMATION is the original table... where all the columns have repetitions. the UNF means Un-Normalized Form. BUT OF COURSE U KNEW THAT:)
LAB2-IOLA.accdb
LAB2-IOLA.accdb
Iola1981,
It is already stated that we cannot give direct answer to an assignment..
you already were given enough references to figure out what you need to do.
It is already stated that we cannot give direct answer to an assignment..
you already were given enough references to figure out what you need to do.
Iola1981,
Just so we are clear on a few things...
1. if this is an academic question, then my guess is that the topic of normalization is being covered in class.
In this case you should have some idea of how to go about this, correct? (class lessons, textbooks, questions in class?)
2. Besides, the file you posted already seems like it contains the normalized tables, they just need to be filled in then joined/linked.
(as far a the two posts above are concerned...)
3. While it is true that you did not ask for a direct answer, capricorn1 is also correct in that you have been given enough references/links to solve this.
For example, the same links helped me understand these topics when I first started out.
Did you look at all the links we posted?
Based on your investigation of these links, what information are you lacking?
JeffCoachman
Just so we are clear on a few things...
1. if this is an academic question, then my guess is that the topic of normalization is being covered in class.
In this case you should have some idea of how to go about this, correct? (class lessons, textbooks, questions in class?)
2. Besides, the file you posted already seems like it contains the normalized tables, they just need to be filled in then joined/linked.
(as far a the two posts above are concerned...)
3. While it is true that you did not ask for a direct answer, capricorn1 is also correct in that you have been given enough references/links to solve this.
For example, the same links helped me understand these topics when I first started out.
Did you look at all the links we posted?
Based on your investigation of these links, what information are you lacking?
JeffCoachman
ASKER
Hi! Jeff,
yes as u can see the attachment does show so
me form of eventual normalization, its just to join.....
I did figure it out, i had to create a unique auto no. in each table created, im at the stage of creating joins....
how do i go about creating a foreign key?
yes i know how to create a primary key.
i just want to know how am i going about it practically in MC Access....
thank you much!
yes as u can see the attachment does show so
me form of eventual normalization, its just to join.....
I did figure it out, i had to create a unique auto no. in each table created, im at the stage of creating joins....
how do i go about creating a foreign key?
yes i know how to create a primary key.
i just want to know how am i going about it practically in MC Access....
thank you much!
A Foreign key is basically a Primary key from another table.
But the info in the links we posted, cover this extensively...
Correct?
But the info in the links we posted, cover this extensively...
Correct?
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
<ex: You can be in 3nf unless all 2nf conditions are satisfied.>
Should read:
<ex: You *can't* be in 3nf unless all 2nf conditions are satisfied.>