Note: Answer Both Part A and Part B (1 Mark) (3 Marks) A. Explain any two difference between and strong and weak entities B. Construct an E-R diagram based on the scenario given below. Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as Course with attributes name, department and c-number Section with attributes s-number and enrollment, and dependent as a weak entity set on course Room with attributes r-number, capacity and building . Show an E-R diagram illustrating the use of all three additional entity sets listed above Questions: I Identify the relationships. Identify the key attributes for adding constraints. Identify weak entities and relations with cardinality and participative constrains Draw only a complete ER diagram Maximum size for new files: 100MB Note: Answer Both Part A and Part B (1 Mark) (3 Marks) A. Explain any two difference between and strong and weak entities B. Construct an E-R diagram based on the scenario given below. Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as Course with attributes name, department and c-number Section with attributes s-number and enrollment, and dependent as a weak entity set on course Room with attributes r-number, capacity and building . Show an E-R diagram illustrating the use of all three additional entity sets listed above Questions: I Identify the relationships. Identify the key attributes for adding constraints. Identify weak entities and relations with cardinality and participative constrains Draw only a complete ER diagram Maximum size for new files: 100MB Note: Answer Both Part A and Part B (1 Mark) (3 Marks) A. Explain any two difference between and strong and weak entities B. Construct an E-R diagram based on the scenario given below. Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as Course with attributes name, department and c-number Section with attributes s-number and enrollment, and dependent as a weak entity set on course Room with attributes r-number, capacity and building . Show an E-R diagram illustrating the use of all three additional entity sets listed above Questions: I Identify the relationships. Identify the key attributes for adding constraints. Identify weak entities and relations with cardinality and participative constrains Draw only a complete ER diagram Maximum size for new files: 100MB