DBMS · Question 22 · Medium
DBMS question 22
A one-to-many relationship 'works in' links Department (one) to Employee (many). When it is mapped to relational tables, where is the foreign key normally placed?
- In the Employee table, referring to the Department's primary key
- In the Department table, referring to the Employee's primary key
- In a separate table that is always required for every 1:N relationship
- In both tables, each referring to the other
Answer and explanation
Answer: A. In the Employee table, referring to the Department's primary key
Explanation: Each employee works in exactly one department, so a single dept_id column in Employee captures the relationship. Placing it in Department would need many values per row.
Previous: Relation R(A, B, C, D, E) has the functional dependencies A → B, BC → D and D… · Next: Relation R has 3 attributes and 5 tuples, and relation S has 4 attributes and…
Practise dbms
Try a fresh set of dbms questions with an explanation after every answer, free and without signing up: DBMS practice. Or sit a full placement mock test.
More dbms questions
- In an ER diagram (Chen notation), how is a multivalued attribute such as a…
- Which data model stores data as tables (relations) made of rows and columns?
- Relation R(A, B, C, D, E) has the functional dependencies A → B, BC → D and D…
- Relation R has 3 attributes and 5 tuples, and relation S has 4 attributes and…
- Relation R(A, B, C, D) has the functional dependencies AB → CD and B → C, and…
- A sparse (non-dense) index has an entry for only some of the search-key…
- Changing the internal storage of a database, for example adding an index or…
- Relation R(A, B, C, D) has the functional dependencies A → B, B → C and C → A…
- Relation R(A, B, C, D, E) has exactly two candidate keys, A and B. How many…
- Consider the schedule S: w1(X), r2(X), w2(Y), c2, c1, where ri, wi and ci are…
More technical & programming practice
SQL · Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming
LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge