E-R Diagram

E-R Diagram

Section 1 Database Description

Our database models a chain of super-stores such as Rajani’s. The management of such a corporation would require the maintenance and handling of information that is beneficial to decision making by the corporation. The chain of superstores that we are modeling wishes to maintain information concerning various products, branches, transactions, and finally, privileged customers. This information is to be managed in a logical fashion and is to be used to determine the prevalent trends in the tastes of the customers, as well as the popularity of the various products and services that the corporation offers. 1.1 Management structure of the enterprise

A good example of a chain of superstores is Rajani’s. For the purpose of our project, we chose the Rajani’s chain, due to their rigid and professional management structure, and their willingness to accept and employ new technologies. Currently, the Rajani’s chain uses a semi automated filing system that involves a two step process: • Periodic generation and accumulation of all receipts from all cash registers and terminals, and • Manual data entry into a central filing system. Management decisions are based on information gleaned from this filing system. As is obvious, this process can be very tedious, and possesses all the demerits associated with filing systems. Although the initial purpose of our DBMS project was simply the creation of a viable database system, we seized this opportunity to put our database designing knowledge to the test by designing and creating a database model that should form part of any future upgrades to the current Rajani’s system. The database system we have designed only handles information related to storekeeping and privileged customer credit management. It models part of a proposed fully automated information system that would handle all kinds of information necessary for a real company, including economic factors, taxation information, employee...

Similar Essays