Illustrate the traditional file based applications problems and database solutions to these problems.
- Modelling the reel world information within file based approach.
- Response to change organization continuously.
- Application system development costs.
- Date protection of data sharing.
Definitions:
- Database: is basically just a computerized record keeping system.
- Data Base Management System: it’s a data model, number of uses supported by the system, number of sites.
- Database Security: Can the prevention of unauthorized access to the data.
- Data definition language (DDL): Which superstition of database objects.
- Data manipulation language (DML): Which support manipulation of database.
- Data reliability: relates to the protection of data against unexpected loss or damage.
- Data integrity: relations to the maintenance of high quality consistent & up to data
- Data Administration: A person responsible for the overall control of the system at the technical level.
- Database view: A database view is a subset of a database and is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save frequently used, complex queries.
- Data Independence: is the type of data transparency that matters for a centralized DBMS. It refers to the immunity of user applications to changes made in the definition and organization of data.
Sketch architecture of a database system and define all the terms used.