IGNOU Assignments - CS06 - Introduction to DBMS - CS06 - BCA(4)-06/TMA/06

Course Code : CS-06

Assignment Number : BCA(4)-06/TMA/06

Maximum Marks: 10

Last Date of Submission : 15^th April, 2006

This is a Tutor Marked Assignment. There are five questions in this Assignment. Answer all the questions. All questions carry equal weightage. You may use illustrations and diagrams to enhance explanations.

Question 1: Discuss the advantages and disadvantages of Object Oriented Relational Database Management System in comparison with RDBMS. For each type, mention any two commercial applications.

Question 2: Describe the main characteristics of the database approach in contrast with the file-based approach.

Question 3: Explain how the Enhanced-ER diagrams help to produce a more structured relational database design environment with a suitable example.

Question 4: Describe the main aims of the conceptual, logical and physical database design phases.

Question 5: The following tables form part of a database held in a relational DBMS:

Hotel (Hotel_No, Name, Address)
Room (Room_No, Hotel_No, Type, Price)
Booking (Hotel_No, Guest_No, Date_From, Date_To, Room_No)
Guest (Guest_No, Name, Address)

where Hotel contains hotel details and Hotel_No is the primary key Room contains room details for each hotel and (Hotel_No, Room_No) forms the primary key.

Booking contains details of the bookings and the primary key comprises (Hotel_No, Guest_No, Date From) and Guest contains guest details and Guest_No is the primary key.

Write the SQL statements for the following:

1. List full details of all hotels in Mumbai.
2. List the names and addresses of all guests in New Delhi, alphabetically ordered by name.
3. List all double or family rooms with a price below Rs.800 per day, in ascending order of price.
4. List the bookings for which no date to has been specified.
5. What is the total daily revenue from all the double rooms?
6. How many different guests have made bookings for August, 2006?
7. List the price and type of all rooms at the hotel Land Mark.
8. What is the total income from bookings for the hotel Manor today?