Purpose of Data Base Managementt Systems

Data Base Management Systems

1. 06.01.2023 1 Dr.N.G.P Institute of Technology Coimbatore- 48 DATABASE MANAGEMENT SYSTEMS Unit- I RELATIONAL DATABASES Mr. T. RAJKUMAR,AP/IT

2. 06.01.2023 2

3. DATABASE SYSTEM SYSTEMS 06.01.2023 3 DATA Eg: 1, Jim , 30 INFORMATION DATABASE MANAGEMENT SYSTEM raw facts that provides no standalone meaning. - processed or organized or interrelated data. S.NO NAME SALARY/DAY 1 Jim 30 collection of interrelated data i.e., it contains information of an organization. Eg: student register, address book, dictionary - a system that consists of set of rules and procedures which helps to create, organize and manipulate the database.

4. 06.01.2023 4 HISTORY OF DBMS

5. 06.01.2023 5 PUZZLE Answer ????? 51

6. 06.01.2023 6 / DBMS - Data Base Management Systems Consists of 2 parts: Database Management system

7. 06.01.2023 7 WHAT IS A DBMS? Collection of interrelated data and a set of programs to access those data Goal of DBMS : To provide an environment that is both convenient and efficient to use for retrieving and storing database information.

8. 06.01.2023 8 GUESS ???? The purpose of database system….. Example - Facebook has a user database with which it authenticates users when they log into their Facebook account Formative Assessment 1

9. 06.01.2023 9 FILE SYSTEM SEQUENTIAL ACCESS DIRECT ACCESS Indexed ATTRIBUTES OF A FILE Name – only information kept in human-readable form • Identifier – unique tag (number) identifies file within file system • Type – needed for systems that support different types • Location – pointer to file location on device • Size – current file size • Protection – controls who can do reading, writing, executing • Time, date, and user identification – data for protection, security, and usage monitoring Information about files is kept in the directory structure, which is maintained on the disk

10. 06.01.2023 10 File management system (FMS): Used in earlier days First method to store data in a computerized manner The system stores permanent records in various files It needs different application programs to extract records from and add records to the appropriate files. Before database management systems (DBMSs) were introduced, organizations usually stored information in such systems.

11. 06.01.2023 11 DISADVANTAGES OF FMS Data redundancy and inconsistency Difficulty in accessing data Data isolation Integrity problems Atomicity of updates Concurrent access by multiple users Security problems Database systems offer solutions to all the above problems

12. 06.01.2023 12 NAME D.O.B Fees Amar 25.10.2002 Not Paid Subha 12.03.2010 Paid Shri 4.05.2000 Paid Amar 25.10.2002 Not Paid NAME D.O.B Fees Amar 25.10.2002 Not Paid Subha 12.03.2010 Paid Shri 4.05.2000 Paid Amar 25.10.2002 Not Paid DATA REDUNDANCY DATA INCONSISDENCY DATA REDUNDANCY Vs DATA INCONSISDENCY

13. DIFFICULTY IN ACCESSING DATA 06.01.2023 13 Conventional file processing environments do not allow needed data to be retrieved in a convenient and efficient manner. Eg., Bank officers need to find out the names of all customers s who live within the city’s 637410 zip code. DATA ISOLATION Data are scattered in various files, the files may be in different formats, writing new application programs to retrieve appropriate data is difficult.

14. ADVANTAGES OF DBMS 06.01.2023 14 Data independency Efficient data access Data integrity and security Data Administration Concurrent access and Crash recovery Reduced application development time

15. DATABASE APPLICATIONS 06.01.2023 15 Banking: all transactions Airlines: reservations, schedules Universities : registration, grades Telecommunications: calls made, monthly bills, balances Sales: customers, products, purchases Online retailers: order tracking, customized recommendations Finance: holdings, sales, purchase of bonds and stocks Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions Credit card transaction: purchases, monthly statements Databases touch all aspects of our lives

16. FORMATIVE ASSESSMENT 1 Q1 06.01.2023 16 Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a: data dictionary database management system (DBMS) decision support system relational database

17. 06.01.2023 17 Q2 Applications such as storing information about employees, salaries, payroll taxes, benefits and generation of pay checks are examples of: Sales On-line retailers Manufacturing Human resources

18. 06.01.2023 18 Q3 Applications such as management of supply chain, tracking production of items in factories, inventories of items in warehouses and stores are examples of: Sales On-line retailers Manufacturing Human resources

19. 06.01.2023 19 Q4 Applications such as storing information about holding, sales and purchase of financial instruments such as stocks and bonds are examples of: Banking Finance Manufacturing Human resources

20. 06.01.2023 20 Q5 Applications such as storing information about keeping record of calls made, generating monthly bills, maintaining balances on prepaid calling cards are examples of: A. Banking B. Telecommunications C. Manufacturing D. Human resources

21. 06.01.2023 21 MIND MAP