Class Assignment 2 - Perform Database Normalization

pdf

School

Florida Atlantic University *

*We aren’t endorsed by this school

Course

6217

Subject

Electrical Engineering

Date

Apr 3, 2024

Type

pdf

Pages

1

Uploaded by AdmiralArtFalcon29

Report
1 ISM 6217 Database Management Systems Class Assignment 2 5 points Task: Perform Database Normalization 1. Using Excel - Normalize the following Table using the rules 1NF, 2NF, 3NF. 2. Highlight (in any color) the Primary Key, Composite key, Foreign Key(s) of the Table(s). Student Info Student ID Name Email Course No. GradePoints Instructor Last Name Student Residing Campus Course Location 100111 John Black john@usna.edu ISM204, SI204, IT221 2,3,3 Sharma, Sharma, Sweet Davie Boca Raton 92244 Matthew Smith smith@usna.edu SM223, EE301 4,4 Younf, Tyler Boca Raton Jupiter 113221 Goo Black black@usna.edu SI204 3 Sharma Jupiter Jupiter 90110 Thomas Johnson Johnson@usna.edu ISM204, SI204, IT221 4,2,3 Sharma, Sharma, Sweet Boca Raton Boca Raton 4. Upload the completed Excel document on Canvas. Rubrics: Normalization procedure - (0NF, 1NF, 2NF, 3NF form) 3 points Primary Key, Composite Key, Foreign Keys identification 2 points
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help