library project
DESCRIPTION
The project required for Computer Science subjectTRANSCRIPT
![Page 1: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/1.jpg)
1
![Page 2: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/2.jpg)
2
![Page 3: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/3.jpg)
It is certificates that Mr. /Miss
Roll No. Class is a bonafide student of
School/ College
He/ She has completed the Practical for the
Year 20 According to the Syllabus of
Board of Intermediate and Secondary Education
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Signature of Signature of theScience Teacher Head of the Institution
Dated: Dated:
3
![Page 4: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/4.jpg)
Project Brief
Project Name: Library Management System
Supervised By: Madam Nazia Qadar
Submitted By: Hina Siddique
Atiya Ahmad
Software Used: MS Access , MS Word
Institution Name: Islamabad Model College for Girls (PG) F-7/2
Session: 2014-15
Starting Date: 16-11-2014
Ending Date: 12-12-2014
Signature
4
![Page 5: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/5.jpg)
In the name of Allah, the most Beneficent and the most Merciful. First of all we would thank Almighty Allah, without His help we could not have accomplished anything.
We would also like to thank to our teachers and our parents who prayed enc helping and supporting us during our project-work. Also we would like to thank our family and friends especially our respected parents, for their never ending love and support to us, at all times and during the building for our project.
We hope this project to be of great assistance for everyone who read or run it.
5
![Page 6: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/6.jpg)
1. INTRODUCTION (i) INTRODUCTION TO DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . 07
2. EXISTING SYSTEM (i) EXISTING SYSTEM. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 08(ii) PROBLEMS FACED BY EXISTING SYSTEM. . . . . . . . . . . . . . . . . . 08
3. PROPOSED SYSTEM (i) PROPOSED SYSTEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 09(ii) ADVANTAGES OF PROPOSED SYSTEM. . . . . . . . . . . . . . . . . . 09
4. ER-DIAGRAM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
5. REATIONSHIP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
6. TABLES (i) BOOKS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15(ii) TEACHER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16(iii) LIBRARIAN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17(iv) STUDENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
7. FORMS (i) MAIN FORM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20(ii) SUB FORM. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21(iii) BOOKS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22(iv) TEACHER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23(v) LIBRARIAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24(vi) STUDENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
8. QUERY (i) ASCENDING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27(ii) GREATER THAN EQUAL TO. . . . . . . . . . . . . . . . . . . . . . . . . . . 28(iii) LIKE OPERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29(iv) MULTIPE COLUMN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30(v) PARAMETERY. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
9. REPORT (i) ASCENDING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33(ii) GREATER THAN EQUA TO. . . . . . . . . . . . . . . . . . . . . . . . . . . . 34(iii) LIKE OPERATOR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35(iv) MUTIPLE COLUMN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36(v) PARAMETRY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
10. CONCUSION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
11.
6
![Page 7: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/7.jpg)
Introduction to Database:
Database is a collection of related data to a particular topic or subject. The database stores information in the form of tables that are somehow related to each other and provide detailed information about the concerned things. Information that database stores can be anything it can be about the personal information of a group of people working together as for example library members, students of a school, colleges or university.
7
![Page 8: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/8.jpg)
Existing System:
To store data and information it was stored in the form of registers. It was unsuitable and was time taking. It took longer time to find the data when needed.
Problem Faced by the Existing System:
As the owner of “LIBRARY” I had faced many problems due to previous system. It was difficult to collect data was copied in different files. It was difficult to manage the workers and sometime I had lost many important data of students.
8
![Page 9: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/9.jpg)
Proposed System:
In order to solve the problem of existing system, the concept of a new system was introduced.
Some advantages of new system are as under.
Advantages of Proposed System:
In this computerized system I can easily access the record and make changes in it easily.
Data Consistency:
Where any change takes place in any field of table it will change in the whole form.
Flexibility: This computerized data base saves time and it require less
time.
Shareable Data: Data easily share in this computerized system.
Independent Data: In this computerized system data is not dependent on each
other
User Friendly: This database is user friendly. I learn easily because it is
English like language.
9
![Page 10: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/10.jpg)
10
![Page 11: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/11.jpg)
11
TEACHER
Name
Contact
Address
BOOK
ID card
Author
Title Book Code
Date of Publish
Library Card
STUDENTName
Address
Library Card
Roll No
Issued ByIssued
By
Has
LIBRARIAN
NameContact
AddressID card
Library Card
Quantity
Contact
Book Code
Book Code
Librarian ID
Teacher ID
![Page 12: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/12.jpg)
12
![Page 13: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/13.jpg)
13
![Page 14: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/14.jpg)
14
![Page 15: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/15.jpg)
DESIGHN VIEW
`
DATASHEET VIEW
15
![Page 16: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/16.jpg)
DESIGHN VIEW
DATASHEET VIEW
16
![Page 17: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/17.jpg)
DESIGHN VIEW
DATASHEET VIEW
17
![Page 18: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/18.jpg)
DESIGHN VIEW
DATASHEET VIEW
,
18
![Page 19: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/19.jpg)
19
![Page 20: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/20.jpg)
20
![Page 21: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/21.jpg)
21
![Page 22: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/22.jpg)
22
![Page 23: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/23.jpg)
23
![Page 24: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/24.jpg)
24
![Page 25: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/25.jpg)
25
![Page 26: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/26.jpg)
26
![Page 27: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/27.jpg)
27
![Page 28: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/28.jpg)
DESIGHN VIEW
DATASHEET VIEW
28
![Page 29: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/29.jpg)
DESIGHN VIEW
DATASHEET VIEW
29
![Page 30: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/30.jpg)
DESIGHN VIEW
DATASHEET VIEW
30
![Page 31: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/31.jpg)
DESIGHN VIEW
DATASHEET VIEW
31
![Page 32: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/32.jpg)
DESIGHN VIEW
PARAMETERIC VIEW
DATASHEET VIEW
32
![Page 33: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/33.jpg)
33
![Page 34: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/34.jpg)
34
![Page 35: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/35.jpg)
35
![Page 36: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/36.jpg)
36
![Page 37: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/37.jpg)
37
![Page 38: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/38.jpg)
38
![Page 39: Library project](https://reader034.vdocuments.us/reader034/viewer/2022052603/563db77e550346aa9a8b907e/html5/thumbnails/39.jpg)
This designed database system is accurate for the editing and retrieval of data. The data saved in computer can be accessed any time. This system contains records of books. This system is user-friendly.
In future we can easily edit and enter new data. And can also enter new entities and attributes if needed.
It is easier to add and subtract new data in the entity because it is friendlier than the file processing system.
We can find data more frequently and in less time than file processing system. It will work faster and will help more.
39