Assume these are the values that exist for all time (e.g., the toys shown always

Question

Assume these are the values that exist for all time (e.g., the toys shown always cost the amount shown) and that boys with the same name are the same person. Is this relation in at least 1NF? Why or why not? What normal form is this relation currently in?

BOY GROUP AGE TOY CATEGORY PRICE Charlie 5 year olds 5 Basketball Sports 16.47 Jimmy 6 year olds 6 Hammer Tools 12.99 Robert 5 year olds 5 Soccer ball Sports 8.99 Jimmy 6 year olds 6 Basketball Sports 16.47 Jimmy 6 year olds 6 Wrench Tools 12.99 Charlie 5 year olds 5 Soccer ball Sports 8.99 Stewart 6 year olds 6 Oracle Computer Software 199.99

Explanation / Answer

the above database is ateast not in 1NF, because to satisfy 1NF the database should be atomic(non duplicates)

i.e unique values in at least sinle column , but all of the column values are repeated values.

the above database not normalized one, it should satisfy 1NF first to investiate for further normal forms

NOT IN NORMAL FORM

1NF:

2NF:

3NF

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---