Question: Database Second Normal Form Scenario: PCC needs to track grades received by students taking courses. So far we have this 1NF relation, with sample data

Database

Second Normal Form

Scenario: PCC needs to track grades received by students taking courses. So far we have this 1NF relation, with sample data shown. Normalize to 2NF.

GRADES ( # GNumber, # CRN, Department, CourseNumber, CourseTitle, GradeOption, Grade, LastAttendDate, Credits )

GNumber

CRN

Dept

CourseNum

CourseTitle

GradeOpt

Grade

LastAttendDate

Credits

G03535555

20880

CIS

125D

Database Application Development

P/NP

P

4

G03780005

20880

CIS

125D

Database Application Development

A-F

F

5/01/2014

4

G03675983

21347

CIS

122

Software Design

A-F

B

4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Database Third Normal Form Scenario: A builder needs a database to keep track of contractors he hires for various projects. So far we have this 2NF relation, with sample data shown. Normalize to 3NF....

Q:

Objectives Identify key entities relationships: Determine how entities interact with each other. Incorporate inheritance: Utilize inheritance to represent common attributes and behaviors of entities....

Q:

The Industrial\\Organizational Program Handbook Florida Tech 2013-2014 Rev: 7/31/13 Welcome to the Industrial/Organizational Psychology program at Florida Tech! We are glad you have chosen Florida...

Q:

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Q:

STAT 200: Introduction to Statistics Final Examination, Spring 2016 OL4 Page 1 of 7 STAT 200 OL4/US2 Sections Final Exam Spring 2016 The final exam will be posted at 12:01 am on May 6, and it is due...

Q:

COURSE: MGMT 650 INSTRUCTIONS: Critical Review of Published Article [i] Mastery of statistics involves not only the ability to generate sound statistical results, but also the ability to critically...

Q:

Journal of Case Studies in Education Elementary teachers' experiences and perceptions of departmentalized instruction: A case study Alecia Strohl Valdosta State University Lorraine Schmertzing...

Q:

Journal of Case Studies in Education Elementary teachers' experiences and perceptions of departmentalized instruction: A case study Alecia Strohl Valdosta State University Lorraine Schmertzing...

Q:

The case assignment will be based on Case #13 in your textbooks (Thompson, Strickland, Gamble, Peteraf (23e) - Crafting and Executing Strategy: The Quest for Competitive Advantage Concepts and Cases,...

Q:

I need assistance with the case requirement questions, Part A and Part B (Exhibit 3) and Background, scope, findings and conclusions (exhibit 4) Assessing Information Technology General Control Risk:...

Q:

You are a developer and have the choice of Site 1 or Site 2 for a development. Both are zoned residential. Site 1 is 10,000sf, has an FAR of 12 and allows a max of 70% coverage. The price of site 1...

Q:

Why are the benefits of reducing inflation permanent and the costs temporary? Why are the costs of increasing inflation permanent and the benefits temporary? Use Phillips-curve diagrams in your answer

Q:

Need help with theseName HW # 9 Problem 3 The activity below is for calendar 2 0 1 4 . \ table [ [ The activity below is for calendar 2 0 1 4 . , Units sold at retail ] , [ Date , Activities,Units...

Q:

Please make it fast 3 8 1 .

Q:

Go to the website of the Federal Reserve Bank of St. Louis (http://www.stlouisfed.org) to find some information about the Fed. Find a map of the Federal Reserve districts. If you live in the United...

Q:

Suppose that the T-account for First National Bank is as follows: Assets Liabilities Reserves $100,000 Deposits $500,000 Loans 400,000 a. If the Fed requires banks to hold 5 percent of deposits as...

Q:

Imagine that you intend to buy a portfolio of ten stocks with some of your savings. Should the stocks be of companies in the same industry? Should the stocks be of companies located in the same...