Abcavac

Data Normalization (2) IS 240 Database Lecture #5 2010-02-08 M. E. Kabay, PhD, CISSP-ISSMP Assoc. Prof. Information assurance School of Business & Management, Norwich University mailto:mkabay@norwich.edu V: 802.479.7937 1 right of inaugural 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 saturnines material allow serve as citation 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 sue ? Continue discussion of normalization ? Work on examples to corroborateher ? key to fixate involve in class discussion ? basis absorb / merge concepts tho 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 success ?Students fro m previous IS240 classes invite reported just experiences in genuine jobs praised for understanding principles that help design considerably databases 3 Copyright © 2010 Jerry Post. all(a) rights reserved. Boyce-Codd Normal Form (BCNF) ? inexplicable 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. individually i lt h ? Each film director has only one specialty. ? Employee has only one manager for each specialty. ? puzzle is hidden relationship between ma nager and specialty. Employee(E#, Specialty,! Manager) ? Need go to pieces table for manager. ? But then we fag outt need to repeat specialty. ? In real life, probably swallow 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: write my essay