Please scroll down to get to the study materials.
Data: Data are the facts or figures obtained from various sources.
Information: Information is the processed data.
Table: A database object comprising of related data entries is known as a table. Data present in a table is displayed in the form of rows and columns.
Field: A field is a piece of information about an element which may be a person, student or employee.
Record: A collection of related field is called record.
Cell: A cell is an intersection of rows and columns.
Data redundancy: Data redundancy means the repetition of data in a database.
Relational Database: A Database Management System that stores data in the form of related tables is known as a relational database.
Database model: A database model is the manner in which the data collection is stored, managed and administered.
Relationship: It is a link or association between several entries. Following is the list of different types of relationship
A primary key is the field that uniquely identifies in a table. Each record in the table must be unique. Every table has only one primary key. There are two types of primary keys as follows.
A data type specifies the type of data that a field can hold. It is a form of storage which allows entry of previously defined values that each field can store. Some example of data types are as follows:
Database is a collection of data organized to service many applications at the same time by storing and managing data so they appear to be at one location.
list of different types of relationship are:
Some example of data types are as follows:
A relational database management system is defined as the database management system that stores data in the form of related tables.
A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records.