DATABASE DESIGN FOR LIBRARIES

• Traditional File Processing – The traditional approach to information systems design focuses on data processing needs of individual departments in the organization. In file system approach, each user defines and implement needed files for a specific application to run
• Database Approach - Emphasizes the integration and sharing of data throughout the organization

   
• DBMS – A general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications. It stores data in such a way that it becomes easier to retrieve, manipulate, and produce information
• Enterprise Data Model – A map or graphical model that shows the entities and the relationship among them
• ERP – A company-wide computer software system used to manage and coordinate all the resources, information, and functions of a business from shared data stores
• ERP - A term originally derived from manufacturing resource planning (MRP II) that followed material requirements planning (MRP)
• Relational Databases – Database technology involving tables (relations) representing entities and primary / foreign keys representing relationships
• Database Applications – It is an application program (or set of related programs) that is used to perform a series of activities on behalf of database users
• Personal Databases – These are designed to support one user. They have long resided on personal computers (PCs), including laptops
• Workgroup Databases - is a relatively small team of people who collaborate on the same project or application or on a group of similar projects or applications
• Workgroup Databases - typically comprises fewer than 25 persons
• Department Databases - A department is a functional unit within an organization
• Department Databases - Generally larger than a workgroup (typically 25-100 persons) and is more responsible for a more diverse range of functions
• Enterprise Database - A database whose scope is the entire organization or enterprise (or, at least many different departments)
• Enterprise Database - These databases are intended to support organization wide operations and decision making
• Internet – represents a global collection of heterogeneous networks connecting hundreds of thousands of computer networks, millions of nodes and tens of millions of users. The internet enables us to access information from nearly anywhere in the world directly and conveniently
• Intranet – use of Internet protocols to establish access to company data and information limited to the organization
• Extranet – a network connection to non-company entities that are not accessed via an internet connection