Order
 

1(888) 302 2271 1(877) 741 7256

Essay

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:

1702 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 $10.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 300 characters

General issues of this essay:
DATABASE ANALYSIS AND DATABASE DESIGN PROJECT Online vs Campus Courses Pressure To Get Good Grades Pressure to get Good grades Statistical Grades Can we pass parenting courses classroom management plan for grades 7-12 HELPs USP of available courses wine courses An Essay For Humanities Courses: The Bible bad grades Homework Effort in Grades 5-9 physical education in elementry grades grades Normalize a database to 3NF
 

Related essays:

x
Services