Quiz Space

Database Management Systems · Quiz 1 · 19 Jul 2026 · May 2026 term

Question 4: Create a table Assignment(AssignID, PilotID, FlightNo, Da…

Question 4

+4 marksOne correct option

Create a table Assignment(AssignID, PilotID, FlightNo, Date) with the following criteria that must be satisfied: • Every assignment must have a unique AssignID. • Each pilot can only be assigned to a specific flight once on any given date. • Pilots may share the same flight number on different dates. Which of the following SQL queries can be used to correctly create the table Assignment?

  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D
    Figure from the original question paper
Show answer

Correct answer

  • C
    Figure from the original question paper
See the whole paperTake it as a mock test

Question 4 of 16 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 19 Jul 2026, in the May 2026 term (Database Management Systems 16 Jul 26). It carries 4 marks.

More questions from this paper

  1. Q1Which of the following components of the Database Management System (DBMS) is primarily responsible for generating and …
  2. Q2Consider the relation Delivery_Fee:
  3. Q3Consider the following SQL statements are executed in sequence on a newly created table Shipment:
  4. Q5Figure question
  5. Q6Consider the relational schemas Pilot, Aircraft_Type and Certified:
  6. Q7Consider the following relational schema for a movie database:
  7. Q8Consider two relations R(A, B) and S(B, C). Which of the following SQL queries is/are logically equivalent to the Relat…
  8. Q9Consider the Entity-Relationship (ER) diagram below representing an organization’s logical schema of their database:
  9. Q10Consider the following two relations and
  10. Q11Suppose relation R(A,B,C,D) has candidate keys: {A,B} and {A,C}. How many distinct superkeys does relation R have?
  11. Q12Let R(A,B) = {(1,2),(2,3),(3,4)} and S(B,C) = {(2,5),(3,6)}. Find the number of tuples in .
  12. Q13Consider the following three tables:
  13. Q14Consider an EER model in which Person is a supertype entity type. Two subtype entity types, Employee and AccountHolder,…
  14. Q15Consider two relations R(A,B) and S(B). Relation R contains 10 tuples and relation S contains 2 tuples. Both relations …
  15. Q16Consider the following Employee table: