PROJECT NAME Evergreeen Evergreeen Evergreeen Evergreeen Evergreeen PROJECT NUMB
ID: 3713807 • Letter: P
Question
PROJECT NAME Evergreeen Evergreeen Evergreeen Evergreeen Evergreeen PROJECT NUMBER CHARGE/HOUR EMPLOYEE NUMBER 103 101 EMPLOYEE NAME June E. Arbough Jhon G. News Alice K. Jhonson William Smithfield David H. Senior JOB CLASS Elec. Engineer Database Designer Database Designer Programmer System Analyst Subtotal Application Designer General Support System Analyst DSS Analyst Subtotal Database Designer System Analyst Application Designer Clerical Support Programmer Subtotal Programmer System Analyst Database Designer Application Designer System Analyst General Support DSS Analyst Subtotal HOURS BILLED TOTAL CHARGE $105.00 $105.00 $2011.10 $2037.00 $3748.50 15 15 75 2302.65 $10549.70 $1183.26 $831.71 $3134.70 $2021.80 $7171.47 $6791.50 $4672.80 $1135.16 $591.14 15 102 Amber Wave Amber Wave Amber Wave Amber Wave 114 Annelise Jones James Frommer Anne K Ramoras* Darlene M. Smithsom 18 18 18.36 18 $105.00 Rolling Tide Rolling Tide Rolling Tide Rolling Tide Rolling Tide Alice K. Jhomson Anne K Ramoras Delbert K. Joenbrood Geof B. Wabash William Smithfield $96.87 103 $13,660.10 $879.45 107 Maria D. Alonza Travis B Dawangi hon G News Annelise Jones Ralph B Washington James J. Frommer Darlene M Smithson Starfight Starfight Starfight 25 $105.00 5911.50 1592.11 101 25 114 Starfight 25 $18.36 $559.98 Starfight 41.4 17,559.82Explanation / Answer
h . BCNF
Functional Dependencies :
ProjectNumber -> ProjectName
EmployeeNumber -> EmployeeName,JobClass
JobClass -> Charge/Hour
ProjectNumber,EmployeeName -> HoursBilled
So tables in BCNF :
PROJECT(ProjectNumber , ProjectName)
EMPLOYEE(EmployeeNumber , EmployeeName,JobClass)
JOB(JobClass , Charge/Hour)
BILL(ProjectNumber,EmployeeName , HoursBilled)
underlined are primary keys and italicised are foreign keys.
Also TotalCharge(Charge/Hour * HoursBilled) and subTotal are calculated columns so no need to add them in tables
i. Primary Keys ----- ProjectNumber,EmployeeNumber,JobClass,EmployeeName
ii. Foreign Keys ----- ProjectNumber,JobClass,?EmployeeName
Do ask if any doubt. Please upvote.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.