Scribd
Upload
34 views

Computer Programming and DBMS

This document discusses database normalization and outlines an activity involving normalizing a student grade report table. It explains that normalization is used to eliminate redundant data, reduce complexity, and ensure relationships between tables. The document lists the first four normal forms - 1NF, 2NF, 3NF, and BCNF - and provides a student grade report table to normalize with instructions to construct an entity-relationship diagram.

Uploaded by

Rome Empe Bal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
34 views

Computer Programming and DBMS

This document discusses database normalization and outlines an activity involving normalizing a student grade report table. It explains that normalization is used to eliminate redundant data, reduce complexity, and ensure relationships between tables. The document lists the first four normal forms - 1NF, 2NF, 3NF, and BCNF - and provides a student grade report table to normalize with instructions to construct an entity-relationship diagram.

Uploaded by

Rome Empe Bal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Computer Programming and DBMS

Finals Activities

Instructor: Romeo Balcita Submission: June 18, 2020

Database Normalization is used for following Purpose:


 To Eliminate the redundant or useless data.
 To Reduce the complexity of the data.
 To Ensure the relationship between tables as well as
data in the tables.
 To Ensure data dependencies and data is logically
stored.

Normal Forms

There are six normal forms, but we will only look at


the first four, which are:

 First normal form (1NF)


 Second normal form (2NF)
 Third normal form (3NF)
 Boyce-Codd normal form (BCNF)

BCNF is rarely used.

We will use the Student_Grade_Report below, from a


School database

Given:
Student_Grade_Report (StudentNo, StudentName, Major,
CourseNo, CourseName, InstructorNo, InstructorName,
InstructorLocation, Grade)

Activity:
1. Apply Database Normalization
2. Construct the Entity- Relationship Diagram of the
given above.

You might also like