05_Task Performance Normalization STI College (multiple campuses) BSIT 9595

IT1924

Task
Performance
Normalization
Objective:
At the end of the exercise, the students should be able to:
 Transform a table into higher normal forms.
Software Requirements:

 Microsoft SQL Server Management Studio 18.0 or higher
 Microsoft SQL Server Express 2017
Problem:
Transform the table into 1NF, 2NF, and 3NF. Create a database diagram afterward.
year term program subject student_number firstname lastname
2016-2017 2nd BSIT Advanced Database 035-20130-0205 Mairo Eli
Systems
2016-2017 2nd BSIT Management Information 035-20130-0205 Mairo Eli
Systems
2016-2017 2nd BSIT Systems Analysis and 035-20130-0205 Mairo Eli
Design


1st Normalization
STUDENT
Student_Number FirstName LastName Program Term Year
035-20130-0205 Mairo Eli BSIT 2nd 2016-2017


SUBJECTS
Subject Program
Advanced Database Systems BSIT
Management Information Systems BSIT
System Analysis and Design BSIT


2nd Normalization
STUDENTS
Student_Number FirstName LastName Term Year
035-20130-0205 Mairo Eli 2nd 2016-2017

SUBJECTS PROGRAMS
Advanced Database Systems BSIT
Management Information Systems
System Analysis and Design
Term
2nd


This study source was downloaded by 100000850872992 from CourseHero.com on 04-20-2023 09:47:45 GMT -05:00


https://www.coursehero.com/file/135880356/05-Task-Performance-1docx/