Explain any 4 reasons why you need Authorization in DBMS

Explain why Distributed

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

 Give a suitable example.

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

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

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

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)

A Project relational algebra operator removes duplicates while returning results

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

A Lossless join and Dependency Preserving Decomposition means...