Quiz Space

Database Management Systems · Quiz 1 · 23 Feb 2025 · January 2025 term

Question 5: Consider the following relations:\ auto_part(<u>pid</u>, …

Question 5

+4 marksOne correct option

Consider the following relations:
auto_part(pid, pname, color)
auto_suppliers(sid, sname, location)
catalog(pid, sid, price)

Consider the TRC expression:

{x∣∃s∈auto_suppliers ∃c∈catalog ∃p∈auto_part(s.location=‘Mumbai’∧c.price=5000∧x.sid=c.sid∧x.pname=p.pname∧s.sid=c.sid∧p.pid=c.pid)}\{x \mid \exists s \in auto\_suppliers\ \exists c \in catalog\ \exists p \in auto\_part(s.location = \textit{‘Mumbai’} \land c.price = 5000 \land x.sid = c.sid \land x.pname = p.pname \land s.sid = c.sid \land p.pid = c.pid)\}

Choose the correct DRC expression equivalent to the TRC expression shown above.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • A
See the whole paperTake it as a mock test

Question 5 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 23 Feb 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025). It carries 4 marks.

More questions from this paper

  1. Q1Which level of abstraction is responsible for providing data security by limiting access to specific data views?
  2. Q2Consider the relation student shown in Table 5. | roll_no | name | house_name | |---|---|---| | 1 | John | Nilgiri | | …
  3. Q3Consider the tables Products and Suppliers given below: | P_ID | P_Name | S_ID | |---|---|---| | 1 | Laptop | 3 | | 2 |…
  4. Q4Consider a relational database for Formula One Racing containing the following tables. | D_ID | D_Name | T_ID | Points …
  5. Q6Figure question
  6. Q7Figure question
  7. Q8Figure question
  8. Q9Figure question
  9. Q10Consider the following Students table | student_id | name | grade | marks | |---|---|---|---| | 1001 | Alice | A | 85 |…
  10. Q11Consider relations Book and Author shown in Table 6 and Table 7 | BookID | Title | AuthorID | Genre | |---|---|---|---|…
  11. Q12Consider the tables student and course as shown below. | ID | name | dept_name | |---|---|---| | 21f11 | Ram | CS | | 2…
  12. Q13In the Enrollment table, which of the following is a typical way to handle the primary key?
  13. Q14In a typical design, what is the relationship between the Student table and the Enrollment table?