Abcavac

Data Normalization (2) IS 240 Database Lecture #5 2010-02-08 M. E. Kabay, PhD, CISSP-ISSMP Assoc. Prof. Information self-assertion School of Business & Management, Norwich University mailto:mkabay@norwich.edu V: 802.479.7937 1 right of outset publication © 2010 Jerry Post. all in all rights reserved. fathert Panic! ? We are not acting to converse 66 slides in one session ? Much of straight outs material leave alone serve as approval and review for your studies ? Opportunity to discuss principles and illustrate them with specific cases 2 Copyright © 2010 Jerry Post. in all rights reserved. Overview of Todays build ? Continue discussion of normalization ? Work on examples to corroborateher ? consequential to vanquish involve in class discussion ? fag end absorb / merge concepts still by using them ? D not t t memorize without understanding Do t try to i ith t d t di ?Waste of your time ? Do the homework exercises seriously ?They will ensure su ccess ?Students from previous IS240 classes take up reported well-behaved experiences in genuine jobs praised for understanding principles that help design redeeming(prenominal) databases 3 Copyright © 2010 Jerry Post. entirely rights reserved. Boyce-Codd Normal Form (BCNF) ? concealed dependency Employee-Specialty(E#, Specialty, Manager) ? Example: ? Employee-Specialty(E#, Specialty, Manager) ? Is in 3NF now. Employee(E#, Manager) ? Business rules.

Manager(Manager, Specialty) ? Employee may have many specialties. ? E h specialty has many motorcoachs. apiece i lt h ? Each film director has only one specialty. ? Employee has only one manager for each specialty. ? enigma is hidden relationship between manager and spe! cialty. Employee(E#, Specialty, Manager) ? Need state table for manager. ? But then we fag outt need to repeat specialty. ? In real life, probably withdraw the duplication (specialty listed in both tables). Manager(Manager, Specialty) 4 Copyright © 2010 Jerry Post. All rights reserved. Fourth Normal Form (Keys) EmployeeTasks(EID, Specialty, ToolID) ? Technically, if you keyed every...If you want to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: How it works.