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?
2. Comparing Clustered and Non-Clustered Indexes:
Your boss wants to speed things up on the company’s database server. Therefore, he is thinking of having you create a couple of indexes.
He asks you to explain the advantages and disadvantages of creating a clustered index versus a non-clustered index.
How should you respond?
Order an Essay Now & Get These Homework Help Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
