Essay About Purpose Of The Library System And Select Query

Business
Essay Preview: Business
Report this essay
Purpose of the library system:The construction of library management program intended to be served for the effectiveness of lending and borrowing books, provide adequate information with accuracy, time-saving, compact and convenient.Vital requirement of the system:So as to fulfill the stated purposes of the system, the program must perform the following basic tasks:Always update, follow the information to reflect timely and accrurately about the current situation of the books, readers, reports, statistics when required. Reflect the process of “borrowing and returning” list of readers.Advantage of library system:As mentioned aboveSimple and easy to useCost effectiveEmbracing sophisticated technologies is cost-effective and a viable choice for education institutions. Using digital libraries eliminates paper-based processes and maintenance overheads, improves productivity, reduces operation costs and saves time. Achive the highest efficiency in the management fieldBorrowers are served better and easily required to follow the regulations of the library.Table:A relational database like Access usually has several related tables. In a well-designed database, each table stores data about a particular subject, such as employees or products. A table has records (rows) and fields (columns). Fields have different types of data, such as text, numbers, dates, and hyperlinks.With this library system, we are creating 11 fields with different types: Book, Borrow Report, Borrow, Import Report, Import, Member, Return Report, Return, Staff, Supplier, User. Querry:A query is a database object that creates a datasheet of specified records from one or more tables. Queries are very useful tools when it comes to databases and they are often called by the user through a form. They can be used to search for and grab data from one or more tables, perform certain actions on the database and even carryout a variety of calculations depending on needs.There are mainly four types of queries, which are:Select QueryThe select query is the simplest type of query and because of that, it is also the most commonly used one in Microsoft Access databases. It can be used to select and display data from either one table or a series of them depending on what is needed.It is the user-determined criteria that tells the database what the selection is to be based on. After the select query is called, it creates a “virtual” table where the data can be changed, but at no more than one record at a time.