Scenario 4-1: Looking at 1NF Your boss walks up to you and hands you a USB flash

Question

Scenario 4-1: Looking at 1NF
Your boss walks up to you and hands you a USB flash drive with the following database:
Model Specs
PC-1000 Dell OptiPC 200XD, 2.0 Ghz, 512mb RAM, 40 GB HD
PC-1250 Dell SlimPC 400LX, 2.25Ghz, 2gb RAM, 160GB HD
PC-1500 Dell OptiPC 300XD 1.5Ghz, 4gb RAM, 200 GN HD
Your boss asks you if anything is wrong with the database and, if so, what should be done with it. How should you respond?

Looking at 1NF – Explain your answer.

Now correct the table to be in 1NF and add it here.

Explanation / Answer

Looking at the 1nf this is not optimized. There is a problem with the last entry in the database which clubs spedd with PC.

In 1nf form each entry should be unique. To correct this the database should look like

PC-1000 Dell OptiPC 200XD, 2.0 Ghz, 512mb RAM, 40 GB HD
PC-1250 Dell SlimPC 400LX, 2.25Ghz, 2gb RAM, 160GB HD
PC-1500 Dell OptiPC 300XD, 1.5Ghz, 4gb RAM, 200 GN HD

The table should have four entries i.e name.speed,ram,hd and the above entries should go in the database for it to be in 1nf.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.