Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following Table Student ID SFName SLName Address City State ZipCode Phone CourseCode CName CGrade 1 Mary McCall 12345 West Road Houston TX 77077

Consider the following Table

Student ID

SFName

SLName

Address

City

State

ZipCode

Phone

CourseCode

CName

CGrade

1

Mary

McCall

12345 West Road

Houston

TX

77077

281-907-2345,

713-456-9089

MATH1313

Algebra I

A

2

Sam

Romney

78489 East Road

Dallas

TX

78909

281-999-7856

HIST1311

History I

B

3

Alex

Smith

23898 NorthEast Road

Houston

TX

77043

281-909-8877,

718-890-3256

COMP 3321

Databases

A

4

Jan

Adams

11467 West Road

Houston

TX

77077

713-879-3454

MATH 1314

Calculus I

B

5

Sarah

Pieters

1257 South Road

Dallas

TX

78901

281-909-1122

COMP 3321

Databases

C

6

Marco

DeLion

2323 SouthWest Road

Houston

TX

77082

713-906-4578

COMP 2231

Data Structures

A

7

Jane

Abrahams

10110 North Road

Austin

TX

76098

346-832-6745

HIST1311

History I

D

Student ( StudentID, SFName, SLNAME, Address, City, State, ZipCode, Phone, CourseCode, CName, CGrade)

  1. Is the table in 1NF? If not, how to put it in 1NF.

  2. Based on your answer in part 1 , Is the table in 2NF? If not, how to put it in 1NF.

  3. Based on your answer in part 2 , Is the table in 3NF? If not, how to put it in 3NF.

  4. Based on your answer in part 2 , Is the table in BCNF? If not, how to put it in BCNF.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administration The Complete Guide To Dba Practices And Procedures

Authors: Craig S. Mullins

2nd Edition

0321822943, 978-0321822949

More Books

Students also viewed these Databases questions