DBMS

Question 1

What is the database

Answer 1

Database is a collection of logical related data that can allow easily and efficient storage retrieval and manipulation of data

Question 2

Advantages of database

Answer 2

Reduction in data redundancy means reduction in duplication of data and easy retrieval and reduction in data inconsistency and security and sharing and interactive interface

Question 3

Definition of Database Management System

Answer 3

Database management system is a computerised Record Keeping system whose purpose is to manage the data and make it available as but the requirement

Question 4

Types in which data can be organised

Answer 4

Flat file means data is stored in a single table relational file means data is stored in multiple tables

Question 5

Elements of database

Answer 5

Table is a collection of logically related records field represents one related part of table record is a collection of multiple data which is stored in related fields that can be treated as a single unit

Question 6

Relational database management system

Answer 6

It is a database that establishes a link between two or more tables of a database

Question 7

Object sofa database

Answer 7

Table it acts as a container which stores data to a single subject queries request to generate some information from tables is query forms are user friendly interface to add or update data in a table reports display the information in a format as per users need

Question 8

Key field and primary key and composite key and foreign key

Answer 8

Data between tables can be related on the basis of common field called as key field and primary key is a field which is used to uniquely identify records in a database and when there are more than one keys available to make primary key they are known as composite keys and primary key of 1 table is called foreign key in another table

Question 9

Relationship of tables types

Answer 9

121 relationship in this both the tables must have primary key columns and one to many relationships in this one of the tables must have primary key column that will be associated with all the columns of related tables and many to many relationships in this none of the associated tables have primary key column