question

ssharma14 avatar image
ssharma14 asked

Normalize the table to 3NF.

Need help to Normalize the given table and identify primary and foreign keys relationship. Columns --- ROOM, TIME, CourseNo., CourseName, Tutor ROW1 --- 112, 9:00, 1264, French1, JL ROW2 --- NULL , 8:00, 1264, French2, - ROW3 --- 138, 9:00, 1266, French3, FL ROW4 --- 139, 7:00, 1562, Spanish1, KL ROW5 --- 139, 8:00, 1563, Spanish2, ML ROW6 --- 114, 7:00, 1564, Spanish3, SL ROW7 --- 138, 8:00, 1264, French2, PS ROW8 --- 112, 7:00, 1264, French1, JL Thanks - I believe its already in 1NF.
normalization
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

which column(s) do you consider to be the key?
0 Likes 0 ·
I am not sure about what are you askin me for ?
0 Likes 0 ·
Is this homework or a bussiness assignment? (I'd help you either way, but with different approaches).
0 Likes 0 ·
If you don't understand the question about the key, how can you understand the concept of 3NF?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.