PROJECT NAME Evergreeen Evergreeen Evergreeen Evergreeen Evergreeen PROJECT NUMB

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.82

Explanation / 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

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.