Lecture04b_Normaliza - Chapter 5 Database Design 1 Some Normalization Examples Spring 2006 5 1 Dependencies Definitions x 5 Multivalued

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

View Full Document Right Arrow Icon
1 5 Chapter 5 Database Design 1: Some Normalization Examples Spring 2006
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 5 Dependencies: Definitions Multivalued Attributes (or repeating groups ): non- key attributes or groups of non-key attributes the values of which are not uniquely identified by (directly or indirectly) (not functionally dependent on) the value of the Primary Key (or its part). STUDENT Stud_ID Name Course_ID Units 101 Lennon MSI 250 3.00 101 Lennon MSI 415 3.00 125 Johnson MSI 331 3.00
Background image of page 2
3 5 Dependencies: Definitions Partial Dependency – when an non-key attribute is determined by a part, but not the whole, of a COMPOSITE primary key. CUSTOMER Cust_ID Name Order_ID 101 1234 101 156 125 Cisco 1250 Partial Dependency
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 5 Dependencies: Definitions Transitive Dependency – when a non- key attribute determines another non-key attribute. EMPLOYEE Emp_ID F_Name L_Name Dept_ID Dept_Name 111 Mary Jones 1 Acct 122 Sarah Smith 2 Mktg Transitive Dependency
Background image of page 4
5 5 Normal Forms: Review Unnormalized – There are multivalued attributes or repeating groups 1 NF – No multivalued attributes or repeating groups. 2 NF – 1 NF plus no partial dependencies 3 NF – 2 NF plus no transitive dependencies
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 5 Example 1: Determine NF ISBN Title ISBN Publisher Publisher Address BOOK ISBN Title Publisher Address All attributes are directly or indirectly determined by the primary key; therefore, the relation is at least in 1 NF
Background image of page 6
5 Example 1: Determine NF ISBN Title ISBN Publisher Publisher Address BOOK ISBN Title Publisher Address The relation is at least in 1NF. There is no COMPOSITE primary key, therefore there can’t be partial dependencies. Therefore, the relation is at
Background image of page 7

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

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

This note was uploaded on 07/10/2009 for the course COMPUTER 504 taught by Professor Drjan during the Spring '09 term at Arab Academy for Science, Technology & Maritime Transport.

Page1 / 27

Lecture04b_Normaliza - Chapter 5 Database Design 1 Some Normalization Examples Spring 2006 5 1 Dependencies Definitions x 5 Multivalued

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

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