DATABASE MANAGEMENT SYSTEM

The relational model feature is that there

• (i) is no need for primary key data
  (ii) is much more data independence than some other database models
  (iii) are explicit relationships among records
  (iv) are tables with many dimensions

Which of the following is generally used for performing tasks like creating the structure of the relations or deleting relations?

• (i) DML
• (ii) Query
• (iii) Relational schema
• (iv) DDL

What do you mean by one-to-many relationships?

• (i) One class may have many teachers
• (ii) One teacher can have many classes
• (iii) Many classes may have many teachers
• (iv) Many teachers may have many classes

A Database Management System is a type of __________ software.

• (i) It is a type of system software
• (ii) It is a kind of application software
• (iii) It is a kind of general software
• (iv) Both (i) and (ii)

Which key cannot be null

• (i) Unique key
• (ii) Primary key
• (iii) Super key
• (iv) Foreign key

Which of the following refers to the “data about data”?

• (i) Directory 
• (ii) Warehouse 
• (iii) Sub Data 
• (iv) Meta Data

Which of the following is not an example of DBMS?

• (i) MySQL 
• (ii) Microsoft Access 
• (iii) IBM DB2 
• (iv) Google

Which of the following is known as a set of entities of the same type that share same properties or attributes?

• (i) Relation set 
• (ii) Tuples 
• (iii) Entity set 
• (iv) Entity relation model

List five responsibilities of the database manager. For each responsibility, explain the problem that would arise if the responsibility were not discharged.

Illustrate the database characteristics, How they are different from File systems.

Draw and explain three level architecture of database system.

Consider a two-dimensional integer array of size name that is to be used in your favourite programming language. Using the array as an example, illustrate the difference (i) between the three levels of data abstraction and (ii) between a schema and instances.

Construct an E-R diagram for a car insurance company that has a set of customers, each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents..

Define a database and explain its importance in modern software systems.

Distinguish strong entity set with weak entity set. Draw an E-R diagram to illustrate weak entity set.

What are DDL and DML? Explain with the help of examples.

Illustrate disadvantages of file processing systems.

Explain three levels of data abstraction.