Entity Relationship (ER) Model More Quiz
DBMS Tutorial 2.1
Entity Relationship (ER) Model - DBMS Tutorial 2
Quiz:
Consider an application for Club membership. There are many clubs at different locations. A club can have many members. Each member belonging to a particular club has a unique identity number. The member id can be the same for different clubs. The below relations are created.
1. Club(ClubId, Name, Location)
2. Member(ClubId, MemberId, Name, Address)
Quiz 22: Identify the Primary key for Club relation.
a) ClubId ---
b) Name
c) Location
Consider an application for Club membership. There are many clubs at different locations. A club can have many members. Each member belonging to a particular club has a unique identity number. The member id can be the same for different clubs. The below relations are created.
1. Club (ClubId, Name, Location)
2. Member (ClubId, MemberId, Name, Address)
Quiz 23: Identify the Primary key for Member relation.
a) ClubId ---
b) MemberId ---
c) Name
d) Address
Consider an application for Club membership. There are many clubs at different locations. A club can have many members. Each member belonging to a particular club has a unique identity number. The member id can be the same for different clubs. The below relations are created.
1. Club (ClubId, Name, Location)
2. Member (ClubId, MemberId, Name, Address)
Quiz 24: Identify the Foreign key for Club relation.
a) Foreign key does not exist ---
b) Foreign key exists
i) ClubId
ii) Name
iii) Location
Consider an application for Club membership. There are many clubs at different locations. A club can have many members. Each member belonging to a particular club has a unique identity number. The member id can be the same for different clubs. The below relations are created.
1. Club (ClubId, Name, Location)
2. Member (ClubId, MemberId, Name, Address)
Quiz 25: Identify the Foreign key for Member relation.
a) Foreign key does not exist
b) Foreign key exists
i) ClubId ---
ii) MemberId
iii) Name
iv) Address
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 26: Identify the Primary key for Participant relation.
a) ParticipantId ---
b) Name
c) Address
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 27: Identify the Primary key for Assessment relation.
a) Course ---
b) Marks
c) Participant ---
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 28: Identify the Primary key for Course relation.
a) CourseId ---
b) Desc
c) Duration
d) Prerequisite
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 29: Identify the Foreign key(s) for Participant relation.
a) Foreign key does not exist ---
b) Foreign key exists
i) ParticipantId
ii) Name
iii) Address
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 30: Identify the Foreign key(s) for Assessment relation.
a) Foreign key does not exist
b) Foreign key exists
i) Course ---
ii) Marks
iii) Participane ---
Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.
1. Participant (ParticipantId, Name, Address)
2. Course (CourseId, Desc, Duration, Prerequisite)
3. Assessment (Course, Marks, Participant)
Quiz 31: Identify the Foreign key(s) for Course relation.
a) Foreign key does not exist
b) Foreign key exists
i) CourseId
ii) Desc
iii) Duration
iv) Prerequisite ---
Scenario:
Joho Limited, a firm in the digital media and entertainment domain have gaming zones in different locations. Due to growth in business, the firm decides to use the relational database to store customer information, product information, and day to day transactional information.Quiz 32: As per the business scenario, a 'Customer' relation is identified with 'CustomerId', 'CustomerName', 'City', 'ContactNumber', 'EmailAddress' as its attributes. While CustomerId and EmailAddress are unique for every customer, the business requirement says that it is not mandatory for a customer to provide his EmailAddress.Which of the following would best suit the above context?
a) CustomerId, EmailAddress can Individually become candidate keys and CustomerId becomes the primary key
b) CustomerId, EmailAddress can individually become candidate keys
c) This relation doesn’t have any candidate key
d) CustomerId is the candidate key as well as the primary key ---
Scenario:
Joho Limited, a firm in the digital media and entertainment domain have gaming zones in different locations. Due to growth in business, the firm decides to use the relational database to store customer information, product information, and day to day transactional information.
Quiz 33: One of the requirements read 'games played by the customer are to be tracked with the timestamp'. While trying to implement this requirement, the expert team finds it necessary to have a transaction table that would have the details of the games played by the customer along with the date and time details. The transaction table is named as gaming with attributes TransactionId, CustomerId, GameId, Date, StartingTime, FinishingTime, AmountPayable. Attributes CustomerId and GameId in gaming table can take values that are present for customerId and GameId present in customer and game tables respectively. Which of the following two options would best suit the above context? Select one or more:
a) CustomerId and GameId present in gaming table can take duplicate values. ---
b) CustomerId in the Customer table references the CustomerId in the gaming table and the gameId in the Game table references GameId in the gaming table
c) CustomerId and GameId are foreign keys present in child table gaming, referring to
d) CustomerId and GameId, the primary keys present in parent tables, Customer and Game respectively ---
e) CustomerId and GameId present in gaming table cannot take null values and duplicate values
Scenario:
Joho Limited, a firm in the digital media and entertainment domain have gaming zones in different locations. Due to growth in business, the firm decides to use the relational database to store customer information, product information, and day to day transactional information.
Quiz 34: “A specific requirement requires an attribute in the Game table has to refer to the GameId attribute present in the same table. Such a reference would not be possible and it is decided that the requirement is unfeasible.” Choose whether the above decision of the requirement is True or False with the correct reason.
a) True. An attribute in a table/relation can reference another attribute in the same table/relation
b) False. An attribute in a table/relation can reference another attribute in the same table/relation and this is called Composite Foreign Key
c) True. An attribute in a table/relation cannot reference another attribute in the same table/relation
d) False. An attribute in a table/relation can reference another attribute in the same table/relation and this is called Self Referencing Foreign Key ---
Scenario:
Joho Limited, a firm in the digital media and entertainment domain have gaming zones in different locations. Due to growth in business, the firm decides to use the relational database to store customer information, product information, and day to day transactional information.Quiz 35: One of the requirements reads ‘customer can walk into a gaming zone and play any game that fascinates him and obviously a game would also be played by different customers’.What kind of a relationship exists between Customer and Game?
a) One to Many relationships
b) One to One relationship
c) Many to Many relationships ---
d) Many to One relationship
Consider the following scenario of an educational institution. Every department has several instructors. An instructor can be associated with only one department. One among the instructors would act as head of the department. Instructors are allocated to handle various courses. An instructor can handle many courses. A course can be handled by many instructors. Choose the Correct notation that depicts the relationship between:
Quiz 36: Department and Instructor
Consider the following scenario of an educational institution. Every department has several instructors. An instructor can be associated with only one department. One among the instructors would act as head of the department. Instructors are allocated to handle various courses. An instructor can handle many courses. A course can be handled by many instructors. Choose the Correct notation that depicts the relationship between:
Quiz 37: Instructor and Courses
Consider the following ER-Diagram depicting a banking scenario and answer the questions below:
Quiz 38: Identify the entities for the relation.
a) Branch ---
b) Has
c) Account ---
d) Belongs to
e) Customer ---
Consider the following ER-Diagram depicting a banking scenario and answer the questions below:
Quiz 39: Identify the relationships present in the ER-Diagram.
a) Branch
b) Has ---
c) Account
d) Belongs to ---
e) Customer
Consider the following ER-Diagram depicting a banking scenario and answer the questions below:
Quiz 40: Identify the cardinality of all identified relationships.
a) 1:1
b) 1:M ---
c) M:N ---
Back Next
---
I hope you likable this nice post. Do not forget to share it together with your friends, the Sharing Button is below the post. Apart from this, if there's any downside within the intermediate, don't hesitate to request the Comment Box. we are going to be happy to help you.
I will continue to write more and more on this blog, so do not forget to make our blog BlogLearner as a bookmark (Ctrl + D) on your mobile or computer and subscribe to us to get all the posts in your email. Do not forget to share these posts, if you like it. You can facilitate us reach additional individuals by sharing it on social networking sites like Facebook or Twitter.
 |
| The Entity Relationship (ER) Model Quiz |
No comments:
Post a Comment