ITD320 UNIT 2 IP

ITD320 UNIT 2 IP - Relational Database Management System...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Relational Database Management System Implementation Grade Report for a University Grade Report for a University Dionne Jordan 02-21-10 American Intercontinental University
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Relational Database Management System Implementation Abstract This is a look at some following table that shows a grade report for a University. We will take a look at a dependence diagram, which will explain what normal form is this table and why. We will take a look at a decompose table into a set of 3NF tables and describe the process to decompose the table. Finally we will draw an ER diagram based on the decomposed tables in Chen Model .
Background image of page 2
Relational Database Management System Implementation Grade Report for a University It is important to understand the concept because it’s used to derive the set of functional dependencies for a given relation. The normalization process works one relation at a time, normalizing and identifying the dependencies on a relation (Rob, Coronel, 2009). The first process starts as we normalize by identifying the dependencies and progressively break up the table in to set of new tables based on the identified dependencies. A table is in first normal form and each non-key field is functionally dependent on the entire primary key. Look for values that occur multiple times in a non-key field. Which informs you that you have too many fields in a single table? In the example below, see all the repeating values in the name and Course_Title fields. This is an inefficient way to store and maintain data. In a well-designed database, the only data that is duplicated is in key fields used to connect tables. The presumption is that the data in key fields will rarely change (so it's alright if it's repeated) while the data in non-key fields may change frequently (so it's not alright to repeat it).
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 9

ITD320 UNIT 2 IP - Relational Database Management System...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online