Fundamentals of Databases Assignment 1 -

Q1. Explain the distinction between total and partial constraints.

Q2. Explain the difference between a weak and a strong entity set.

Q3. Explain the distinction between disjoint and overlapping constraints.

Q4. Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. (Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.)

Fundamentals of Databases Assignment 2 -

Question 1: What do you understand by normalization?

Question 2: Convert following un-normalized table into normalized tables.

Question 3:

Consider the relational database of the above, where the primary keys are underlined. Give an expression in tuple relational calculus and Domain Relational Calculus for each of the following queries:

a. Find all employees who work directly for "STC".

b. Find all cities of residence of all employees who work directly for "STC".