Q100.Marks: +2.0UGC NET Paper 2: Computer Science 18th June 2024 Shift 1 (Cancelled)
📄 Passage
Answer the following 5 questions based on the passage.
A company is implementing a new database system to manage its customer information. The database contains 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 representatives who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.
Based on the passage, which of the following statements is true ?
1.Each customer can place only one order.
2.Each sales representative can manage multiple customer accounts.✓ Correct
3.Each order can be assodiated with only one product.
4.The database does not include a table for products.
Solution
The correct answer is Each sales representative can manage multiple customer accounts..
Key Points
Option 2 is correct because it states that each sales representative can manage multiple customer accounts, which indicates a one-to-many relationship between sales representatives and customers.
Additional Information
Option 1: This statement is incorrect because it suggests that each customer can place only one order, which is typically not the case in most business scenarios.
Option 3: This statement is incorrect as it implies that each order can be associated with only one product, which is unlikely since orders often contain multiple products.
Option 4: This statement is incorrect because the database usually includes a table for products to manage inventory and sales.