Project on Database Design for College Library
Index: 1. Introduction............................................................................ 3 2. Requirement Analysis ..............................................................4 3. Defining Entitiy and Attribute...................................................5 4. Entity Relationship Diagram......................................................6 5. Non- Technical overview of Entity Relationship Diagram..........7 6. User Applications...................................................................... 7 7. ER
…show more content…
SQL Queries to retrieve data .........................................................29-37
11.Factors that influence Physical Database Design.............................38
Introduction :
Generally Institutions are mature and different systems are employed by the libraries to manage their resources in an efficient manner but still many libraries remain unconvinced and show reluctance to employ and switch over to new systems. Library management refers to the issues involved in managing the resources available in library such as classification of material, book processing, Journals.
My plan in implementing database design for college library will bring out technical advantages that are lacking in present system in maintaining Library.I will analyse the limitations of existing manual system employed by a college library and will mainly focus on the solution to provide a centralised repository
Database is defined as “the collection of information organized in such way that a computer program can quickly select the desired pieces of data.” (Haithcoat, n.d.). In today’s technological world most of the processes is automated where database plays an important role to manage the data across a system. A database can be considered as an electronic filing system. Traditional databases are organized by fields, records, and files. A field is a single element of information; a record is one complete set of elements; and a file is a collection of records. To manage these data across the database system, DBMS came into play and the basic role was to create the management of information across all the data. DBMS plays a critical and integral component of most successful GIS and used to store, manipulate and retrieve data from the database. Although the range of DBMS structures used in GIS includes inverted list, hierarchical, network and relation design.
This is a project report on “Library Management System”. During the making/developing of this project we explored new ideas and functionality behind the working of and DBMS technique.
Abstract – With companies such as Facebook and Google producing large volumes of data, known as Big Data, the popularity of NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reason companies in the past decade are selecting to implement these databases over traditional relational databases.
Metadata present a more complete picture of the data in the database than the data itself.
Abstract-The Library management system is the application software that is developed to make a record of Book purchasing, book searching, book issuing and rent, book returned, catalogs, stock creation, all other fine books, popular and bestsellers and other Library related works. The aim of the project is to make the manual handling of Library system into computerized system which includes all above features. The scope of this software application is to generate the automatic process of manual handling of Library records and to handle the stock as well as book issues related information. Maintaining records of application for estates, the annual system is too complex & cumbersome. Since time and resources available we have been proposed to developed an inventory system
So, database project started at 1997 and project went well. But it is very much state of the art technology and IT is also difficult for everyone at first. After researching more than 2 years about individual card holder transaction records and a selection of non-card holder sales records, the size of the database was larger and larger. Therefore, Boots wanted to get the right structure database with maximum flexibility and also it can achieved to store data at the lowest level of granularity for user to build it up to any level they require during analysis. Commercial analysts can also have rapid real time access to all of the data without having to make special requests on IS support. The database structure should be to support the analytical process.
There are different definitions around digital library characterized by insightful and expert interests in digital libraries. A few meanings of digital library are accessible in the writing while such definitions supplement each other and there are some counter contentions as well. Digital library comprises of an arranged gathering of mixed media data commonly accessible in one area. It additionally comprises of capacity and correspondence, types of gear with the substance and programming expected to imitate, copy and amplify the administrations gave by customary libraries taking into account paper and other material method for gathering, inventing, finding and scattering data. Late innovation additionally has empowered new assumption about digital libraries. The digital library (DL) without bounds will be regularly extending frameworks for example the
It is a distributed database where each site shares a common software and the same copy of database.
In todays era, the volume of data we manage has developed to terabytes. As the volume of data continues developing, the sorts of data produced by applications get to be wealthier than some time recently. Subsequently, traditional relational databases are tested to catch, visualize, seek, share, break down, and store data. We find many difficulties in managing big data using traditional data modeling techniques. We still need an advance modeling techniques threw which we can solve problems of managing big data. There are two types of data models in data base system one is relational model and other is non
In EcOS, data and metadata are stored in time series database. An EcOS database has some key characteristics:
I conducted a situational analysis, analysis of the competitive environment, and presents data on the characteristics of overall library’s activity.
In today’s time management is very necessary for everything. That’s why nowadays an operating system which is application friendly is our first choice since applications are the main components for management. Nowadays we just need some applications to make all our activities managed. Such as for reminder of any task we keep reminder application’s which keeps us reminded about our work we keep messenger application to keep ourselves in touch with the activities happening in our friends groups. Since in amity we keep some amity application’s which help ourselves to track the class timing’s etc. So we also need a “Library Management System” which keeps ourselves managed without being standing in lines and waiting for our turn and then waiting for the Library staff to give us our card. Some of us do have the habit of losing the library card and then again paying for it. So it the best if we have this management system which keeps the data of the student stored on the computer and the student does not need to worry about library cards etc. Every data about the student can be stored on the computer itself which can also reduce the work of the Library faculties since they can also stop worrying about keeping the cards in proper desk according to the months and since in this system the fine can also be generated if the student crosses the time limit of the book.
Now a day‘s libraries are more powerful than before, offering fast and easy information and making fewer barriers to access information. Now in this changing scenario, information professionals give more importance to human behavior than resources.
The reference section of university libraries may be considered as the heart of the library as it provides ready reference sources and instant reference services to the users. The reference sections of University Libraries seek to promote a reference collection development program in concert with the University’s curriculum and users’ needs. Though most of the university libraries have a very large and useful reference collection but regular use of those collections is not possible due to lack of user awareness about the reference collection of the libraries. Therefore the library professional should orient the reference section in an attractive manner and should also organize information literacy programme so that the user become able to make the best use of the collection. In the era of 21st century, Reference service has shifted its paradigm from asking help of the library professional at the Reference desk to get on-line Reference services like Ask-a-librarian through mobile phone, e-mail, online chat, sms , RSS feed etc. Therefore it is very much needed to provide reference service in an excellent way with the help of properly selected printed and non-printed materials as well as modern information and communication technologies.
Library is an important part of the academic sector as well as some professional sectors too like, Advocacy etc. The efficiency of a library lies in the fact how it is arranged and how easily one can get the books of their choice. Generally, what we see nowadays is the manual library management system whose process of operation is