qar.txt

This is a little tool to generate dependency and it is aimed to achieve BCD-normal form in relationa

QAR(employee_sin, employee_name, employee_address, employee_phone, employee_hire_date, employee_type, customer_licence,
	customer_name, customer_address, customer_phone, car_plate_number, modal, service_type, service_description,				difficulty_level, service_price, service_name, frequency_paid, wage, employee_type, commission,					payment_method, discount, service_time, service_date, order_id, order_issue_date, order_due_date,
	order_status, payment_date, payment_id, payment_amount, part_order_quantity, 			part_order_date,required_part_quantity, part_id, part_name, stock_quantity, quit_date);


employee_sin service_date service_time -> order_id car_plate_number service_type;
car_plate_number service_date service_time -> order_id;
car_plate_number service_type order_id -> employee_sin service_time service_date;


employee_type -> commission difficulty_level wage frequency_paid;
payment_method -> discount;

order_id -> order_issue_date order_due_date order_status payment_date customer_licence;
payment_id -> payment_method payment_amount discount order_id payment_date;
part_id -> part_name stock_quantity;
part_id service_type -> required_part_quantity;
part_id part_order_date -> part_order_quantity;

employee_sin -> employee_name employee_address employee_phone employee_type employee_hire_date wage 
	frequency_paid difficulty_level commission quit_date;
customer_licence -> customer_name customer_address customer_phone;
car_plate_number -> modal customer_licence;
service_type -> service_description service_price difficulty_level service_name;