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 }{ 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
Get step-by-step solutions from verified subject matter experts
