Normalize a database to 3NF

Essay specific features

 

Issue:

Technology

 

Written by:

Dianne J

 

Date added:

April 16, 2014

 

Level:

 

Grade:

B

 

No of pages / words:

4 / 918

 

Was viewed:

1389 times

 

Rating of current essay:

 
Essay content:

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...
displayed 300 characters

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 $11.99/page

Order custom paper

Full essays database

You get access to all the essays and can view as many of them as you like for as little as $28.95/month

Buy database access

Order custom writing paper now!

  • 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!

Get a price guote

 
 

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...
displayed next 300 characters

General issues of this essay:

Related essays: