Downloaded 144 times
Database management system basic, database, database management, learn database, database system
A database is a collection of interrelated data used to answer user questions, while a Database Management System (DBMS) is software for creating and managing these databases. DBMS offers advantages such as data retrieval efficiency, safety, and reduction of redundancy and inconsistency. It operates on three levels of data abstraction: physical, logical, and view level, ensuring data integrity and independence, while supporting multiple applications and users.
In this document
Powered by AI
Overview of databases and database management systems (DBMS) defined.
Discusses the efficiency, safety, and reliability provided by data management systems.
Examples of DBMS applications in various fields including banking, airlines, universities, credit cards, sales, and HR.
Highlights key issues such as redundancy, access difficulty, data isolation, integrity, and security.
Explains the three levels of data abstraction: physical, logical, and view levels in databases.
Benefits of reducing redundancies, eliminating inconsistencies, ensuring integrity, and enabling data sharing.
More Related Content
Similar to Database management system basic, database, database management, learn database, database system
Database management system basic, database, database management, learn database, database system
- 1.
- 2. BASIC CONCEPTS 1. Whatis a database? A database is a collection of interrelaated data which can be used: • alone, or • combined / related to other data to provide answers to the user’s question. 2.What is Database Management System? A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.
- 3. 1. Retrieve datathat are both convenient and efficient 2. Safety of information stored in DBMS . 3. Avoid possible anomalous result.
- 4. a) BANK :Forcustomer ,informaion , account,and loans, and transaction. b) Airline: For reservation and schedule information. Airline were among the first to use database in a geographically distributed manner terminals situated around the world accessed the central database system through phone lines and other data network. c) Universities: For students information, course registration, and grades. d) Credits card transaction: For purchases on credits cards and generation of monthly statements. e) Sales: For customer, product, and purchase information. e) Human resources: For information about employees, salaries, payroll taxes and benefits, and for generation of paychecks.
- 5. a) Data redundancyand inconsistency b) Difficulty in accessing data c) Data isolation d) Integrity problems e) Atomicity problems f) Concurrent-access anomalies g) Security problems
- 6. 1 DATA ABSTRACTION •Physical Level: The lowest level of abstraction describeshow the data are actually stored. • Logical Level: The next –higher level of abstraction describes what data are actually stored in the database, and what relationship exist among those data. • View Level: The highest level of abstraction describes only part of the entire database.
- 7. View of data View1 View 2 View n Logical level Physical level
- 8. * Reduction ofRedundancies: Centralized control of data by the DBA avoids unnecessary duplication of data and effectively reduces the total amount of data storage required. *Elimination of Inconsistencies: The main advantage of avoiding duplication is the elimination of inconsistencies that tend to be present in redundant data files.
- 9. * Integrity: Centralizedcontrol can also ensure that adequate checks are incorporated in the DBMS to provide data integrity. *Data Independence: Data independence is usually considered from two points of view: physical data independence and logical data independence. *Shared Data: A database allows the sharing of data under its control by any number of application programs or users