AN E-BUSINESS PLATFORM FOR
SUPERMARKETS
(A CASE
STUDY OF CY SUPERMARKET)
PRESENTED BY
OBEJI IBEABUCHI ERIC
EBSU/2007/42252
A PROJECT SUBMITTED TO THE
DEPARTMENT OF COMPUTER SCIENCE
IN PARTIAL FULFILMENT FOR THE
REQUIREMENTS FOR THE AWARD OF BACHELOR OF SCIENCE (B.SC) DEGREE IN
COMPUTER SCIENCE
FACULTY OF PHYSICAL SCIENCES
EBONYI STATE UNIVERSITY, ABAKALIKI
MARCH, 2012
CHAPTER FOUR
SYSTEM
DESIGN AND IMPLEMENTATION
4.1 INTRODUCTION
TO NEW SYSTEM
Design
is the general arrangement or planning of things so as to achieve its effective
utilization. Hence, system is the general arrangement or planning with the aim
of achieving a highly result oriented and efficient system.
Having
looked at and studied critically the old system with its underlying
deficiencies, it is now easier to determine which area of the system that needs
revision. Based on that fact, the new system design is to specify things that
actually meet the users’ requirements. After the system design, the system will
now be able to answer some questions and as well show the level of stock at
each point in time, so that recording of items can easily be done. In trying to
conduct effective system design, strict adherence where made to the software
engineering principles. To clarify things, charts and diagrams are shown where
appropriate. As much as constraints imposed by the scope of this work a design
that mostly meets the needs of the system under study in terms of economy and
effectiveness is vigorously pursued in the section that follows.
4.2
DESCRIPTION
OF THE NEW SYSTEM
The new system is
designed to provide management with up to date information about their
customers and enhance their daily sales.
4.3
Project
Design
In order to design a
web site, the relational database must be designed first.
Conceptual design can be divided into two parts: The
data model and the process
model.
The data model focuses on what data should be stored in the database while the process
model deals with how the data is processed. To put this in the context of the relational
database, the data model is used to design the relational tables. The process model
is used to design the queries that will access and perform operations on those tables.
4.3.1
Data Model
A data model is a conceptual
representation of the data structures that are required by a database. The
first step in designing a database is to develop an Entity-Relation Diagram
(ERD). The ERD serves as a blue print from which a relational database maybe
deduced. Figure 4.1 shows the ERD for the project and later I will show the
transformation from ERD to the Relational model
No comments:
Post a Comment