Magazine database

fOR CD CONTACT 03365532996
DEDICATION

This project is dedicated to Global Collage of Science, who has been very supportive during my college.

The successful completion of this project would not be possible without encouragement and appreciation of our teacher Mr. Sajid Riaz.

ACKNOWLEDGEMENT

I humbly express my gratitude towards my teacher and my classmates, who with their highest efforts and guidance have helped me all the way through this project. At the same time, I hope that my software can help a lot in solving problems because I have put up the best of my abilities in making this software. This software can solve rising issues of old and bulky registers. It also provides convenience to the user.

CERTIFICATE

It is certified that

Ø AHMED ALI DANISH

Ø QAZI KHALID AMIN

Ø DILAWAR HAYAT

Ø MUHMMAD USAMA ZAFAR
SAJEEL SAJJAD

are beneficed students of this college . They have completed the Database project for the year 2017-2018 according to syllabus of FBISE Islamabad.

SIGNATURE: ____________

Chapter#1

Introduction

In the existing system we analyzed the whole system and discuss about the problems that came in manual transactions. We noticed that in manual system data storage is very difficult task. A lot of problems like time consuming, lack of flexibility and data inconsistency etc. may face in manual transactions.

To overcome these problems we proposed a new system. This new system uses computerized transactions to store data. This new system provides user friendly interface and helps the user to store a large amount of data in very less time.

For new system we designed ERD (Entity Relationship Diagram) and showed the relationship among tables. Then we start developing a system. In system development we made tables, queries, forms and reports. All the data related to magazine database are stored in these objects.

Chapter#2

System Analysis

Existing System:

In our existing system all the transaction about magazine data are done manually.

The information about customers, magazine stock, and category of magazines is stored manually.

In this system we can fine a customer who get magazine on rent with respect to return date on which a customer must return book.

Problems:

In manual system data inputting is challenging for the worker. So in manual work we have to face a lot of problems. Some of them are as follows:

ü Time consuming

ü Lack of flexibility

ü Data inconsistency

ü Data security problem

ü No sharing of data

1-Time consuming:

Manual transaction take a lot of time to input data e.g. input data of magazine name, category etc.

2-Lack of flexibility:

The manual transaction is not flexible. It doesn’t easily generate the record that is altered from the routine e.g. if we want to need a record of magazine that is given to the people in last 6 months. It is very in manual transaction.

3-Data inconsistency:

Manual work may have the problem of data inconsistency and in this type of transaction it is probable that the record on two different places is diverse.

4-Data security problem:

There are greater chance of losing data in this nature of transaction because manual work are done on paper and there are bundles of paper having masses which is difficult to store or retained.

5-No sharing of data:

In manual transaction data is not shareable. If shareable they must reach the problem of data inconsistency.

Chapter#3

Proposed System

Computerized transactions (magazine database) is our project that targeting the following features:

· Provide user friendly interface.

· Manage and access the magazine according to author.

· Manage and access the magazine according to category.

In our proposed system all the transaction is done in computer. In this systems tables, forms, queries and reports are used to store data. The tables store all the data related to magazine like author information and category of magazine etc. If we want to add new data or to update data in the tables forms are used. The information about customers and fine details are display in the form of reports

The computerize transaction overwhelmed all those problems that is in existing system. The solution of the problems that modern technology can overcome is as under:

ü Time saving

ü System Efficiency

ü Data Security

ü Data is Shareable

1-Time Saving:

The computerize transaction reduce the time consuming process. In this type of transaction we enter large amount of data earlier and faster.

2-System Efficiency:

The computerize transaction is very efficient. It can easily generate a record that is altered from the routine. Suppose we need a record of a magazine that is given to a people. It can be easily collected just at a single click in modern transaction.

3-Data Security:

In computerize transaction all the records are accumulated in the form of soft copy. This transaction declines the chance of lost data.

4-Data is Shareable

In computerize transaction data can be sharable without any data inconsistency.

Chapter#4

System Design

1. Enti Relationship Diagram(ERD):

In (ERD) we tell the relationship among table. There are three type of relationship which are as follows:

ü One to one relationship

ü One to many relationship

ü Many to many relationship

These all relations are shown in (ERD) as bellow:

Chapter#5

System Development

In this stage we proper made tables, queries, forms and reports.

Tables

1-Category:

In this table we tell about the category ID and about a subject of the magazine on which magazine was written e.g. education, birds and politics etc.

Design View:

Datasheet View of Category Table

2-Customer Table:

In this table we tell us about customer ID which is primary key and other information like customer name, phone#, email, city etc.

Design View:

DATASHEET VIEW OF CUSTOMER TABLE

3-Magazine Table:

In this table we tell us about magazine id which is primary key. We get information about magazine name, publisher name publish date and about category name etc.

Design View: