Similarly, it is useful for retrieving data from database using queries. o By controlling the data redundancy, you can save storage space. Sometimes, it is necessary to create duplicate copies of the same data items in order to relate tables with each other. o In DBMS, the data redundancy can be controlled or reduced but it is not removed completely. Advantages of DBMS The DBMS (Database Management System) is preferred ever for the conventional file processing system due to the following advantages: o Minimal data Redundancy o Data consistencyĦ Database Management Systems 6 o Integration of data o Sharing of data o Enforcement of standards o Ease of application development Uniform security,privacy and integrity o Data independence Minimal data Redundancy o Redundancy means repetition or duplication of data. RDBMS also provide relational operators to manipulate the data stored into the database tables. RDBMS stores the data into collection of tables, which might be related by common field of database table columns. : FoxPro Relational Database Management System (RDBMS) RDBMS stands for Relational Database Management System. In other words, it is a collection of programs that enables us to store, modify, and extract information from a database.
Database Management System (DBMS) It is software that defines a database, stores the data, supports a query language, produces reports, and creates data entry screens. o Database also needed to build computerized business applications, to create business applications that operate in multiple locations, to conduct business on the internet and also to enable customers to place orders using the web. All should be able to work with the same set of data. o We need a database, to share data of all kinds between users (except for very small systems), between tools working on them, and usually between different computers.
o Several users and/or several tools must be able to safely access the same data concurrently by using the database. We need persistent storage and storage must be reliable. Database Applications o Banking: all transactions o Airlines: reservations, schedules o Universities: registration, grades o Sales: Customers, products, purchases o Manufacturing: production, inventory, orders Why do we need a Database? o Database has an availability of a storage system, the most obvious of these being persistence. A database also represents some aspects of the real world, sometimes called the mini-world or the Universe of Discourse (UOD). Data is a collection of raw information and information is a collection of processed data. Introduction to Database A database is a collection of inter related data items that can be processed by one or more application systems.