Introduction to databases | kullabs.com
Notes, Exercises, Videos, Tests and Things to Remember on Introduction to databases

Please scroll down to get to the study materials.

Registration open for Special Discounts

Note on Introduction to databases

Registration open for Mr and Miss SEE
  • Note
  • Things to remember
  • Videos
  • Exercise
  • Quiz

What is database?

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.

Definition of some terms used in database

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

  • One to one e.g: Driver and car
  • One to many e.g: Teacher and students
  • Many to many e.g: Books and readers
  • Many to one e.g: Students and school

Primary key

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.

  • Compound (Composite key): A compound key is a key that consists of multiple columns because one column is not sufficient.
  • Foreign key: A foreign key is the linking pin between two tables.

Data Type

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:

  • Text Data Type
  • Numeric Data Type
  • Date Data Type

Objectives of Database

  • Elimination of data redundancy.
  • Share data among all users.
  • Incorporate changes easily and quickly.
  • Simplify the use of data files.
  • Lower the cost of storing and retrieving data
  • Improve accuracy and consistency.
  • Provide data security from unauthorized access and use
  • Exercise center control over standards.
  • Get persist-ency in data.

  • 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.
  • A database object comprising of related data entries is known as a table.
  • A Database Management System that stores data in the form of related tables is known as a relational database.
  • A database model is the manner in which the data collection is stored, managed and administered.
.

Very Short Questions

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:

  • One to one e.g: Driver and car
  • One to many e.g: Teacher and students
  • Many to many e.g: Books and readers
  • Many to one e.g: Students and school

The objectives of database are:

  • Elimination of data redundancy.
  • Share data among all users.
  • Incorporate changes easily and quickly.
  • Simplify the use of data files.
  • Lower the cost of storing and retrieving data
  • Improve accuracy and consistency.
  • Provide data security from unauthorized access and use
  • Exercise center control over standards.
  • Get persist-ency in data.

Some example of data types are as follows:

  • Text Data Type
  • Numeric Data Type
  • Date Data Type

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.

0%
  • _____ is a link or association between several entries.

    Database model

    Relationship

    Record

    Table

  • ______ is an intersection of rows and columns.

    Cell
    Field

    Table

    Record

  • ______ is the field that uniquely identifies in a table.

    Relationship

    Record

    Primary Key

    Datatype

  • Which key is the linking pin between two tables?

    Foreign key

    Compound Key

    Both B and C

    Composite key

  • ______ is a piece of information about an element which may be a person, student or employee.

    Field
    Record

    Table

    Data

  • You scored /5


    Take test again

DISCUSSIONS ABOUT THIS NOTE

No discussion on this note yet. Be first to comment on this note