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:
DATASHEET VIEW OF MAGAZINE TABLE
4-Rent Magazine Table:
              In this table we tell about rent id which is primary key, magazine name, customer name, issue date and about fine etc.
Design View:

DATASHEET VIEW OF RENT MAGAZINE TABLE

 5-Stock Table:
In this table we tell us about stock id which is primary key and stock number etc.
Design View:
DATASHEET VIEW OF STOCK TABLE
Queries
Customer Detail Query:
2-Fine View Query:
3-Issue Magazine Query:
4-Magazine Detail Query:

5-Rent Magazine Query:
Forms
ISSUE MAGAZINE FORM


              NEW CATEGORY FORM


NEW CUSTOMER FORM




NEW MAGAZINE FORM




Reports
CUSTOMER DETAIL REPORT

  
ISSUE MAGAZINE REPORT


MAGAZINE DETAIL REPORT


Popular posts from this blog

Stack

Image
Program #include<iostream> using namespace std; struct node { int data; node *next; }; class ListStack{ node *head; public: ListStack() { head=NULL; } void push(int info) { node *NewNode=new node; NewNode->data=info; NewNode->next=head; head=NewNode; } int pop() { if(IsEmpty()) { cout<<"Underflow occurs "; return NULL; } int info; node *cur=head; info=head->data; head=head->next; delete cur;             return info; } int IsEmpty() { if(head==NULL) return 1; return 0; } }; int main() { ListStack s; s.push(20); cout<<s.pop(); cout<<s.pop(); }
Read more

Operation on Single Linked List

Image
Program /*  * C++ Program to Implement Singly Linked List  */ #include<iostream> #include<cstdio> #include<cstdlib> using namespace std; /*  * Node Declaration  */ struct node {     int info;     struct node *next; }*start; /*  * Class Declaration  */ class single_llist {     public:         node* create_node(int);         void insert_begin();         void insert_pos();         void insert_last();         void delete_pos();         void sort();         void search();         void update();         void reverse();         void display();         single_llist()         {             start = NULL;   ...
Read more

EXTRA INFORMATION ABOUT TECHNOLOGY

Image
Here are some more things from which you should know about them. There are many things but you should know about some of them Firstly I would like to give you information about  GLOBAL VILLAGE: In this Century,  the World has become a Global Village.  You are a thing about the above sentence that HOW THE WORLD HAS BECAME A GLOBAL VILLAGE? Yeah, It is the reality. You can see that within a seconds or minutes we can contact every person from the world by using some Social Media Sites excepting those which we know or we don't know.  Some Social Media Sites are: FACEBOOK TWITTER SKYPE IMO INSTAGRAM WHATS APP YOUTUBE THROUGH E-MAIL AND MUCH MORE SITES ARE AVAILABLE IN THE MARKET               If you want to get an extra information about Technology then you must check our YouTube Channel's Link and directly go to the COLLEGE OF INFORMATION    ...
Read more