t Company XYZ has three branches in Luzon named branch A, B, and C and a head office in Manila. The payroll department processes sales commission of the company’s salesmen by collecting sales records from three branches and the main office. Branch A sends an excel file to the main office through the internet. Branch B sends a comma delimited file (csv similar to excel) using the internet as well. Due to the absence of internet connection in branch C, a hardcopy file is sent to the main office through a messenger. Once all branch records are forwarded to the main office, these records will be consolidated to come up with a new database table named Sales from Branches. After consolidation, consolidated sales from branches and sales from main will be processed to compute the sales commission using employee records as reference for withholding tax purposes. Sales records of the main office and employee records for both main office and bran
Statement
Company XYZ has three branches in Luzon named branch A, B, and C and a head office in Manila. The payroll department processes sales commission of the company’s salesmen by collecting sales records from three branches and the main office. Branch A sends an excel file to the main office through the internet. Branch B sends a comma delimited file (csv similar to excel) using the internet as well. Due to the absence of internet connection in branch C, a hardcopy file is sent to the main office through a messenger. Once all branch records are forwarded to the main office, these records will be consolidated to come up with a new
Draw a data flow diagram to illustrate the above statement.
Step by step
Solved in 2 steps with 1 images
