Wednesday 29 May 2013

AN E-BUSINESS PLATFORM FOR SUPERMARKETS



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
         
   A system is a group of things or parts working together in a regular relation. It is an ordered set of ideas, theories, principles etc.
            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

I HOPE THIS HAVE BEEN VERY INFORMATIVE,

Get the Full Material delivered to your Email, . Call us on 07034538881

Follow Us On Twitter,
Like Us On Facebook,
Join Our Cycle On Google+

we can keep u updated by subscribing for free using your email
For more clarification, Please Leave a comment.

Related Posts Plugin for WordPress, Blogger...