Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In an institute named Global Business School an instructor teaches many sections. A course can be taught in one or more sections. The teaching in
In an institute named Global Business School an instructor teaches many sections. A course can be taught in one or more sections. The teaching in a section is supported by having multiple teaching assistants attached to a section. Similarly, a teaching assistant may be associated with multiple sections in which course is being taught. Many sections can have classes in a particular classroom depending on section timing. Each classroom is identified by room number (like Al, A2, B1, B2, C, C2 etc.). Each of these classrooms are present in a particular building. Each building can have one or more than one of these classrooms. Participants of the courses are given one or more textbooks. Same text book may be used in multiple courses. Additionally, you have been provided the following mixed data of the entities and attributes for the Global Business School in no particular order Instructor Teaching assistant (TA) Textbook author Course section number Course title Buil Instructor ID Instructor office hoursCourse Textbook title tive ht date Building number Course section Course Building Textbook TA student ID Instructor name Textbook publisher name ourse number Teaching asst (TA) Textbook ISBN name Textbook Section da Section capacity Section time First identify the entities and their respective attributes from the given data and description. Draw the E-R diagram showing clearly attributes, relation and the cardinality of the relation. 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started