These are my questions:1.Assuming that the data stored in skill_name in the user_skill table might be repeated for different users, what changes would I make to the database to normalize the skill_name and reduce repeated storage? what is the structure of the new table(s).

2.How could I Recreate the query that returned the 10 rows of data supplied. Speculate on tables that would be needed that are not shown here.

Given the following query, how could it be optimized? List all assumptions:

Well, since you're studying normalization, how would you get rid of the skill info in that first table?

noprobz09
—
2011-04-07T09:40:10Z —
#5

well, I found difficult about this problem... nosebleed...well, I need to think ahead about this...If you have suggestion, then please share ur ideas...at this time my mind got crazy thinking about this....THANK YOU IN ADVANCE

guido2004
—
2011-04-07T10:02:46Z —
#6

Ok, so you have two entities: USERS and SKILLSWhat relationship is there between the two entities?What info is there in the table about the entity SKILLS (USERS has already been normalized --> this is a hint for question number 2).

noprobz09
—
2011-04-07T10:07:04Z —
#7

once again thank you! HOPE I can solve this....

guido2004
—
2011-04-07T10:19:14Z —
#8

If you can't solve it on your own, post your anwser to the questions I asked you, and we'll continue from there. I won't just give you the solution though, it's your homework, you should do the thinking

noprobz09
—
2011-04-07T11:09:47Z —
#9

based on my understanding, the SKILLS will store the user id to determine the skills information of the user...hmmm just a little bit confusing...until now Im trying to figure it out what is the best explanation about this...

guido2004
—
2011-04-07T12:17:33Z —
#10

noprobz09 said:

the SKILLS will store the user id to determine the skills information of the user

No, that's a bit of information that will stay in the userskills table (which will contain all info about the relation between the USERS and the SKILLS)

noprobz09
—
2011-04-07T12:24:16Z —
#11

hmmm...okay I will try to study this better harder...thank you for the hints...KEEP IT UP!!! IDOL