Library Database management system

Database, Information knowledge,

1. LIBRARY DATABASE MANAGEMENT SYSTEM Dheeraj Singh Negi

2. INTRODUCTION: What is Database? What is Database management system?

3. Distributed vs. Centralized Centralized database can produce a bottleneck Large volume of data input Large database Large volume of queries In distributed databases, data consistency, replication, and retrieval can be more problematic Consistency of schemas Retrieval in case the data location is not known Communication overhead to ensure database consistency

4. ADVANTAGES: Controlling Redundancy Integrity can be enforced Inconsistency can be avoided Maintains privacy

5. DISADVANTAGES: Complexity Size Performance Cost

6. Hierarchical Structures Relationships between records form a hierarchy or treelike structure Relationship is one-to-many

7. Network Structure Many-to-many Data element can be accessed by following one of several paths

8. Relational Structure Stored in the form of two-dimensional tables Links various files to provide information

9. Relational Operations Select operation, to create a subset of records that meet a states criterion Join operation, combines two or more tables Project operation, subset of columns

10. Object-oriented Structure Handles complex data like graphics, text, voice Supports inheritance Helps in creating product designs

11. DBMS ARCHITECTURE

12. LIBRARY DATA BASE MODULES

13. SYSTEM CONFIGURATION Hardware Specification Software Specification

14. Hardware Specification PROCESSOR : PENTIUM IV 3.0 GHz  MOUSE : PS/2 Optical Mouse  MEMORY : 256 MB RAM HARD DISK : 40GB MONITOR : SAMSUNG  KEYBOARD : MERCURY (104 keys).

15. Software Specification FRONT END : VISUAL BASIC 6.0 BACK END : MS Access PLAT FORM : WINDOWS XP

16. Data Flow Diagram

17. USER LOGIN USER TABLES NEXT PAGE Step-1 :

18. Step-2 LIBRARY BOOK DETAILS BOOK DB SELECTING BOOK STUDENT

19. STUDENT BOOKSEARCH USER TABLES BOOK AVAILABLE BOOK NOT AVAILABLE Step-3 :

20. STUDENT STUDENT DETAILS STUDENT DB BOOK RETURN Step-4 : BOOK DB

21. Data Base Design

22. Table Name: Book Details Field Name Type Name Book No Number Book Name Text Author Name Text Edition Text

23. Table Name: Student Details Field Name Type Name Student ID Number Hold Text Return Text Fine Number