assignment6

assignment6 - CSIS3310 - Normalization 1) For the example...

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

View Full Document Right Arrow Icon
CSIS3310 - Normalization 1) For the example below we have one big table. Put the table in 3 rd normal form. Eid = Employee id, Pid = project id, Mid = Manager id Functional Dependencies are: Eid -> ename eid -> pid pid -> mname Pid -> pname Pid -> mid Mid -> mname Eid Ename Pid Pname Mid Mname E01 John p1 Eco DBMS m1 Becky E02 Mary p2 Admin. m2 Joe E03 Mark p2 Admin m2 Joe E04 Travis p3 Educ. m1 Becky 1 – [eid/ename/pid] 2- [pid/mname/mid] 3- [mid/mname] 2) Normalization. Put the database in 3NF by breaking up this one big table into several tables Vid -> vtype own_id -> own_name Suspect_id -> Suspect_Name Vid -> own_id Vid vtype owner_id owner_name Suspect_id Suspect_Name 207 Escort 17 Jack 10 John 205 Quest 22 Mary 10 John 336 Neon 17 Jack 14 Joe 208 Camry 15 Sue 18 James 207 Escort 17 Jack 19 Henry 1- [vid/vtype/own_id] 2- [own_id/own_name] 3- [Suspect_id/Suspect_Name] 4- [vid/Suspect_id]
Background image of page 1

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

View Full DocumentRight Arrow Icon
For questions 3-8, are the following Tables in 3NF ? Cirlcle Yes or No. If not, explain why ?
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2008 for the course CSIS 3310 taught by Professor Guimares during the Spring '08 term at Kennesaw.

Page1 / 2

assignment6 - CSIS3310 - Normalization 1) For the example...

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

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