Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here are the questions I neeed Help with . Im unsure how to do BCNF and wanted help with labeling my primary and foreign keys
Here are the questions I neeed Help with . Im unsure how to do BCNF and wanted help with labeling my primary and foreign keys in each table
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.82Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started