- Slides: 9
Database A database is a structured collection of records or data that is stored in a computer system so that a computer program or person can easily retrieve and manipulate the data using a query language.
Database Management System [DBMS] • A database management system (DBMS) I computer software designed for creating and maintaining databases and allows users to retrieve information from that database. • MS Access
Relational Database Management System[RDBMS] • A type of DBMS in which the database is organized and accessed according to the relationships between data values. It is based on the relational model. • Oracle, MS SQL Server,
Database Model • A database model is a theory or specification describing how a database is structured and used. Three types of Data models are… • Hierarchical Model • Network model • Relational Model
Hierarchical Model • Hierarchical data model organizes data in a tree structure, hierarchy is of parent and child data segments. • Hierarchical model structures data as a tree of records, with each record having one parent record and many children
Network Data Model • Network data model organize data as a network and the network model allows each record to have multiple parent and child records.
Relational Data Model A relational database allows the definition of data structures, storage and retrieval operations and integrity constraints. In such a database the data and relations between them are organized in tables.
Database Object Table is a database object or structure where the data is stored. A table will contains rows and columns. A row in a table is called 'tuple' and the column in the table is called 'Attribute'.