Describe any 4 concepts associated with Distributed Database systems

Explain why Distributed

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

 Give a suitable example.

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?

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)

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...

A Candidate key is a Subset of Super key