Question: should normalize all tables to be in 3NF or BCNF. Then you should create dummy data, test and validate your application and try to optimize

 should normalize all tables to be in 3NF or BCNF. Then

you should create dummy data, test and validate your application and try

to optimize it. For assignment 6 you should only Functional Dependencies: You

should show all the functional dependencies in all the tables in your

database. Organizations \{organization_id org_date_created,org_name, org_address, org_desc, org_netWorth, payment_cycle\}- Employee { employee id

should normalize all tables to be in 3NF or BCNF. Then you should create dummy data, test and validate your application and try to optimize it. For assignment 6 you should only Functional Dependencies: You should show all the functional dependencies in all the tables in your database. Organizations \{organization_id org_date_created,org_name, org_address, org_desc, org_netWorth, payment_cycle\}- Employee { employee id }{ emp_date_created, emp_firstName, emp_lastName, emp_address, emp_phone, emp_username, emp_email, emp_password, emp_type, emp_hourlyWage, emp_salary, organization_id, department_id, bank_id\} Performance { performance _id }{ perf_date_created, perf_notes, date_Achieved, KPI_Achieved, appraiser_id, appraised_id, project_id Project { project_id }{ prj_date_created, prj_name, prj_desc, KPI_goal } Department { Department_id }{ dep_date_created, dept_name, dept_desc, dept_budget, organization_id, manager_id } Bank {bankid}{ bnk_date_created, institute_number, transit_number, account_number } Transactions { transaction_id }{ transaction_date, wage, El_pay, vacation_pay, bonus_pay, overtime_pay, net_pay, employee_id, bank_id should normalize all tables to be in 3NF or BCNF. Then you should create dummy data, test and validate your application and try to optimize it. For assignment 6 you should only Functional Dependencies: You should show all the functional dependencies in all the tables in your database. Organizations \{organization_id org_date_created,org_name, org_address, org_desc, org_netWorth, payment_cycle\}- Employee { employee id }{ emp_date_created, emp_firstName, emp_lastName, emp_address, emp_phone, emp_username, emp_email, emp_password, emp_type, emp_hourlyWage, emp_salary, organization_id, department_id, bank_id\} Performance { performance _id }{ perf_date_created, perf_notes, date_Achieved, KPI_Achieved, appraiser_id, appraised_id, project_id Project { project_id }{ prj_date_created, prj_name, prj_desc, KPI_goal } Department { Department_id }{ dep_date_created, dept_name, dept_desc, dept_budget, organization_id, manager_id } Bank {bankid}{ bnk_date_created, institute_number, transit_number, account_number } Transactions { transaction_id }{ transaction_date, wage, El_pay, vacation_pay, bonus_pay, overtime_pay, net_pay, employee_id, bank_id

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!