06-09-2016, 04:16 PM
1453345549-VideoLibraryManagementSystemProject.docx (Size: 27.93 KB / Downloads: 7)
Problem Definition
Using current system customers have to find their CD by checking their names, singers etc manually. This may sometimes makes customers unhappy by not finding their products. Managers or working employees cannot find the sales details of particular CD and thus cannot categorize then properly. Under one store there are various types of CD sold and their managers find difficulties to maintain the records of their vendors. It also creates difficulties in generating reports and analyzes marketsituations as per customer demands and requirements.
Motivation behind this project
To help user in finding their products easily and thus saving time. To eliminate manual process of storing information by using the concept of database as backend and providing graphical user interface by using Visual basic as front end. Eliminating file keeping system and implementing the use of data backup options to save their precious data.
Project Statement
Background – Current Process
Under current system users are not able to find their choice products by themselves. They have to provide details to the shopkeeper of particular video CD and after that shopkeeper provide details by checking their catalogue whether that particular CD is available in their shop or not. It is also very difficult to categorize the products by using the year of release, artists, album names, price etc. For getting details of financial transactions such as total sells of particular day, month etc its users have to use the bill diary to calculate the overall selling of particular date and time. This involves manual interaction which may sometimes results in an error.
Overview
This system will help their customers to find products as per their query in less time. User can search any particular video cd using their year of release, any particular song name, artist details, film name etc. Thus saving their time and eliminating the process of searching manually.
Admin will only have the authority to add records, delete records, modify any existing records, giving permission to any employee. Admin can generate reports as per their requirement. Admin will also able to add vendor details from where they purchased along with Video CD name, price of CD and date of purchase. Admin can check the sells and purchase records by using information stored in the database.
Working employee will have a valid user name and password. Employee will be eligible to generate bills for the customers and receive payments. When the employee will enter the first letter of the Video CD, then a list of available CD will appear from where they can select the name of CD. After selecting the name, its price with its details will appear on the screen. They have to only enter the total number of quantity or items, then after system will generate the total amount which is to be paid by the customer.
Technologies Used
1. VB.Net as front end.
2. My SQL Server as back end.
Software Used
1. Windows 8.
2. Visual studio 2010 Professional.
3. My SQL Server.
Hardware Requirements
• Processor – Intel Core processor above Pentium IV
• Ram – 512 MB
• Hard Disk – 1 GB
• Monitor.
• Keyboard.