Week 6 Project Deliverable 3 Submission Assignment

Week 6 Project Deliverable 3 Submission - Assignment Example The database is going to be designed based on the various requirements that are to be integrated in the Order management System, Inventory System and the Supply processing system. The general idea for the implementation of the database schema would adopt a general flow basing on the fact transactions in a certain business entity take a general format of: 6. The ordering process will capture the essential requirements of the customer for instance the customer name, physical address, contact information, the type of goods that have been ordered and their specific quantities. 7. The ordering process be able to forward a report to the supply processing system where stock issues will be done and will be able to make the necessary adjustments on the stock level quantities upon retrieval from the stores The database design process will be divided into different autonomous design tasks relative to the followed design process. Particular emphasis will be laid on the logical database design and the physical database design (Teorey et al, 2011). The logical database design main objective is to determine the relevant user requirements, examination of the process flows of the existing system with an aim of identifying the challenges that are faced by the user of the system. It is also aimed at studying the specific business environment of the company. Therefore, the expected outcome will be the emergence and formulation of a system-independent database description that meets the key requirements (Teorey et al, 2011). It represents the database actual implementation process in relation to the system that exists. The physical database design is dependent on the RDBMS (Relational Database Management System) which is adopted by the user (Teorey et al, 2011). The software and the hardware environments greatly influence the structure. The system will be used by different personalities of which important roles