BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan Right Header

HOME BZU Mail Box Online Games Radio and TV Cricket All Albums
Go Back   BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan > Institute of Computing > Bachelor of Science in Information Technology > BsIT 4th Semester > Introduction to Database

Introduction to Database By Sir Yousaf


Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 13-06-2011, 01:03 PM
.BZU.'s Avatar


 
Join Date: Sep 2007
Location: near Govt College of Science Multan Pakistan
Posts: 9,693
Contact Number: Removed
Program / Discipline: BSIT
Class Roll Number: 07-15
.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute
lectures Chapter13- Normalization Transparencies by Carolyn E. Begg, Thomas Connolly

Chapter13- Normalization Transparencies by Carolyn E. Begg, Thomas Connolly


The purpose of normalization.
  • How normalization can be used when designing a relational database.
  • The potential problems associated with redundant data in base relations.
  • The concept of functional dependency, which describes the relationship between attributes.
  • The characteristics of functional dependencies used in normalization.
  • How to identify functional dependencies for a given relation.
  • How functional dependencies identify the primary key for a relation.
  • How to undertake the process of normalization.
  • How normalization uses functional dependencies to group attributes into relations that are in a known normal form.
  • How to identify the most commonly used normal forms, namely First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).
  • The problems associated with relations that break the rules of 1NF, 2NF, or 3NF.
  • How to represent attributes shown on a form as 3NF relations using normalization.


__________________
(¯`v´¯)
`*.¸.*`

¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.
Bzu Forum

Don't cry because it's over, smile because it happened
Reply With Quote
Reply

Tags
begg, carolyn, chapter13, connolly, normalization, thomas, transparencies


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 14 Advanced Normalization Transparencies by Carolyn E. Begg, Thomas Connolly .BZU. Introduction to Database 0 13-06-2011 01:05 PM
chapter 11 Entity-Relationship modeling Transparencies Carolyn E. Begg, Thomas Connolly .BZU. Introduction to Database 0 13-06-2011 01:01 PM
Chapter 3 The Relational Model Transparencies Carolyn E. Begg, Thomas Connolly .BZU. Introduction to Database 0 13-06-2011 12:05 PM
Chapter 2 Database Environment Transparencies by Conolly-Carolyn E. Begg, Thomas Connolly .BZU. Introduction to Database 0 13-06-2011 12:04 PM
Chapter 1 Introduction to Databases Transparencies Conolly -Carolyn E. Begg, Thomas Connolly .BZU. Introduction to Database 0 13-06-2011 12:01 PM

Best view in Firefox
Almuslimeen.info | BZU Multan | Dedicated server hosting
Note: All trademarks and copyrights held by respective owners. We will take action against any copyright violation if it is proved to us.

All times are GMT +5. The time now is 05:10 AM.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.