Find the minimum number of tables required for converting the following entity relationship diagram into a relational database.
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. 3
Explanation
R1 (with A, C) is one table and its multivalued attribute B needs its own table; R2 (X, Y) is a table, and the 1:M relationship R12 is folded into R2 as a foreign key. Three tables.
More Database Management Systems questions
- Two concurrent executing transactions 1 and T 2 are allowed to update same stock item say ' A ' in an uncontrolled manner. In such scenario…
- Minimal cover of functional F dependency set is
- Identify primary key of table with F functional dependency set
- Identify the normal form in which relation R belong to
- Identify the redundant functional dependency in F
- Assume that given table R is decomposed in two tables R (A, B, C) 1 with functional dependency set f = {A → B, A → C} 1 and R (A, D, E) FD…