What is a

Stored Procedure in DBMS? What advantages does it provide over a normal SQL query?

Explain why Distributed

Systems only achieve either Consistency or Availability but not both at the same time.

 Give a suitable example.

Answer in one line:  What is the core principle of relational schema design?

Answer in one line: What is a Theta join relational algebra operator?

Write FD Closure for the following relational schema:

Customer (Cust ID, Name, DOB,  Bank A/c No, Branch ID, Branch Name, Branch Location, Cust_PAN_No, Cust_AadharNo, Cust_KYC)

Here is a sample relational schema design for a travel booking system

CUSTOMER (customer_id PK, name, email, phone)

BOOKING (booking_id PK, customer_id FK, trip_id FK

          booking_date, booking_status, number_of_passengers, total_price )  

TRIP ( trip_id PK, destination_id FK, accommodation_id FK, 

          departure_date,  return_date, trip_name, description, itinerary )  

DESTINATION ( destination_id PK, country, city, region)

ACCOMMODATION (accommodation_id PK, hotel_name, address, room_type, star_rating )

PAYMENT (payment_id PK, booking_id FK, payment_date, float amount, payment_method)

PK = Primary Key, FK = Foreign Key

Write SQL Statements for following use-cases:

1.  List all customers who have booked travel to 'London' 

2.  List destinations with 4-star accommodations

3.  List customers who have booked their travel using payment method "Credit Card" and whose amount is more than 100,000

A Lossless join and Dependency Preserving Decomposition means...

A Candidate key is a Subset of Super key

Explain the steps in Relation Database Schema Design with a brief explanation of activities in each step.

Identify problems in the given relational schema design and how will you fix them?

Write the problems you have identified and then Write down your new schema design. (Just the table names and attributes is fine)