Payroll System

hi, please help me with my projects PL/SQL source code. please email it to [email protected] Project Description You are employed as a Database Developer/Administrator at the Computer Services department at HONDA. HONDA is well known for selling cars and motorcycles. The company needs a Parts Booking System which will be used for recording and monitoring requests for repairs and parts or other works. The company wants the system be developed using PL/SQL (general logic, trigger and some automated process). The scenario we have is: The current setup: parts requests and booking are recorded in a book. A client comes to the shop; he/she requests for a part, the sales person writes it in a book, the sales person then orders the part/s via telephone from HONDA South Africa. The client leaves the building. She /he come back after a week to see if the part has arrived. The Sales person has to go through the book to see if its there. It takes a while, as there are a lot of other requests from other clients. Once he finds it, he has to call the company to see if the part has been sent. If it has been sent, he has to go and check in the store room, he cannot see in the book if the part/s has arrived. If the part has been delayed, the salesman cannot see as to where the parts are delayed, he just has to wait until it arrives. Clients are not well informed about were their parts are when they have been ordered, etc. NOTE: (the scenario has been shortened to illustrate the problem being faced at Honda Namibia, a lot of problems still that you can think about, etc) Your task is to write a report to the IT Manager which should clearly indicate the necessary PL/SQL tools and techniques (example subprograms, triggers, cursors, etc) you will be using and why you suggest to use these selected PL/SQL tools (i.e. you must develop a preliminary system design in order to be able to identify those tools). The report should be so clear and convincing that the IT Manager will give a go ahead to start with a detailed design for future implementation. The preliminary system design is part of your deliverable and is inclusive in the report. --------------------------------- Thank you very much, i realy appreciate your assistance as soon as possible please. Best Regards Junice

hi, please help me with my projects PL/SQL source code. please email it to [email protected] Project Description You are employed as a Database Developer/Administrator at the Computer Services department at HONDA. HONDA is well known for selling cars and motorcycles. The company needs a Parts Booking System which will be used for recording and monitoring requests for repairs and parts or other works. The company wants the system be developed using PL/SQL (general logic, trigger and some automated process). The scenario we have is: The current setup: parts requests and booking are recorded in a book. A client comes to the shop; he/she requests for a part, the sales person writes it in a book, the sales person then orders the part/s via telephone from HONDA South Africa. The client leaves the building. She /he come back after a week to see if the part has arrived. The Sales person has to go through the book to see if its there. It takes a while, as there are a lot of other requests from other clients. Once he finds it, he has to call the company to see if the part has been sent. If it has been sent, he has to go and check in the store room, he cannot see in the book if the part/s has arrived. If the part has been delayed, the salesman cannot see as to where the parts are delayed, he just has to wait until it arrives. Clients are not well informed about were their parts are when they have been ordered, etc. NOTE: (the scenario has been shortened to illustrate the problem being faced at Honda Namibia, a lot of problems still that you can think about, etc) Your task is to write a report to the IT Manager which should clearly indicate the necessary PL/SQL tools and techniques (example subprograms, triggers, cursors, etc) you will be using and why you suggest to use these selected PL/SQL tools (i.e. you must develop a preliminary system design in order to be able to identify those tools). The report should be so clear and convincing that the IT Manager will give a go ahead to start with a detailed design for future implementation. The preliminary system design is part of your deliverable and is inclusive in the report. --------------------------------- Thank you very much, i realy appreciate your assistance as soon as possible please. Best Regards Junice