- A New Startup It Organization Is Entering The Growth Phase Last Month Their Organization Size Grew From Five Employees 1 (27.94 KiB) Viewed 25 times
A new, startup IT organization is entering the growth phase. Last month their organization size grew from five employees to more than twenty due to several new projects begun. The details of employees and their project assignments are shown in the figure. Based on the information provided,
1. Based on your answers in e), normalize the relations to 3NF. Provide justification/s or assumptions for each step in your normalization process. a. 2. Are the relations in your answer in f) in Boyce Codd Normal Form (BCNF)? 3. If not in BCNF, Normalize the relations in f) to BCNF. Provide justification/s or assumptions for each step in your normalization process. 4. List all primary keys 5. List all foreign keys
EMPLOYEE NAME PROIECT NUMBER 15 JOR CLASS PROKCI NAME bergen EMPLOYEE NIMEX TOS 10 105 106 102 June Embough John G. News Alck Johnson William Smidfield David H. Senice CHARGE HOUR $ 8450 $10.00 $105.00 $ 1535 $56.75 HOURS BILLED 23.5 19.4 35.7 126 238 18 Amber Wave 24.0 114 178 104 112 Annelise Jones Times Frame Annek Rams Darlene M. Smithson 453 $48.10 $ 18.36 $ 96.75 $ 4595 12.4 40 22 Rolling Tide 105 10 10 111 106 Alice K. Johnson Anne K. Ramoras Debet K. Joenbrood Geoff B. Wabash William Smithfied Eec Engineer Dutbase Designer Database Design Programme Systems Analyst Subtotal Applications Designer Gereal Support Systems Analyst DSS Analyst Sublotal Database Desigte Systems Analyst Applications Designer Clerical Support Programmer Subtotal Programmer Sisternis Analyst Database Designer Application Desige Suster Analys General Support OSS Aalst Subtotal $105.00 $ 96.75 $ 48,10 $26.87 5 35.5 567 48.4 23.5 27.0 12.8 TONAL CHARGE S 2011.00 $ 2,037.00 $ 3.748.50 $ 450,5 $ 2,302.65 $10.549.70 $ 1.183.25 $ 1.7 $ 3.1.14.70 $2.021.80 $ 7,171.47 56.793.50 $ 4,68270 $ 113516 $ 591.14 S457.00 $13,660.10 5.87945 5 4.431.15 $ 5.911.50 5 1.592.11 S 2,283.30 $ 559.98 $ 1.902.33 517,559.82 $48,941.09 25 Starligt 107 115 101 114 106 118 112 Maria D. Abro Travis 8. Bawang John G. News Annelise Jones Rap 8. Was sington fames. Frommer Darlene M.Smiec $35.75 5 96.75 $106.00 $ 48.10 $ 96.75 $ 1836 $ 45.95 246 458 563 33.1 23.6 305 41.4 Total Note: A indicates the project leader