result.txt

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

now display
QAR(employee_sin,employee_name,employee_address,employee_phone,employee_hire_date,employee_type,cust
omer_licence,customer_name,customer_address,customer_phone,car_plate_number,modal,service_type,servi
ce_description,difficulty_level,service_price,service_name,frequency_paid,wage,employee_type,commiss
ion,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_qua
ntity,part_id,part_name,stock_quantity,quit_date);
employee_sin service_time service_date  -> car_plate_number service_type order_id ;
car_plate_number service_time service_date  -> order_id ;
car_plate_number service_type order_id  -> employee_sin service_time service_date ;
employee_type  -> difficulty_level frequency_paid wage commission ;
payment_method  -> discount ;
order_id  -> customer_licence order_issue_date order_due_date order_status payment_date ;
payment_id  -> payment_method discount order_id payment_date payment_amount ;
part_id  -> part_name stock_quantity ;
service_type part_id  -> required_part_quantity ;
part_order_date part_id  -> part_order_quantity ;
employee_sin  -> employee_name employee_address employee_phone employee_hire_date employee_type diff
iculty_level frequency_paid wage commission quit_date ;
customer_licence  -> customer_name customer_address customer_phone ;
car_plate_number  -> customer_licence modal ;
service_type  -> service_description difficulty_level service_price service_name ;
{car_plate_number,service_type,employee_type,payment_id,part_order_date,part_id}
{employee_sin,employee_type,service_time,service_date,payment_id,part_order_date,part_id}

before decomposition
employee_sin service_time service_date  -> car_plate_number service_type ;
car_plate_number service_time service_date  -> order_id ;
car_plate_number service_type order_id  -> employee_sin service_time service_date ;
employee_type  -> difficulty_level frequency_paid wage commission ;
payment_method  -> discount ;
order_id  -> customer_licence order_issue_date order_due_date order_status payment_date ;
payment_id  -> payment_method order_id payment_amount ;
part_id  -> part_name stock_quantity ;
service_type part_id  -> required_part_quantity ;
part_order_date part_id  -> part_order_quantity ;
employee_sin  -> employee_name employee_address employee_phone employee_hire_date employee_type quit
_date ;
customer_licence  -> customer_name customer_address customer_phone ;
car_plate_number  -> customer_licence modal ;
service_type  -> service_description difficulty_level service_price service_name ;

decomposition #1:{employee_sin,car_plate_number,service_type,service_time,service_date}
dependency is:
employee_sin service_time service_date  -> car_plate_number service_type ;


decomposition #2:{car_plate_number,service_time,service_date,order_id}
dependency is:
car_plate_number service_time service_date  -> order_id ;


decomposition #3:{employee_sin,car_plate_number,service_type,service_time,service_date,order_id}
dependency is:
employee_sin service_time service_date  -> car_plate_number service_type ;
car_plate_number service_time service_date  -> order_id ;
car_plate_number service_type order_id  -> employee_sin service_time service_date ;


decomposition #4:{employee_type,difficulty_level,frequency_paid,wage,commission}
dependency is:
employee_type  -> difficulty_level frequency_paid wage commission ;


decomposition #5:{payment_method,discount}
dependency is:
payment_method  -> discount ;


decomposition #6:{customer_licence,order_id,order_issue_date,order_due_date,order_status,payment_dat
e}
dependency is:
order_id  -> customer_licence order_issue_date order_due_date order_status payment_date ;


decomposition #7:{payment_method,order_id,payment_id,payment_amount}
dependency is:
payment_id  -> payment_method order_id payment_amount ;


decomposition #8:{part_id,part_name,stock_quantity}
dependency is:
part_id  -> part_name stock_quantity ;


decomposition #9:{service_type,required_part_quantity,part_id}
dependency is:
service_type part_id  -> required_part_quantity ;


decomposition #10:{part_order_quantity,part_order_date,part_id}
dependency is:
part_order_date part_id  -> part_order_quantity ;


decomposition #11:{employee_sin,employee_name,employee_address,employee_phone,employee_hire_date,emp
loyee_type,quit_date}
dependency is:
employee_sin  -> employee_name employee_address employee_phone employee_hire_date employee_type quit
_date ;


decomposition #12:{customer_licence,customer_name,customer_address,customer_phone}
dependency is:
customer_licence  -> customer_name customer_address customer_phone ;


decomposition #13:{customer_licence,car_plate_number,modal}
dependency is:
car_plate_number  -> customer_licence modal ;


decomposition #14:{service_type,service_description,difficulty_level,service_price,service_name}
dependency is:
service_type  -> service_description difficulty_level service_price service_name ;


decomposition #15:{car_plate_number,service_type,employee_type,payment_id,part_order_date,part_id}
the key has no particular dependency
        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_pric
e       service_name    frequency_paid  wage    employee_type   commission      payment_method  disc
ount    service_time    service_date    order_id        order_issue_date        order_due_date  orde
r_status        payment_date    payment_id      payment_amount  part_order_quantity     part_order_d
ate     required_part_quantity  part_id part_name       stock_quantity  quit_date
employee_sin service_time service_date  -> car_plate_number service_type ;
        111111111111111111101001111111000000001
car_plate_number service_time service_date  -> order_id ;
        000000111111000000000001111111000000000
car_plate_number service_type order_id  -> employee_sin service_time service_date ;
        111111111111111111101001111111000000001
employee_type  -> difficulty_level frequency_paid wage commission ;
        000001000000001001101000000000000000000
payment_method  -> discount ;
        000000000000000000000110000000000000000
order_id  -> customer_licence order_issue_date order_due_date order_status payment_date ;
        000000111100000000000000011111000000000
payment_id  -> payment_method order_id payment_amount ;
        000000111100000000000110011111110000000
part_id  -> part_name stock_quantity ;
        000000000000000000000000000000000001110
service_type part_id  -> required_part_quantity ;
        000000000000111110000000000000000011110
part_order_date part_id  -> part_order_quantity ;
        000000000000000000000000000000001101110
employee_sin  -> employee_name employee_address employee_phone employee_hire_date employee_type quit
_date ;
        111111000000001001101000000000000000001
customer_licence  -> customer_name customer_address customer_phone ;
        000000111100000000000000000000000000000
car_plate_number  -> customer_licence modal ;
        000000111111000000000000000000000000000
service_type  -> service_description difficulty_level service_price service_name ;
        000000000000111110000000000000000000000
service_type  -> service_name ;
        111111111111111111111111111111111111111

final display
employee_sin service_time service_date  -> car_plate_number service_type ;
car_plate_number service_time service_date  -> order_id ;
car_plate_number service_type order_id  -> employee_sin service_time service_date ;
employee_type  -> difficulty_level frequency_paid wage commission ;
payment_method  -> discount ;
order_id  -> customer_licence order_issue_date order_due_date order_status payment_date ;
payment_id  -> payment_method order_id payment_amount ;
part_id  -> part_name stock_quantity ;
service_type part_id  -> required_part_quantity ;
part_order_date part_id  -> part_order_quantity ;
employee_sin  -> employee_name employee_address employee_phone employee_hire_date employee_type quit
_date ;
customer_licence  -> customer_name customer_address customer_phone ;
car_plate_number  -> customer_licence modal ;
service_type  -> service_description difficulty_level service_price service_name ;
Press any key to continue