Perform the normalization process to convert

Assignment Help Basic Computer Science
Reference no: EM13552505

Consider a school advising system in which a faculty advisor can advise many students, each of whom can register for one or many courses. The following is an example of an un-normalized STUDENT table for three students.

STUDENT
Student Number Student Name Total Credits GPA Advisor Number Advisor Name Course Number Course Description Course Credits Grade
1034 Linda 47 3.60 59 Smith CSC101 Computer Science I 4 B
MKT211 Marketing Management 3 A
ENG101 English Composition 3 B
CHM111 General Chemistry I 4 A
BUS101 Introduction to Business 2 A
3397 Sam 29 3.00 59 Smith ENG101 English Composition 3 A
MKT211 Marketing Management 3 B
CSC101 Computer Science I 4 B
4070 Kelly 14 3.20 23 Jones CSC101 Computer Science I 4 B
CHM111 General Chemistry I 4 A
ENG101 English Composition 3 B
BUS101 Introduction to Business 2 B

Perform the normalization process to convert the above un-normalized table to:
1. First normal form (1NF).
2. Second normal form (2NF).
3. Third normal form (3NF).
Please show all your work. Please show each step along the way and identify primary keys, if any, in each table in each step.

Reference no: EM13552505

Questions Cloud

Calculate the probability of an electron in the ground state : Calculate the probability of an electron in the ground state of the hydrogen atom being inside the region of the proton. (For purposes of calculation, use a proton radius r = 0.990e-15 m. Hint: Note that r
Magnitude of the tension in the string at this position : A 0.20-kg object attached to the end of a string swings in a vertical circle (radius = 80 cm). At the top of the circle the speed of the object is 4.5 m/s. What is the magnitude of the tension in the string at this position?
Floated in sea water of specific gravity : If a ship loaded when floating in fresh water to a weight of 50,000 metric tons were floated in sea water of specific gravity 1.03, how much additional weight could she take on board without being immersed to a greater extent than in the fresh water?
What is the lift force exerted by the air on the rotors : A 6500 kg helicopter accelerates upward at 0.59 m/s2 while lifting a 1210 kg car. What is the lift force exerted by the air on the rotors?
Perform the normalization process to convert : Perform the normalization process to convert
What would be velocity of shell fired from this loose cannon : A cannon of mass 5.17 x 10 3 kg is rigidly bolted to the earth so it can recoil only by a negligible amount. The cannon fires a 74.3-kg shell horizontally with an initial velocity of 542 m/s. Suppose the cannon is then unbolted from the earth, and..
Completing a system for meecham feeds : Systems analysis team is close to completing a system for Meecham Feeds
The wireless technology company : The Wireless Technology Company
Calculate velocity of the plane-relative to the ground : An airplane is heading due south at a speed of 580 km/h. If a wind begins blowing from the southwest at a speed of 90.0 km/h (average), calculate (a) the velocity (magnitude and direction) of the plane, relative to the ground, and (b) how far from it..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Calculate population increase

The output then would be that count. You will want to use 2 variables, one for the index of the for loop ( and the counter in the do loop) and the other variable to keep track of your "current" population.

  Create a 64mb encrypted file system

Write an instruction sheet for the user so that she can make the modi cations to her home machine so that she can access the le on the ash drive containing the encrypted le system.

  Write a class encapsulating the concept of a rational number

Write a class encapsulating the concept of a rational number, assuming a rational number has the following attributes: an integer representing the numerator of the rational number another integer representing the denominator of the rational number

  Browser immediately checks data is correct. true or false

When a user enters data into a form then submits the form (typically, by clicking the Submit button), the browser immediately checks that the data is correct. True or False

  .add a dropdown box/listbox and a checkbox

I need to create an HTML contact form that when submitted is processed by a JSP. a.The JSP displays the entered data along with the length of characters entered in each field.

  Computing characters are there in encyclopedia

The text of the Encyclopedia Britannica is about 44 million words. For a sample of about 2000 words, the average word length was 6.1 characters per word. Approximately how many characters are there in the encyclopedia?

  Modify the range accordingly or terminate the program

modify the range accordingly or terminate the program. The program must do up to 20 guesses

  What is the primary role of chief information officer

What is the primary role of the Chief Information Officer in organizations today? If you are able, please use your own organization in your response.

  Key factors limiting use of personalization

Two key factors limiting the use of personalization to more precisely target marketing efforts to individual customers are?

  Solve problem and categorize it by using big-theta notation

Sometimes slight change in problem can significantly modify form of its solution. For instance, determine simple algorithm for solving following problem and categorize it using big-theta notation.

  Display the users gross pay

Write a class that accepts a user's hourly rate of pay and the number of hours worked. Display the user's gross pay, the withholding tax ( 15% of the gross pay), and the net pay (gross pay - withholding). Save as Payroll.java

  Secure windows-unix-linux servers from known shortcoming

The CIO has asked you to explain why you suggest it is so significant to secure your Windows and Unix/Linux servers from known shortcomings/vulnerabilities.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd