Week 6 Project Deliverable 3 Submission Assignment

Week 6 Project Deliver fit 3 Submission - Assignment ExampleThe database is going to be designed based on the confused requirements that are to be integrated in the Order management System, Inventory System and the Supply routineing system. The general idea for the implementation of the database schema would take a general flow basing on the fact transactions in a certain business entity take a general format of6. The orderliness go 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 storesThe database design process will be divided into different autonomous design tasks telling to the followed design process. Particu lar emphasis will be laid on the logical database design and the physical database design (Teorey et al, 2011).The logical database design main impersonal 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 bring the structure.The system will be used by different personalities of which important roles