Title: Normalize a database to 3NF

Essay Details

Subject: Technology
Author:
Date: June 19, 2012
Level: University
Grade: A
Length: 4 / 918
No of views: 0
Essay rating: good 0, average 0, bad 0 (total score: 0)

Essay text:

Notice that student 10 has 4 grades corresponding to 4 courses that she took. These are repeating groups. Therefore, the table is unnormalized, because it isn't in 1NF. So, to put it in 1NF, we must REMOVE the repeating groups. One way to do that is as follows: 10 Smith Mary 100 Jones Sally A CIT150 10 Smith Mary 100 Jones Sally B CIT160 10 Smith Mary 100 Jones Sally C CIT170 10 Smith Mary 100 Jones Sally A CIT180 20 Adams William 200 Johnson Charles A CIT150 20 Adams William 200 Johnson Charles B CIT160 30 Davis Robert 100 Jones Sally B CIT150 30 Davis Robert 100 Jones Sally A CIT160 It is now in 1NF...

Showed first 250 characters

Do you need an essay?

Here are the options you can choose from:

  • Order plagiarism free custom written essay
  • All essays are written from scratch by professional writers according to your instructions and delivered to your email on time
  • Prices start from $12.99/page

Do you need many essays?

FULL access to essays database

  • This option gives you the immediate access to all 184 988 essays
  • You get access to all the essays and can view as many of them as you like for as little as $28.95/month

Notice that student 10 has 4 grades corresponding to 4 courses that she took. These are repeating groups. Therefore, the table is unnormalized, because it isn't in 1NF. So, to put it in 1NF, we must REMOVE the repeating groups. One way to do that is as follows: 10 Smith Mary 100 Jones Sally A CIT150 10 Smith Mary 100 Jones Sally B CIT160 10 Smith Mary 100 Jones Sally C CIT170 10 Smith Mary 100 Jones Sally A CIT180 20 Adams William 200 Johnson Charles A CIT150 20 Adams William 200 Johnson Charles B CIT160 30 Davis Robert 100 Jones Sally B CIT150 30 Davis Robert 100 Jones Sally A CIT160 It is now in 1NF...

Showed next 250 characters

If you cannot find any suitable paper on our site, which happens very rarely, you can always order custom written paper which will be written from scratch by our professional writers and deliver to you on requested time.
  • Your research paper is written by certified writers
  • Your requirements and targets are always met
  • You are able to control the progress of your writing assignment
  • You get a chance to become an excellent student!

Total price: $10.00

 

Common topics in this essay:

Comments

Similar Essays:

The level of difficult

1 pages / 233 words

Wald Press

3 pages / 659 words

Ethics In Grade Inflation For Students

1 pages / 192 words

Case study

1 pages / 236 words

math lesson plan 3rd grade

3 pages / 697 words

grade inflation

1 pages / 268 words

Normalize a database to 3NF

4 pages / 918 words

Your education is your way to success!

Celebrate National Learning and
Development Month with Us!

Catch your 18% Discount
and Become a Successful Student!
*Limited Time Only