VIDEO LIBRARY
SYSTEM
OBJECTIVE AND SCOPE OF THE
PROJECT
In the present era of the Information technology, the
value of time has been increase incredibility. Computer has
revolutionized our way of life style by providing us an
aster and accurate method getting information in less time.
This project can add new Audio/Video items, member
and customer. Modify an existing record as needed and
deleting the record, which is no longer needed. The prime
aspects of this project are searching. We can search and
display a record according to ID Number of an Video item
customer and member.
This project has a potential to be helpful in the
working of any library of this type.
THEORETICAL BACKGROUND
A Video Library as a library situated in a
city in which a number of varieties of new
and old Video CD’s and cassettes are
available. IT Provides a facility for taking
membership; we can tack a membership by
paying particular fee. Each member can issue
any item for one day and return it within the
time, otherwise a fine will be charged.
We can also purchase items from the
library as a customer. Library creates a bill to
customer for his purchase, and also creates a
receipt to the customer after accepting
amount of purchase. There is requirement to
generating the day wise report for Bill,
Receipt, Issue items, returns Items and Stock
Report for CD’s and cassettes available in
Library.
PROBLEM ANALYSIS
The first step in the problem definition phase is to
develop clear and unambiguous goals about our project.
Usually, the goals for a software project being with general
statement such as “ Maintaining and managing the overall
Operation of Library such as maintains the stock, preparing
the bill to a customer, managing the issuing and returning
the item by a member and preparing the reports.”
That problem definition gives us a direction in
which to move but there much more to be considered and
analyzed before we sit down at the keyboard.
To develop software the first thing, which comes
in mind, is
that why we need to develop software. What are the
problems faced by the user or staff to maintain manually
their records so that they decided to computerized their
working.
In library there are so many tasks, which are
tedious and time
Consuming. The person who maintain library manually
face so many problems like searching details of particular
record, security problem is the main problem which is
faced by the person that they maintain registers and any
one can change details easily.
To solve these types of problems we design a
computerized
Library management system, which is easy to operate, and
only authorized person can edit the information. Record
entry and searching is not time consuming and fine is
calculated automatically.
SOFTWARE ENGINEERING PARADIGM APPLIED
Computer aided software engineering can be as simple as a
single tool that supports a specific software engineering activity
or as complex as a complete “environment “ that standards and
myriad other components. Each building block forms a
foundation for the next, with tools sitting as the top of the heap. It
is interesting to note that the foundation for effective CASE
environment has relatively little to do with software engineering
tools themselves. Rather, successful environment architecture
must consider the human work patterns that are applied during the
software engineering process.
The environment architecture, composed of the hardware
platform and system support (including networking software,
software management, and object management services), lays the
groundwork for CASE. But the CASE environment itself
demands other building blocks. A set of portability services
provides a bridge between CASE tools and their integration
framework and the environment architecture. The integration
framework is the collection of specialized programs that enables
individual CASE tools to communicate with one another, to
create a project database, and to exhibit the same look and feel to
the end-user (the software engineer). Probability services allow
CASE tools and their integration framework to migrate across
different hardware platforms and operating systems without
significant adaptive maintenance.
The building blocks represent a comprehensive foundation
for the integration of CASE tools. However, most CASE tools in
use today have not been : constructed using all these building
blocks. In fact, some CASE tools remain “point Solution” – That
is, a tool is used to assist in a particular software engineering
activity (e.g. analysis modeling) but does not directly
communicate with other tools, is not tied into a project database,
is not the part of an integrated CASE environment (I-CASE).
Although this situation is not idea, a CASE tool can be used quite
effectively, even if it is a point solution.
At the low end of the integration spectrum is the individual
(point solution) tool. When individual tools can provide facilities
for data exchange, the integration level is improved slightly.
REQUIREMENT SPECIFICATIONS
We choose our project to automate the” Automated
Library system” for Excel Net computer Education
Agra because till now institute library is managed
manually for the classification of books and book
issue and return. Library management includes
various tasks. Visual basic is graphical user interface
based language, and using the user knows the
appearance of the output.
For managing databases we used MS-Access, visual
basic support MS-Access for connecting databases
using ODBC and Microsoft jet engine. In MS-Access
we can easily create tables, queries and many more
useful operations.
SOFTWARE REQUIREMENT
OPERATING SYSTEM Windows 98, XP
FRONT END Visual Basic 6.0
BACK END Ms-Access 97
DATA FLOW DIAGRAM
For Membership
MEMBER
INFORMATION
FILE
Member
Members
LIBRARY hip
CARD
For New Video
VEDIO
INFORMATION
Books
Purchas
e
For Video Issue
VIDEO
INFORMATION
FILE
MEMBER
INFORMATION
FILE
Member
Issue VIDEO ISSUE FILE
VIDEO ISSUE
For Video Return
Member
VIDEO
Return RETURN FILE
VIDEO RETURN
For Late Video Return
LATE RETURN
Memb FINE FILE
er FINE CHARGED
Fine
Data Flow Diagram for Ordering System
Audio/Video Information
Customer Process Customer Information
Order File
Data Flow Diagram for Order Verification
Customer Information
File
Assemble
Customer Edit Requisition to
Wareho
Order Warehouse use
Audio/Video Order
Audio/Video Order
Symbols used for E-R diagram.
Symbol Meaning
ENTITY
WEAK ENTITY
RELATIONSHIP
IDENTIFYING RELATIONSHIP
ATTRIBUTE
KEY ATTRIBUTE
MULTIVALUED
COMPOSITE ATTRIBUTE
ENTITY-RELATIONSHIP DIAGRAM OF
LIBRARY DATABASE
Serial
Video_id
Number
Release_date
Direct
Title or Produce
r
TotalTi
Price me
VIDEO_ENTRY
Remark
Actor
Actress
Serial
Number
Member
Number
Addres Name
Father_Name s
City
Pincode
Sex
MEMBER_ENT State
RY
Age
Mobile_No
Phone_No
Email_Id
Serial
Number Video_id
Video_Name
Direct
or
Issue
D_O_
I Member_I
d
Member_Name
ISSUE
Serial Video_Id
Number Video_Name
Director_
Name
D_O_ Day
I Member_I
d
Member_Name
RETURN Fine
Return_Date
Serial Video_Id
Number
Video_Name
Director_
Name
Day
D_O_
I Member_I
d
Member_Name
Fine
Fine
Return_Date
Type
DATABASE DESIGN
STRUCTURE OF DATABASE
NAME OF DATABASE –VIDEO LIBRARY
Table Name Details
1. Video Entry Details of Videos
2. Member Entry Details of Members
3. Issue Records of Video Issue
4. Return Records of Video Return
5. Fine Fine Details
STRUCTURE OF TABLE
NAME OF TABLE ------– VIDEO ENTRY
S.NO FIELD NAME DATA TYPES
1. Serial_Number Text
2. Video_Number Text
3. Title Text
4. Director Text
5. Producer Text
6. Release_Date Date/Time
7. Actor Text
8. Actress Text
9. Totaltime Text
8. Remark Text
NAME OF TABLE ---------– MEMBER ENTRY
S.NO FIELD NAME
DATA TYPES
1. Serial_Number Text
2. Member_Number Text
3. Name Text
4. Father Name Text
5. Address Text
6. City Text
7. Pin code Text
8. State Text
9. Sex Text
10. Age Text
11. Phone No. Text
12. Mobile No. Text
13. Email Add Text
NAME OF TABLE -------------–
VIDEO ISSUE
S.NO FIELD NAME
DATA TYPES
1. Serial_No Text
2. Video_id Text
3. Video_Name Text
4. Director Text
5. Member_id Text
6. Member_Name Text
7. D_O_I Date/Time
8. Issue Text
NAME OF TABLE ------------– VIDEO
RETURN
S.NO FIELD NAME
DATA TYPES
1. Serial_No Text
2. Video_id Text
3. Video_Name Text
4. Director_name Text
5. Member_id Text
6. Member_Name Text
7. Return_date Date/Time
8. Fine Text
9. Day Text
NAME OF TABLE ----------– FINE
S.NO FIELD NAME
DATA TYPES
1. Serial_No Text
2. Video_id Text
3. Video_Name Text
4. Director_Name Text
5. D_O_I Date/Time
6. Member_id Text
7. Member_Name Text
8. Return_Date Date/Time
9. Fine Text
10. Day Text
FORM VIDEO CONDITION DISPLAY
VIDEO ISSUE FORM
LOGIN FORM
MEMBER ENTRY FORM
CONDITION WISE MEMBER DISPLAY
MEMBER DISPLAY
MEMBER MODIFICATION FORM
PRINT FORM
VIDEO CASSATE ENTRY FORM
VIDEO DISPLAY FORM
VIDEO MODIFICATION ENTRY FORM
VIDEO RETURN FORM
MDI FORM
SPLASH FORM
