Week 6 Project Deliverable 3 Submission Assignment

Week 6 support Deliverable 3 Submission - Assignment ExampleThe database is going to be designed based on the various requirements that ar to be integrated in the Order management System, Inventory System and the interpret processing system. The general idea for the performance of the database schema would adopt a general flow basing on the fact transactions in a certain business entity take a general change of6. The ordering process leave behind capture the essential requirements of the customer for instance the customer name, physical address, rival 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 storesThe 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 briny 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 anticipate 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 utilise by different personalities of which important rol es