Directions (Q96–100): A company is implementing a new database to manage customer information. It holds tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representative who manages the account. The design aims to improve tracking of sales and customer interactions.
Which of the following best describes the relationship between the "orders" table and the "Customers" table in the company's database system?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. Many-to-One
Explanation
Many orders belong to one customer, so orders-to-customers is many-to-one.
More Database Management Systems questions
- Match List - I with List - II.
- Find the number of tuples obtained by applying the right outer join X ⟖ (X.S = Y.S) Y.
- The result of the operation X ⟖ (X.S = Y.S) Y (right outer join) will be:
- Which of the following join is used to get all the tuples of relation X and Y with Null values of corresponding missing values?
- Number of tuples by applying right outer join on relation X and Y is/are :
- Let R(A, B, C, D) be a relational schema with dependencies A → B, B → C, C → D and D → B. The decomposition of R into (A, B), (B, C), (B, D…