Database Database A database is a structured collection

  • Slides: 9
Download presentation
Database

Database

Database A database is a structured collection of records or data that is stored

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

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

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 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

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 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

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.

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'.