Use these filters to find papers

B.TECH 5th sem Database Management Systems paper 2017

UniversityGGSIPU, New Delhi
CourseB.TECH
Semester5
SubjectDatabase Management Systems
Year2017
Downloads10
Uploaded By User Image
Sourabh Bajaj
200
 
  Question Marks
0
requests

(a) Explain the difference between a weak and a strong entity set with an example, We can convert any weak entity set to a strong set by simply adding appropriate attributes. Why, then, do we have a weak entity sets? Give examples. 

This question has 0 answers so far.
6
0
requests

(b) List the ACID properties. Explain the usefulness of each.

This question has 0 answers so far.
6.5
0
requests

A database represents each AIRPORT, keeping its unique AirportCode,the AIRPORT Name, and the City and State in which the AIRPORT is located 

(a) Each airline FLIGHT has a unique number, the Airline for the FLIGHT, and the Weekdays on which the FLIGHT is scheduled (for example, everyday of the week except Sunday can be coded as X7).

(b) A FLIGHT is composed of one or more FLIGHT LEGs (for example, flight number co1223 from New York to Los Angeles may have two FLIGHT LEGs: leg 1 from New York to Houston and leg 2 from Houston to Los Angeles). Each FLIGHT LEG has a DEPARTURE AIRPORT and Scheduled Departure Time, and an ARRIVAL AIRPORT and Scheduled Arrival Time.

(c) A LEG INSTANCES is an instance of a FLIGHT LEG on a specific Date (for example, C01223 leg 1 on July 30, 1989). The actual Departure and Arrival AIRPORTs and times are recorded for each flight leg after the flight leg has been concluded. The Number of available seats and the AIRPLAN used in the LEG INSTANCE are also kept.

(d) The customer RESERVATIONS on each LEG INSTANCE include the Customer Name, Phone, and Seat Number(s) for each reservation.

(e) Information on AIRPLANES and AIRPLAN TYPEs are also kept. For each AIRPLAN TYPE (for example, DC-10), the TypeName, manufacturing Company, and Maximum Number of Seats are kept. The AIRPORTs in which planes of this type CAN LAND are kept in the database. For each AIRPLANE, the Airplane Id, Total number of seats, TYPE are kept.

(i) Draw an E-R diagram.

(ii) Map E-R diagram to Relational model.

This question has 0 answers so far.
12.5
0
requests

(a) Discuss insertion, deletion and modification anomalies. Why are they considered bad? Illustrate with examples.

This question has 0 answers so far.
6.5
0
requests

b) Why should NULL in a relation be avoided as much as possible? *Discuss the problem of spurious tuples and how we can prevent it.

This question has 0 answers so far.
6
0
requests

(a) What are the difference among primary, secondary, and clustering indexes? How do these differences affect the ways in which these indexes are implemented? Which of the indexes are dense, and which are not? 

This question has 0 answers so far.
6.5
0
requests

(b) What is meant by cost-based query optimization? Discuss the cost components for a cost function that is used to estimate query execution cost. 

This question has 0 answers so far.
6
0
requests

(a) What is a serial schedule? What is a serializable schedule? Why is a serial schedule considered corrent? Why a serialitzable schedule is considered correct? 

This question has 0 answers so far.
6.5
0
requests

(b) What is the two-phase locking protocol? How does it guarantee serializability? 

This question has 0 answers so far.
6
0
requests

(a) Discuss the problems of deadlock and starvation, and the different approaches to dealing with these problems.

This question has 0 answers so far.
6.5
0
requests

(b) What is a functional dependency? What are the possible sources of the information that defines the functional dependencies that hold among the attributes of a relation schema? 

This question has 0 answers so far.
6
0
requests

Consider the employee database of Figl., where the primary keys areunderlined. Give an expression in SQL for each of the following queries.

         employee (employee_name, street, city)

         works (employee_name, company name, salary)

         company (company name, city)

         manages (employee_name, manager name)

(a) Find the names and cities of residertce of all employees who work for "First Bank Corporation. Find the names, street addresses, and citics of residence of all employees who work for "First Bank Corporation" and earn more than $10,000.

(b) Find all employees in the database who do not work for "First Bank Corporation."

(c) Find all employees in the database who earn more than each employee of "Small Bank Corporation."

(d) Assume that the companies may be located in several cities. Find all companies located in every city in which "Small Bank Corporation" is located.

(e) Find the company that has the most employees. 

(f) Find those companies whose employees earn a higher salary, on average, than the average salary at "First Bank Corporation."


This question has 0 answers so far.
12.5
0
requests

Differentiate between the following:

(a) Physical and logical data independence

This question has 0 answers so far.
5
0
requests

Differentiate between the following:

(b) Distributed database and object oriented databse

This question has 0 answers so far.
5
0
requests

Differentiate between the following:

(c) Primary key, candidate key and superkey

This question has 0 answers so far.
5
0
requests

Differentiate between the following:

(d) Closed and open hashing

This question has 0 answers so far.
5
0
requests

Differentiate between the following:


This question has 0 answers so far.
5
Chat with us