Class03_ch03_Kroenke10_Spring_2009

Class03_ch03_Kroenke10_Spring_2009 - Class 3 Chapter 3 The...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Class 3 Chapter 3 The Relational Model and Normalization BCIS 4620 Database Processing Spring 2009 Jack D. Becker Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/2 Copyright 2006 Class 3 Overview Announcements CISO Lab Times Kroenke Chapter 3 & 4 (next time) Normalization of Databases with SQL Homework #2 Review Building a DB2/SQL Database Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/3 Copyright 2006 Hints & Tips NX SQL Importing & Exporting Statements SQL Wizard Data/Table Exports & Imports More on Location Settings (slides from last time) SQL Wizard Environment Tips Innovation Points Moving columns in a table up or down (a.k.a., left or right) Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/4 Copyright 2006 Homework #2 EMP/DEPT Database Example http://www.coba.unt.edu/bcis/faculty/becker/BCIS4620/bcis4620.htm#Assignments Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/5 Copyright 2006 Exported Table DEPT2 SQL Code File May now be used to Create & Load the table run batch Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/6 Copyright 2006 Outline Relations Types of Keys Functional Dependencies Normalization & Normal Forms [NF] 1 st , 2 nd , 3 rd , BCNF, 4 th NF 5 th NF or Domain Key Normal Form Types of Relationships De-normalization Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/7 Copyright 2006 Important Relational Model Terms [Figure 3.3] Relation Functional dependency Determinant Candidate Key Composite Key Primary Key Surrogate Key Foreign Key Referential integrity constraint Normal form Multi-valued dependency Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/8 Copyright 2006 Relations Relational DBMS products store data in the form of relations, a special type of table A relation is a two-dimensional table that has the following characteristics [Figure 3.4] Rows contain data about an entity Columns contain data about attributes of the entity Cells of the table hold a single value All entries in a column are of the same kind (domains alike) Each column has a unique name (when qualified: DEPT.DeptID) The order of the columns is unimportant The order of the rows is unimportant No two rows may be identical Although not all tables are relations, the terms table and relation are normally used interchangeably Table/row/column = file/record/field = relation/tuple/attribute Database Processing: Fundamentals, Design and Implementation, 10/e by David M. Kroenke Chapter 3/9 Copyright 2006 Alternate Terminology...
View Full Document

Page1 / 60

Class03_ch03_Kroenke10_Spring_2009 - Class 3 Chapter 3 The...

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

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