DATABASE MANAGEMENT — Summer 2018

In DBMS what D Stands for 1. A. Dependency B. Distribution C. Data D. Direct 2. In E-R Diagram, what is the symbol of Entity? A. Rectangle B. Diamond C. Circle D Eclipse 3. DQL Stands for A. Direct Query B. Dependency Queuing Language Language C. Data Query Language D. Distribution Queuing Language 4. What is the use of Insert Command in SQL A. To Insert the records B. To Modify the records C. To Remove the D. To retrieve the records records 5. ______ Key is work as reference of another table A. Primary B. Foreign C. Composite D. Candidate 6. If user has inserted Birthdate as an attribute in his entity, the age is considered as ________ attribute A. Strong B. Weak C. Simple D. Derived

Define: i. Metadata ii. Foreign Key iii. Composite Attribute iv. Commit

List out the Database Models and Explain any one in brief.

What is the need of Database system? Explain its usefulness with suitable example.

What do you mean by Entity and Attributes? Discuss any three types of attributes with suitable example. OR1

What do you mean by Instance and Schema? Explain with suitable example.

Mr. Xwants to develop an online furniture shop where the customer can register and make request for the furniture product by the different categories and can also place an order as per the need. Customer can also make payment via online or offline ways. Draw an Entity Relationship diagram for the above problem.

Discuss : Candidate Key and Primary Key

Discuss DML in brief.

Mr. Amar wanted to develop a hotel management system, where customer can register and also able to find whether the hotel or table is available or not on specified date. Customer can also able to book table on the specified date and also able to pay for the same through online payment mode. Customer can able to give feedback for the hotel or services only if the user has booked. Draw an E-R Diagram for the above problem.

Discuss the use of Select Statement in brief.

Discuss Data Independence with its different types.

How strong entity plays a significant role in E-R diagram? Explain with suitable example.

Discuss OLAP in brief.

The railway reservation system facilitates the passengers to enquire about the trains available on the basis of source and destination, booking and cancellation of tickets, enquire about the status of the booked ticket, etc. The aim of case study is to design and develop a database maintaining the records of different trains, train status, and passengers. The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, total number of seats available, and number of seats already booked. The database has been developed and tested on the Oracle.

Draw an E-R Diagram for Online Movie Booking System.