Entity Relationship Diagram MCQs For Gate Exam
Question 1:
Which type of attribute is ‘full name’ in an ER model?
A) multivalued
B) composite
C) key
D) derived
Detailed Solution:
The correct answer is B) composite. Composed of first, middle, last names.
Question 2:
Which type of attribute is ‘phone number’ in an ER model?
A) multivalued
B) simple
C) derived
D) key
Detailed Solution:
The correct answer is A) multivalued. A person can have multiple phone numbers.
Question 3:
In an ER diagram, a derived attribute is represented by:
A) a hexagon
B) a triangle
C) a dashed line
D) a dashed ellipse
Detailed Solution:
The correct answer is D) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 4:
Consider an ER model with Book and Hospital entities. There is a 1:M relationship between Book and Hospital. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) 1
C) 4
D) 2
Detailed Solution:
The correct answer is D) 2. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For 1:M relationship, can merge, no extra.
Question 5:
Which type of attribute is ’employee ID’ in an ER model?
A) derived
B) key
C) simple
D) multivalued
Detailed Solution:
The correct answer is C) simple. It’s a single atomic value.
Question 6:
Consider an ER model with Driver and Hospital entities. There is a 1:M relationship between Driver and Hospital. Driver has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 2
B) 3
C) 5
D) 4
Detailed Solution:
The correct answer is B) 3. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 1. For 1:M relationship, can merge, no extra.
Question 7:
In an ER diagram, a derived attribute is represented by:
A) a dashed line
B) a triangle
C) a dashed ellipse
D) a circle
Detailed Solution:
The correct answer is C) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 8:
Which type of attribute is ’employee ID’ in an ER model?
A) simple
B) derived
C) multivalued
D) composite
Detailed Solution:
The correct answer is A) simple. It’s a single atomic value.
Question 9:
In an ER diagram, a relationship is represented by:
A) a diamond
B) a triangle
C) a dashed line
D) an arrow
Detailed Solution:
The correct answer is A) a diamond. Relationships connect entities and are shown as diamonds.
Question 10:
Which type of attribute is ‘full name’ in an ER model?
A) derived
B) simple
C) key
D) composite
Detailed Solution:
The correct answer is D) composite. Composed of first, middle, last names.
Question 11:
Consider an ER model with Appointment, Product and Transaction (weak) entities. There is a 1:M relationship between Appointment and Product. Appointment has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 4
C) 5
D) 2
Detailed Solution:
The correct answer is B) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, can merge, no extra.
Question 12:
In an ER diagram, partial participation is represented by:
A) a single line
B) an arrow
C) a circle
D) a triangle
Detailed Solution:
The correct answer is A) a single line. Partial participation allows some entities not to participate, shown with single lines.
Question 13:
In an ER diagram, a derived attribute is represented by:
A) a dashed ellipse
B) a triangle
C) a hexagon
D) an arrow
Detailed Solution:
The correct answer is A) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 14:
Which type of attribute is ‘skills’ in an ER model?
A) key
B) composite
C) multivalued
D) derived
Detailed Solution:
The correct answer is C) multivalued. An employee can have multiple skills.
Question 15:
In an ER diagram, a key attribute is represented by:
A) a triangle
B) an underlined attribute name
C) a dashed line
D) a hexagon
Detailed Solution:
The correct answer is B) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 16:
Consider an ER model with Teacher, Order and Course entities. There is a M:N relationship between Teacher and Order. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 5
C) 4
D) 3
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 0. For M:N relationship, extra table needed.
Question 17:
Which type of attribute is ‘age’ in an ER model?
A) composite
B) simple
C) key
D) derived
Detailed Solution:
The correct answer is D) derived. Age can be derived from date of birth.
Question 18:
Which type of attribute is ‘address’ in an ER model?
A) multivalued
B) derived
C) key
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 19:
Which type of attribute is ‘age’ in an ER model?
A) simple
B) composite
C) key
D) derived
Detailed Solution:
The correct answer is D) derived. Age can be derived from date of birth.
Question 20:
Which type of attribute is ‘address’ in an ER model?
A) key
B) simple
C) multivalued
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 21:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a hexagon
B) a double diamond
C) an arrow
D) a dashed line
Detailed Solution:
The correct answer is B) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 22:
Consider an ER model with Driver and Vehicle entities. There is a 1:M relationship between Driver and Vehicle. Driver has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 2
C) 3
D) 4
Detailed Solution:
The correct answer is D) 4. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 2. For 1:M relationship, can merge, no extra.
Question 23:
In an ER diagram, a relationship is represented by:
A) a hexagon
B) a diamond
C) a triangle
D) a circle
Detailed Solution:
The correct answer is B) a diamond. Relationships connect entities and are shown as diamonds.
Question 24:
Which type of attribute is ‘address’ in an ER model?
A) simple
B) composite
C) key
D) derived
Detailed Solution:
The correct answer is B) composite. Address can be broken into street, city, state, etc.
Question 25:
In an ER diagram, a derived attribute is represented by:
A) a dashed ellipse
B) a circle
C) a hexagon
D) a triangle
Detailed Solution:
The correct answer is A) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 26:
Which type of attribute is ‘address’ in an ER model?
A) multivalued
B) key
C) simple
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 27:
In an ER diagram, partial participation is represented by:
A) a hexagon
B) a circle
C) a triangle
D) a single line
Detailed Solution:
The correct answer is D) a single line. Partial participation allows some entities not to participate, shown with single lines.
Question 28:
Which type of attribute is ’employee ID’ in an ER model?
A) simple
B) derived
C) key
D) multivalued
Detailed Solution:
The correct answer is A) simple. It’s a single atomic value.
Question 29:
Consider an ER model with Product and Transaction (weak) entities. There is a M:1 relationship between Product and Transaction (weak). Transaction (weak) has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 6
C) 4
D) 5
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For M:1 relationship, separate table for relationship.
Question 30:
Consider an ER model with Project and Dependent (weak) entities. There is a M:1 relationship between Project and Dependent (weak). Dependent (weak) has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 2
B) 3
C) 1
D) 5
Detailed Solution:
The correct answer is B) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For M:1 relationship, can merge, no extra.
Question 31:
In an ER diagram, a multivalued attribute is represented by:
A) an arrow
B) a triangle
C) a dashed line
D) a double ellipse
Detailed Solution:
The correct answer is D) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 32:
In an ER diagram, a relationship is represented by:
A) an arrow
B) a diamond
C) a hexagon
D) a dashed line
Detailed Solution:
The correct answer is B) a diamond. Relationships connect entities and are shown as diamonds.
Question 33:
In an ER diagram, a relationship is represented by:
A) an arrow
B) a diamond
C) a dashed line
D) a triangle
Detailed Solution:
The correct answer is B) a diamond. Relationships connect entities and are shown as diamonds.
Question 34:
Which type of attribute is ‘address’ in an ER model?
A) composite
B) key
C) derived
D) simple
Detailed Solution:
The correct answer is A) composite. Address can be broken into street, city, state, etc.
Question 35:
Consider an ER model with Product and Department entities. There is a 1:M relationship between Product and Department. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 1
C) 4
D) 2
Detailed Solution:
The correct answer is A) 3. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For 1:M relationship, separate table for relationship.
Question 36:
Consider an ER model with Course and Library entities. There is a M:N relationship between Course and Library. Course has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 4
C) 2
D) 5
Detailed Solution:
The correct answer is B) 4. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 1. For M:N relationship, extra table needed.
Question 37:
Consider an ER model with Teacher and Employee entities. There is a M:N relationship between Teacher and Employee. Teacher has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 7
C) 4
D) 5
Detailed Solution:
The correct answer is D) 5. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 2. For M:N relationship, extra table needed.
Question 38:
In an ER diagram, a key attribute is represented by:
A) a dashed line
B) a circle
C) an underlined attribute name
D) a triangle
Detailed Solution:
The correct answer is C) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 39:
Which type of attribute is ‘phone number’ in an ER model?
A) derived
B) composite
C) key
D) multivalued
Detailed Solution:
The correct answer is D) multivalued. A person can have multiple phone numbers.
Question 40:
In an ER diagram, a weak entity set is represented by:
A) a dashed line
B) a double rectangle
C) an arrow
D) a circle
Detailed Solution:
The correct answer is B) a double rectangle. Weak entities depend on strong entities and are represented by double rectangles.
Question 41:
In an ER diagram, total participation is represented by:
A) an arrow
B) a double line
C) a circle
D) a hexagon
Detailed Solution:
The correct answer is B) a double line. Total participation means every entity participates, shown with double lines.
Question 42:
In an ER diagram, a weak entity set is represented by:
A) a circle
B) a hexagon
C) a dashed line
D) a double rectangle
Detailed Solution:
The correct answer is D) a double rectangle. Weak entities depend on strong entities and are represented by double rectangles.
Question 43:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a triangle
B) a double diamond
C) a hexagon
D) a dashed line
Detailed Solution:
The correct answer is B) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 44:
Consider an ER model with Order, Vehicle and Department entities. There is a 1:M relationship between Order and Vehicle. Order has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 4
C) 8
D) 5
Detailed Solution:
The correct answer is A) 6. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 2. For 1:M relationship, separate table for relationship.
Question 45:
Consider an ER model with Course, Driver and Doctor entities. There is a 1:1 relationship between Course and Driver. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 1
B) 3
C) 2
D) 5
Detailed Solution:
The correct answer is B) 3. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 0. For 1:1 relationship, can merge, no extra.
Question 46:
In an ER diagram, an attribute is represented by:
A) an ellipse
B) a circle
C) a dashed line
D) a hexagon
Detailed Solution:
The correct answer is A) an ellipse. Attributes describe entities and are shown as ellipses.
Question 47:
In an ER diagram, a multivalued attribute is represented by:
A) a circle
B) a dashed line
C) a hexagon
D) a double ellipse
Detailed Solution:
The correct answer is D) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 48:
In an ER diagram, a key attribute is represented by:
A) a dashed line
B) a circle
C) an underlined attribute name
D) an arrow
Detailed Solution:
The correct answer is C) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 49:
In an ER diagram, a multivalued attribute is represented by:
A) a hexagon
B) a double ellipse
C) a triangle
D) an arrow
Detailed Solution:
The correct answer is B) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 50:
Which type of attribute is ’employee ID’ in an ER model?
A) key
B) composite
C) derived
D) simple
Detailed Solution:
The correct answer is D) simple. It’s a single atomic value.
Question 51:
Consider an ER model with Doctor and Transaction (weak) entities. There is a M:1 relationship between Doctor and Transaction (weak). Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 2
C) 0
D) 1
Detailed Solution:
The correct answer is B) 2. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For M:1 relationship, can merge, no extra.
Question 52:
In an ER diagram, a multivalued attribute is represented by:
A) a circle
B) a double ellipse
C) a triangle
D) an arrow
Detailed Solution:
The correct answer is B) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 53:
In an ER diagram, a derived attribute is represented by:
A) a triangle
B) a hexagon
C) an arrow
D) a dashed ellipse
Detailed Solution:
The correct answer is D) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 54:
Which type of attribute is ‘phone number’ in an ER model?
A) composite
B) derived
C) multivalued
D) key
Detailed Solution:
The correct answer is C) multivalued. A person can have multiple phone numbers.
Question 55:
Consider an ER model with and Supplier entities. Supplier has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) 1
C) 2
D) 4
Detailed Solution:
The correct answer is C) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 56:
In an ER diagram, a multivalued attribute is represented by:
A) a double ellipse
B) a circle
C) an arrow
D) a triangle
Detailed Solution:
The correct answer is A) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 57:
In an ER diagram, a strong entity set is represented by:
A) an arrow
B) a triangle
C) a rectangle
D) a dashed line
Detailed Solution:
The correct answer is C) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 58:
Which type of attribute is ’employee ID’ in an ER model?
A) derived
B) composite
C) key
D) simple
Detailed Solution:
The correct answer is D) simple. It’s a single atomic value.
Question 59:
Consider an ER model with Patient, Employee and Transaction (weak) entities. There is a M:1 relationship between Patient and Employee. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 3
C) 6
D) 2
Detailed Solution:
The correct answer is A) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 0. For M:1 relationship, separate table for relationship.
Question 60:
Which type of attribute is ‘full name’ in an ER model?
A) simple
B) key
C) composite
D) multivalued
Detailed Solution:
The correct answer is C) composite. Composed of first, middle, last names.
Question 61:
Consider an ER model with Library and Driver entities. There is a 1:1 relationship between Library and Driver. Driver has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 7
C) 4
D) 3
Detailed Solution:
The correct answer is A) 5. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 2. For 1:1 relationship, separate table for relationship.
Question 62:
In an ER diagram, a weak entity set is represented by:
A) a hexagon
B) a double rectangle
C) a dashed line
D) a circle
Detailed Solution:
The correct answer is B) a double rectangle. Weak entities depend on strong entities and are represented by double rectangles.
Question 63:
In an ER diagram, a derived attribute is represented by:
A) a circle
B) a hexagon
C) a dashed ellipse
D) a triangle
Detailed Solution:
The correct answer is C) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 64:
In an ER diagram, a key attribute is represented by:
A) a hexagon
B) an underlined attribute name
C) a dashed line
D) a circle
Detailed Solution:
The correct answer is B) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 65:
In an ER diagram, an attribute is represented by:
A) a dashed line
B) an ellipse
C) a circle
D) a triangle
Detailed Solution:
The correct answer is B) an ellipse. Attributes describe entities and are shown as ellipses.
Question 66:
Which type of attribute is ‘address’ in an ER model?
A) multivalued
B) derived
C) simple
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 67:
Consider an ER model with Customer, Driver and Log (weak) entities. There is a 1:M relationship between Customer and Driver. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 4
C) 6
D) 2
Detailed Solution:
The correct answer is B) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 0. For 1:M relationship, separate table for relationship.
Question 68:
Consider an ER model with Library and Transaction (weak) entities. There is a 1:1 relationship between Library and Transaction (weak). Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 0
C) 2
D) 4
Detailed Solution:
The correct answer is C) 2. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For 1:1 relationship, can merge, no extra.
Question 69:
In an ER diagram, a relationship is represented by:
A) an arrow
B) a triangle
C) a diamond
D) a hexagon
Detailed Solution:
The correct answer is C) a diamond. Relationships connect entities and are shown as diamonds.
Question 70:
Consider an ER model with Course and Transaction (weak) entities. There is a M:N relationship between Course and Transaction (weak). Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 2
C) 5
D) 4
Detailed Solution:
The correct answer is A) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For M:N relationship, extra table needed.
Question 71:
Consider an ER model with Product and Transaction (weak) entities. There is a 1:M relationship between Product and Transaction (weak). Product has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 2
C) 5
D) 3
Detailed Solution:
The correct answer is D) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, can merge, no extra.
Question 72:
Consider an ER model with Student and Transaction (weak) entities. There is a 1:1 relationship between Student and Transaction (weak). Student has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 2
C) 4
D) 6
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For 1:1 relationship, separate table for relationship.
Question 73:
In an ER diagram, a strong entity set is represented by:
A) an arrow
B) a triangle
C) a rectangle
D) a dashed line
Detailed Solution:
The correct answer is C) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 74:
Which type of attribute is ‘address’ in an ER model?
A) multivalued
B) derived
C) key
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 75:
Which type of attribute is ‘age’ in an ER model?
A) simple
B) multivalued
C) derived
D) key
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 76:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a triangle
B) a double diamond
C) a circle
D) a dashed line
Detailed Solution:
The correct answer is B) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 77:
Consider an ER model with Order, Product and Transaction (weak) entities. There is a M:1 relationship between Order and Product. Order has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 8
B) 6
C) 4
D) 7
Detailed Solution:
The correct answer is B) 6. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 2. For M:1 relationship, separate table for relationship.
Question 78:
In an ER diagram, a strong entity set is represented by:
A) an arrow
B) a dashed line
C) a triangle
D) a rectangle
Detailed Solution:
The correct answer is D) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 79:
Consider an ER model with and Book entities. Book has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 2
C) 1
D) 0
Detailed Solution:
The correct answer is B) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 80:
Which type of attribute is ‘address’ in an ER model?
A) derived
B) composite
C) simple
D) key
Detailed Solution:
The correct answer is B) composite. Address can be broken into street, city, state, etc.
Question 81:
Consider an ER model with Library, Patient, Vehicle and Dependent (weak) entities. There is a M:1 relationship between Library and Patient. Dependent (weak) has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 7
B) 6
C) 8
D) 5
Detailed Solution:
The correct answer is B) 6. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 1. For M:1 relationship, separate table for relationship.
Question 82:
Consider an ER model with Supplier, Patient, Order and Transaction (weak) entities. There is a M:N relationship between Supplier and Patient. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 6
C) 3
D) 5
Detailed Solution:
The correct answer is D) 5. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 0. For M:N relationship, extra table needed.
Question 83:
In an ER diagram, a strong entity set is represented by:
A) a dashed line
B) a triangle
C) a rectangle
D) an arrow
Detailed Solution:
The correct answer is C) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 84:
Which type of attribute is ‘address’ in an ER model?
A) key
B) simple
C) composite
D) derived
Detailed Solution:
The correct answer is C) composite. Address can be broken into street, city, state, etc.
Question 85:
Consider an ER model with Department and Transaction (weak) entities. There is a 1:M relationship between Department and Transaction (weak). Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 2
C) 3
D) 1
Detailed Solution:
The correct answer is B) 2. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For 1:M relationship, can merge, no extra.
Question 86:
Which type of attribute is ‘skills’ in an ER model?
A) composite
B) key
C) simple
D) multivalued
Detailed Solution:
The correct answer is D) multivalued. An employee can have multiple skills.
Question 87:
Which type of attribute is ‘age’ in an ER model?
A) key
B) composite
C) derived
D) simple
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 88:
Which type of attribute is ‘skills’ in an ER model?
A) derived
B) composite
C) multivalued
D) simple
Detailed Solution:
The correct answer is C) multivalued. An employee can have multiple skills.
Question 89:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a circle
B) a double diamond
C) a hexagon
D) a dashed line
Detailed Solution:
The correct answer is B) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 90:
In an ER diagram, a strong entity set is represented by:
A) an arrow
B) a dashed line
C) a rectangle
D) a circle
Detailed Solution:
The correct answer is C) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 91:
Which type of attribute is ’employee ID’ in an ER model?
A) derived
B) multivalued
C) simple
D) composite
Detailed Solution:
The correct answer is C) simple. It’s a single atomic value.
Question 92:
In an ER diagram, partial participation is represented by:
A) an arrow
B) a hexagon
C) a triangle
D) a single line
Detailed Solution:
The correct answer is D) a single line. Partial participation allows some entities not to participate, shown with single lines.
Question 93:
Consider an ER model with Library, Vehicle, Employee and Transaction (weak) entities. There is a M:N relationship between Library and Vehicle. Transaction (weak) has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 4
C) 6
D) 8
Detailed Solution:
The correct answer is C) 6. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 1. For M:N relationship, extra table needed.
Question 94:
Consider an ER model with Book and Transaction (weak) entities. There is a 1:M relationship between Book and Transaction (weak). What is the minimum number of tables required to represent this in relational model?
A) 3
B) 2
C) 1
D) 4
Detailed Solution:
The correct answer is A) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For 1:M relationship, separate table for relationship.
Question 95:
Which type of attribute is ‘skills’ in an ER model?
A) key
B) multivalued
C) simple
D) derived
Detailed Solution:
The correct answer is B) multivalued. An employee can have multiple skills.
Question 96:
Consider an ER model with and Library entities. Library has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 0
C) 1
D) 2
Detailed Solution:
The correct answer is D) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 97:
Consider an ER model with Employee, Department and Transaction (weak) entities. There is a 1:M relationship between Employee and Department. Transaction (weak) has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 6
C) 4
D) 5
Detailed Solution:
The correct answer is D) 5. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, separate table for relationship.
Question 98:
Consider an ER model with and Order entities. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) -1
B) 3
C) 1
D) 2
Detailed Solution:
The correct answer is C) 1. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 0.
Question 99:
In an ER diagram, a strong entity set is represented by:
A) 0
B) a dashed line
C) a triangle
D) a rectangle
Detailed Solution:
The correct answer is D) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 100:
Which type of attribute is ‘full name’ in an ER model?
A) simple
B) multivalued
C) composite
D) derived
Detailed Solution:
The correct answer is C) composite. Composed of first, middle, last names.
Question 101:
Which type of attribute is ‘skills’ in an ER model?
A) multivalued
B) composite
C) simple
D) key
Detailed Solution:
The correct answer is A) multivalued. An employee can have multiple skills.
Question 102:
Which type of attribute is ‘skills’ in an ER model?
A) simple
B) key
C) multivalued
D) derived
Detailed Solution:
The correct answer is C) multivalued. An employee can have multiple skills.
Question 103:
Consider an ER model with Appointment, Customer and Dependent (weak) entities. There is a 1:1 relationship between Appointment and Customer. Dependent (weak) has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 2
C) 5
D) 6
Detailed Solution:
The correct answer is A) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 1. For 1:1 relationship, can merge, no extra.
Question 104:
In an ER diagram, partial participation is represented by:
A) a hexagon
B) a single line
C) a circle
D) a triangle
Detailed Solution:
The correct answer is B) a single line. Partial participation allows some entities not to participate, shown with single lines.
Question 105:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a hexagon
B) a dashed line
C) a double diamond
D) a circle
Detailed Solution:
The correct answer is C) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 106:
In an ER diagram, total participation is represented by:
A) a circle
B) a hexagon
C) a double line
D) a dashed line
Detailed Solution:
The correct answer is C) a double line. Total participation means every entity participates, shown with double lines.
Question 107:
Consider an ER model with Product and Log (weak) entities. There is a 1:1 relationship between Product and Log (weak). Product has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 4
C) 1
D) 5
Detailed Solution:
The correct answer is A) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For 1:1 relationship, can merge, no extra.
Question 108:
Consider an ER model with Employee, Project and Dependent (weak) entities. There is a 1:M relationship between Employee and Project. Employee has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 4
C) 2
D) 6
Detailed Solution:
The correct answer is B) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, can merge, no extra.
Question 109:
Consider an ER model with Appointment and Log (weak) entities. There is a 1:1 relationship between Appointment and Log (weak). What is the minimum number of tables required to represent this in relational model?
A) 3
B) 1
C) 5
D) 4
Detailed Solution:
The correct answer is A) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For 1:1 relationship, separate table for relationship.
Question 110:
In an ER diagram, total participation is represented by:
A) a circle
B) a triangle
C) a dashed line
D) a double line
Detailed Solution:
The correct answer is D) a double line. Total participation means every entity participates, shown with double lines.
Question 111:
Which type of attribute is ‘full name’ in an ER model?
A) composite
B) simple
C) multivalued
D) derived
Detailed Solution:
The correct answer is A) composite. Composed of first, middle, last names.
Question 112:
Consider an ER model with Teacher, Supplier and Project entities. There is a 1:M relationship between Teacher and Supplier. Supplier has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 5
C) 7
D) 6
Detailed Solution:
The correct answer is B) 5. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 2. For 1:M relationship, can merge, no extra.
Question 113:
In an ER diagram, a strong entity set is represented by:
A) a circle
B) a rectangle
C) a triangle
D) an arrow
Detailed Solution:
The correct answer is B) a rectangle. Strong entities are represented by single rectangles as they have their own primary keys.
Question 114:
Which type of attribute is ‘age’ in an ER model?
A) multivalued
B) key
C) simple
D) derived
Detailed Solution:
The correct answer is D) derived. Age can be derived from date of birth.
Question 115:
Which type of attribute is ‘skills’ in an ER model?
A) key
B) simple
C) composite
D) multivalued
Detailed Solution:
The correct answer is D) multivalued. An employee can have multiple skills.
Question 116:
Consider an ER model with Vehicle, Customer and Dependent (weak) entities. There is a M:1 relationship between Vehicle and Customer. Customer has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 7
C) 3
D) 6
Detailed Solution:
The correct answer is A) 5. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 2. For M:1 relationship, can merge, no extra.
Question 117:
Which type of attribute is ‘age’ in an ER model?
A) derived
B) composite
C) simple
D) key
Detailed Solution:
The correct answer is A) derived. Age can be derived from date of birth.
Question 118:
Which type of attribute is ‘address’ in an ER model?
A) key
B) simple
C) multivalued
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 119:
In an ER diagram, a derived attribute is represented by:
A) a hexagon
B) a dashed ellipse
C) a triangle
D) a dashed line
Detailed Solution:
The correct answer is B) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 120:
Consider an ER model with Vehicle, Appointment and Log (weak) entities. There is a M:N relationship between Vehicle and Appointment. Vehicle has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 4
C) 8
D) 7
Detailed Solution:
The correct answer is A) 6. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 2. For M:N relationship, extra table needed.
Question 121:
Consider an ER model with Appointment, Hospital, Customer and Dependent (weak) entities. There is a M:1 relationship between Appointment and Hospital. Dependent (weak) has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 7
C) 8
D) 5
Detailed Solution:
The correct answer is B) 7. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 3. For M:1 relationship, can merge, no extra.
Question 122:
Which type of attribute is ‘age’ in an ER model?
A) multivalued
B) composite
C) derived
D) simple
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 123:
In an ER diagram, a multivalued attribute is represented by:
A) a dashed line
B) a circle
C) a double ellipse
D) a hexagon
Detailed Solution:
The correct answer is C) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 124:
Which type of attribute is ‘age’ in an ER model?
A) composite
B) multivalued
C) derived
D) key
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 125:
Which type of attribute is ‘age’ in an ER model?
A) derived
B) multivalued
C) simple
D) key
Detailed Solution:
The correct answer is A) derived. Age can be derived from date of birth.
Question 126:
Consider an ER model with and Project entities. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) -1
C) 1
D) 3
Detailed Solution:
The correct answer is C) 1. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 0.
Question 127:
Consider an ER model with Appointment, Book, Teacher and Dependent (weak) entities. There is a 1:1 relationship between Appointment and Book. Appointment has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 7
B) 5
C) 6
D) 4
Detailed Solution:
The correct answer is C) 6. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 1. For 1:1 relationship, separate table for relationship.
Question 128:
Consider an ER model with Appointment, Doctor and Driver entities. There is a 1:1 relationship between Appointment and Doctor. Doctor has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 3
C) 7
D) 4
Detailed Solution:
The correct answer is A) 5. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 2. For 1:1 relationship, can merge, no extra.
Question 129:
Consider an ER model with Student, Project, Patient and Log (weak) entities. There is a 1:1 relationship between Student and Project. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 5
C) 7
D) 6
Detailed Solution:
The correct answer is B) 5. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 0. For 1:1 relationship, separate table for relationship.
Question 130:
Which type of attribute is ‘address’ in an ER model?
A) composite
B) derived
C) key
D) simple
Detailed Solution:
The correct answer is A) composite. Address can be broken into street, city, state, etc.
Question 131:
Which type of attribute is ‘phone number’ in an ER model?
A) key
B) simple
C) multivalued
D) derived
Detailed Solution:
The correct answer is C) multivalued. A person can have multiple phone numbers.
Question 132:
Consider an ER model with Doctor and Book entities. There is a 1:1 relationship between Doctor and Book. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 1
C) 3
D) 2
Detailed Solution:
The correct answer is C) 3. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For 1:1 relationship, separate table for relationship.
Question 133:
Which type of attribute is ‘full name’ in an ER model?
A) multivalued
B) key
C) simple
D) composite
Detailed Solution:
The correct answer is D) composite. Composed of first, middle, last names.
Question 134:
Which type of attribute is ‘skills’ in an ER model?
A) multivalued
B) simple
C) composite
D) key
Detailed Solution:
The correct answer is A) multivalued. An employee can have multiple skills.
Question 135:
Consider an ER model with Department and Employee entities. There is a 1:1 relationship between Department and Employee. Employee has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 2
B) 6
C) 4
D) 5
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 1. For 1:1 relationship, separate table for relationship.
Question 136:
Which type of attribute is ‘address’ in an ER model?
A) multivalued
B) derived
C) key
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 137:
Consider an ER model with Patient, Driver, Vehicle and Transaction (weak) entities. There is a M:N relationship between Patient and Driver. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 7
B) 4
C) 3
D) 5
Detailed Solution:
The correct answer is D) 5. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 0. For M:N relationship, extra table needed.
Question 138:
Consider an ER model with Library and Book entities. There is a 1:1 relationship between Library and Book. Book has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 4
C) 5
D) 2
Detailed Solution:
The correct answer is B) 4. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 2. For 1:1 relationship, can merge, no extra.
Question 139:
In an ER diagram, a key attribute is represented by:
A) a triangle
B) a circle
C) a dashed line
D) an underlined attribute name
Detailed Solution:
The correct answer is D) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 140:
In an ER diagram, total participation is represented by:
A) a circle
B) a triangle
C) a double line
D) a dashed line
Detailed Solution:
The correct answer is C) a double line. Total participation means every entity participates, shown with double lines.
Question 141:
Which type of attribute is ‘age’ in an ER model?
A) derived
B) simple
C) composite
D) multivalued
Detailed Solution:
The correct answer is A) derived. Age can be derived from date of birth.
Question 142:
Which type of attribute is ‘age’ in an ER model?
A) key
B) multivalued
C) derived
D) simple
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 143:
Which type of attribute is ‘address’ in an ER model?
A) composite
B) derived
C) key
D) simple
Detailed Solution:
The correct answer is A) composite. Address can be broken into street, city, state, etc.
Question 144:
In an ER diagram, an attribute is represented by:
A) a dashed line
B) a hexagon
C) a circle
D) an ellipse
Detailed Solution:
The correct answer is D) an ellipse. Attributes describe entities and are shown as ellipses.
Question 145:
Which type of attribute is ‘phone number’ in an ER model?
A) key
B) composite
C) multivalued
D) derived
Detailed Solution:
The correct answer is C) multivalued. A person can have multiple phone numbers.
Question 146:
In an ER diagram, a key attribute is represented by:
A) a hexagon
B) a circle
C) a dashed line
D) an underlined attribute name
Detailed Solution:
The correct answer is D) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 147:
Which type of attribute is ‘skills’ in an ER model?
A) key
B) multivalued
C) composite
D) derived
Detailed Solution:
The correct answer is B) multivalued. An employee can have multiple skills.
Question 148:
Consider an ER model with Order, Customer and Dependent (weak) entities. There is a 1:1 relationship between Order and Customer. Order has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 8
C) 6
D) 4
Detailed Solution:
The correct answer is C) 6. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 2. For 1:1 relationship, separate table for relationship.
Question 149:
Consider an ER model with Book, Employee and Teacher entities. There is a 1:1 relationship between Book and Employee. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 2
B) 5
C) 1
D) 3
Detailed Solution:
The correct answer is D) 3. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 0. For 1:1 relationship, can merge, no extra.
Question 150:
Which type of attribute is ‘phone number’ in an ER model?
A) simple
B) multivalued
C) composite
D) key
Detailed Solution:
The correct answer is B) multivalued. A person can have multiple phone numbers.
Question 151:
In an ER diagram, a weak entity set is represented by:
A) a triangle
B) an arrow
C) a hexagon
D) a double rectangle
Detailed Solution:
The correct answer is D) a double rectangle. Weak entities depend on strong entities and are represented by double rectangles.
Question 152:
Consider an ER model with Doctor, Appointment and Order entities. There is a 1:1 relationship between Doctor and Appointment. Doctor has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 7
B) 6
C) 5
D) 4
Detailed Solution:
The correct answer is B) 6. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 2. For 1:1 relationship, can merge, no extra.
Question 153:
Which type of attribute is ‘skills’ in an ER model?
A) simple
B) multivalued
C) composite
D) derived
Detailed Solution:
The correct answer is B) multivalued. An employee can have multiple skills.
Question 154:
Consider an ER model with Customer, Driver and Log (weak) entities. There is a 1:M relationship between Customer and Driver. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 5
C) 6
D) 3
Detailed Solution:
The correct answer is A) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 0. For 1:M relationship, separate table for relationship.
Question 155:
Consider an ER model with Library and Doctor entities. There is a M:N relationship between Library and Doctor. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 1
B) 5
C) 3
D) 4
Detailed Solution:
The correct answer is C) 3. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For M:N relationship, extra table needed.
Question 156:
Which type of attribute is ‘age’ in an ER model?
A) simple
B) composite
C) derived
D) multivalued
Detailed Solution:
The correct answer is C) derived. Age can be derived from date of birth.
Question 157:
Which type of attribute is ’employee ID’ in an ER model?
A) composite
B) derived
C) key
D) simple
Detailed Solution:
The correct answer is D) simple. It’s a single atomic value.
Question 158:
In an ER diagram, a multivalued attribute is represented by:
A) a circle
B) a triangle
C) a hexagon
D) a double ellipse
Detailed Solution:
The correct answer is D) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 159:
Which type of attribute is ‘full name’ in an ER model?
A) simple
B) composite
C) multivalued
D) derived
Detailed Solution:
The correct answer is B) composite. Composed of first, middle, last names.
Question 160:
In an ER diagram, a multivalued attribute is represented by:
A) a dashed line
B) a hexagon
C) a circle
D) a double ellipse
Detailed Solution:
The correct answer is D) a double ellipse. Multivalued attributes can have multiple values and are represented by double ellipses.
Question 161:
Consider an ER model with Driver, Doctor and Book entities. There is a 1:1 relationship between Driver and Doctor. Doctor has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 6
B) 2
C) 3
D) 4
Detailed Solution:
The correct answer is D) 4. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 1. For 1:1 relationship, can merge, no extra.
Question 162:
Consider an ER model with Book and Log (weak) entities. There is a M:1 relationship between Book and Log (weak). Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 1
B) 2
C) 4
D) 0
Detailed Solution:
The correct answer is B) 2. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For M:1 relationship, can merge, no extra.
Question 163:
Consider an ER model with Doctor, Vehicle and Patient entities. There is a 1:M relationship between Doctor and Vehicle. Patient has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 8
B) 4
C) 6
D) 7
Detailed Solution:
The correct answer is C) 6. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 3. For 1:M relationship, can merge, no extra.
Question 164:
Consider an ER model with Appointment, Vehicle and Hospital entities. There is a 1:M relationship between Appointment and Vehicle. Hospital has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 5
B) 6
C) 7
D) 8
Detailed Solution:
The correct answer is B) 6. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 2. For 1:M relationship, separate table for relationship.
Question 165:
Consider an ER model with Employee, Student and Log (weak) entities. There is a 1:1 relationship between Employee and Student. Log (weak) has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 7
B) 5
C) 4
D) 6
Detailed Solution:
The correct answer is B) 5. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 2. For 1:1 relationship, can merge, no extra.
Question 166:
Consider an ER model with Patient, Employee and Dependent (weak) entities. There is a 1:M relationship between Patient and Employee. Patient has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 6
C) 4
D) 2
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (2). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, can merge, no extra.
Question 167:
Which type of attribute is ‘address’ in an ER model?
A) derived
B) multivalued
C) simple
D) composite
Detailed Solution:
The correct answer is D) composite. Address can be broken into street, city, state, etc.
Question 168:
Which type of attribute is ‘skills’ in an ER model?
A) composite
B) multivalued
C) key
D) simple
Detailed Solution:
The correct answer is B) multivalued. An employee can have multiple skills.
Question 169:
Which type of attribute is ’employee ID’ in an ER model?
A) composite
B) simple
C) derived
D) multivalued
Detailed Solution:
The correct answer is B) simple. It’s a single atomic value.
Question 170:
Which type of attribute is ‘skills’ in an ER model?
A) composite
B) key
C) derived
D) multivalued
Detailed Solution:
The correct answer is D) multivalued. An employee can have multiple skills.
Question 171:
Consider an ER model with and Teacher entities. Teacher has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) 4
C) 2
D) 1
Detailed Solution:
The correct answer is C) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 172:
In an ER diagram, a derived attribute is represented by:
A) a triangle
B) a dashed ellipse
C) an arrow
D) a dashed line
Detailed Solution:
The correct answer is B) a dashed ellipse. Derived attributes are calculated from others and shown with dashed ellipses.
Question 173:
Which type of attribute is ‘age’ in an ER model?
A) derived
B) composite
C) multivalued
D) key
Detailed Solution:
The correct answer is A) derived. Age can be derived from date of birth.
Question 174:
Consider an ER model with Employee and Project entities. There is a 1:M relationship between Employee and Project. What is the minimum number of tables required to represent this in relational model?
A) 1
B) 3
C) 2
D) 4
Detailed Solution:
The correct answer is B) 3. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For 1:M relationship, separate table for relationship.
Question 175:
Consider an ER model with Order, Student and Project entities. There is a 1:1 relationship between Order and Student. Order has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 6
C) 7
D) 5
Detailed Solution:
The correct answer is D) 5. Based on rules: Strong entities need 1 table each (3). Multivalued attributes need extra 2. For 1:1 relationship, can merge, no extra.
Question 176:
In an ER diagram, an attribute is represented by:
A) a circle
B) a dashed line
C) an ellipse
D) an arrow
Detailed Solution:
The correct answer is C) an ellipse. Attributes describe entities and are shown as ellipses.
Question 177:
Which type of attribute is ‘phone number’ in an ER model?
A) derived
B) multivalued
C) key
D) composite
Detailed Solution:
The correct answer is B) multivalued. A person can have multiple phone numbers.
Question 178:
Consider an ER model with Course, Doctor, Student and Transaction (weak) entities. There is a M:1 relationship between Course and Doctor. Student has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 8
B) 9
C) 7
D) 6
Detailed Solution:
The correct answer is C) 7. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 3. For M:1 relationship, can merge, no extra.
Question 179:
Consider an ER model with Order and Hospital entities. There is a 1:1 relationship between Order and Hospital. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 1
C) 4
D) 2
Detailed Solution:
The correct answer is D) 2. Based on rules: Strong entities need 1 table each (2). Multivalued attributes need extra 0. For 1:1 relationship, can merge, no extra.
Question 180:
Which type of attribute is ’employee ID’ in an ER model?
A) composite
B) key
C) simple
D) multivalued
Detailed Solution:
The correct answer is C) simple. It’s a single atomic value.
Question 181:
Which type of attribute is ‘address’ in an ER model?
A) key
B) composite
C) derived
D) multivalued
Detailed Solution:
The correct answer is B) composite. Address can be broken into street, city, state, etc.
Question 182:
Which type of attribute is ‘phone number’ in an ER model?
A) multivalued
B) simple
C) composite
D) derived
Detailed Solution:
The correct answer is A) multivalued. A person can have multiple phone numbers.
Question 183:
Consider an ER model with Department, Teacher, Product and Log (weak) entities. There is a 1:M relationship between Department and Teacher. Product has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 4
B) 6
C) 5
D) 8
Detailed Solution:
The correct answer is B) 6. Based on rules: Strong entities need 1 table each (3). Weak entity needs 1. Multivalued attributes need extra 1. For 1:M relationship, separate table for relationship.
Question 184:
Consider an ER model with and Appointment entities. Appointment has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 1
B) 3
C) 0
D) 2
Detailed Solution:
The correct answer is D) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 185:
In an ER diagram, total participation is represented by:
A) a triangle
B) a hexagon
C) a double line
D) a dashed line
Detailed Solution:
The correct answer is C) a double line. Total participation means every entity participates, shown with double lines.
Question 186:
Consider an ER model with and Teacher entities. Teacher has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) 2
C) 3
D) 4
Detailed Solution:
The correct answer is B) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 187:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a triangle
B) a double diamond
C) a dashed line
D) a circle
Detailed Solution:
The correct answer is B) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 188:
In an ER diagram, total participation is represented by:
A) a triangle
B) a dashed line
C) a double line
D) a hexagon
Detailed Solution:
The correct answer is C) a double line. Total participation means every entity participates, shown with double lines.
Question 189:
Which type of attribute is ‘skills’ in an ER model?
A) composite
B) multivalued
C) derived
D) key
Detailed Solution:
The correct answer is B) multivalued. An employee can have multiple skills.
Question 190:
In an ER diagram, a key attribute is represented by:
A) a hexagon
B) an underlined attribute name
C) a dashed line
D) a circle
Detailed Solution:
The correct answer is B) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 191:
Which type of attribute is ‘full name’ in an ER model?
A) derived
B) multivalued
C) composite
D) simple
Detailed Solution:
The correct answer is C) composite. Composed of first, middle, last names.
Question 192:
In an ER diagram, a key attribute is represented by:
A) a hexagon
B) a circle
C) a dashed line
D) an underlined attribute name
Detailed Solution:
The correct answer is D) an underlined attribute name. Key attributes uniquely identify entities and are underlined.
Question 193:
In an ER diagram, an attribute is represented by:
A) a dashed line
B) a hexagon
C) a circle
D) an ellipse
Detailed Solution:
The correct answer is D) an ellipse. Attributes describe entities and are shown as ellipses.
Question 194:
Consider an ER model with and Student entities. Student has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 3
B) 0
C) 2
D) 4
Detailed Solution:
The correct answer is C) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 195:
In an ER diagram, a weak entity set is represented by:
A) a dashed line
B) an arrow
C) a circle
D) a double rectangle
Detailed Solution:
The correct answer is D) a double rectangle. Weak entities depend on strong entities and are represented by double rectangles.
Question 196:
Consider an ER model with and Vehicle entities. Vehicle has a multivalued attribute. Participation is total on one side. What is the minimum number of tables required to represent this in relational model?
A) 0
B) 4
C) 2
D) 1
Detailed Solution:
The correct answer is C) 2. Based on rules: Strong entities need 1 table each (1). Multivalued attributes need extra 1.
Question 197:
Which type of attribute is ’employee ID’ in an ER model?
A) simple
B) key
C) composite
D) multivalued
Detailed Solution:
The correct answer is A) simple. It’s a single atomic value.
Question 198:
In an ER diagram, an identifying relationship for weak entity is represented by:
A) a dashed line
B) a triangle
C) a circle
D) a double diamond
Detailed Solution:
The correct answer is D) a double diamond. Identifying relationships for weak entities are represented by double diamonds.
Question 199:
Consider an ER model with Library and Dependent (weak) entities. There is a 1:1 relationship between Library and Dependent (weak). What is the minimum number of tables required to represent this in relational model?
A) 1
B) 5
C) 2
D) 3
Detailed Solution:
The correct answer is D) 3. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 0. For 1:1 relationship, separate table for relationship.
Question 200:
Consider an ER model with Patient and Transaction (weak) entities. There is a M:1 relationship between Patient and Transaction (weak). Transaction (weak) has a multivalued attribute. What is the minimum number of tables required to represent this in relational model?
A) 2
B) 6
C) 4
D) 5
Detailed Solution:
The correct answer is C) 4. Based on rules: Strong entities need 1 table each (1). Weak entity needs 1. Multivalued attributes need extra 1. For M:1 relationship, separate table for relationship.