- Essays Database Online
- Argumentative Essay
- Comparative Essay
- 1200 Word Essay
- IB Extended Essay
- Scholarship Essay
- Discursive Essay
- Research Proposal
- Reaction Paper Writers
- Coursework Writing
- Book Report Writing
- Book Review Writing
- Term Paper Writing
- Write a Case Study
- Case Brief Writing
- Discussion Board Post
- Blog Article Writing
- Article Writing
- Article Review
- Literature Review
- Annotated Bibliography
- Article Critique
- Movie Critique
- Cover Letter Writing
- Motivation Letter Service
- Winning Synopsis
- Marketing Plan
- Business Plan Writing
- Winning White Paper
- Grant Proposal Writing
- Memo Essay Help
- Questions-Answers
- Professional Online Test
- Order Cool Posters Here
- PowerPoint Presentation
- Capstone Project Writing
- Dissertation Writing
- Dissertation Abstract
- Dissertation Literature
- Dissertation Conclusion
- Hypothesis
- Rewriting Services
- Editing Service
- Proofreading Service
- Revise a Paper
- Abstract Help
Normalize a database to 3NF
Essay specific features
Written by:
Dianne J
Date added:
April 16, 2014
Level:
Grade:
B
No of pages / words:
4 / 918
Was viewed:
1681 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 paperFull 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 accessOrder 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:
Related essays:
-
2 pages, 336 words
-
1 pages, 192 words
-
2 pages, 396 words
-
2 pages, 338 words
-
2 pages, 406 words
-
2 pages, 379 words
-
4 pages, 918 words