A company is consuming parts in the manufacturing of other products. Each of the part is either manufactured within the company or purchased from the external suppliers or both. For each part, partnumber, partname is maintained. Attribute batchnumber is maintained if the consumed part is manufactured in the company. If part is purchased from external supplier, then supplier name is maintained. Which of the following constraints need to be considered when modelling class/subclass concepts in ERD for the given problem.
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Total specialization and overlapping constraints
Explanation
Every part is manufactured or purchased (total specialization), and a part can be both (overlapping).
More Database Management Systems questions
- A transaction may be in one of the following states during its execution life cycle in concurrent execution environment. A. FAILED B. TERMI…
- Which of the following is used to create a database schema?
- The data node and name node in HADOOP are
- Consider a relational schema S = (U, V , W, X, Y , Z) on which the following functional dependencies hold: {U → V , V W → X, Y → W, X → U}…
- In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if (A) At least one of the oper…
- Match List I with List II.