Question: QUESTION 27 5 points Save Answer Find diagramming mistakes in the following entity-relationship diagram. You do not have to correct mistakes. Just mention mistakes. Ignore

QUESTION 27 5 points Save Answer Find diagrammingQUESTION 27 5 points Save Answer Find diagramming

QUESTION 27 5 points Save Answer Find diagramming mistakes in the following entity-relationship diagram. You do not have to correct mistakes. Just mention mistakes. Ignore minimal (i.e., mandatory or optional) cardinality. That is, do not mention minimal cardinalities in your answer. There will be a penalty of 0.25 point for each incorrect answer! ABC Computer Ed provides computer/information systems education services. Each course is to be offered by a specific instructor; an instructor may offer many courses. Every instructor is supervised by one of other instructors; an instructor may supervise many other instructors. Courses are classified into two types: regular course and on- site course. A regular course is assigned to a classroom. A customer may take more than one courses; a course is taken by many students. supervises HO- Instructor Teaching Customer SPK instructor_id provides-od PK cust_id [FK] PK customer_id course_id [FR] PK inst_id [FK] address pois_taught name takes PK inst_id [FR] is_taught address course_id [FK) name takes Course Course Taking PK course_id + for - PK course_id [FK] offers description PK customer_id [FK] fee PK instructor_id [FK] OnSite Course RegularCourse PK course_id [FR] GPK course_id [FR] PK room_no Note: For this question, there will be a penalty of 0.25 point for each incorrect answer! QUESTION 27 5 points Save Answer Find diagramming mistakes in the following entity-relationship diagram. You do not have to correct mistakes. Just mention mistakes. Ignore minimal (i.e., mandatory or optional) cardinality. That is, do not mention minimal cardinalities in your answer. There will be a penalty of 0.25 point for each incorrect answer! ABC Computer Ed provides computer/information systems education services. Each course is to be offered by a specific instructor; an instructor may offer many courses. Every instructor is supervised by one of other instructors; an instructor may supervise many other instructors. Courses are classified into two types: regular course and on- site course. A regular course is assigned to a classroom. A customer may take more than one courses; a course is taken by many students. supervises HO- Instructor Teaching Customer SPK instructor_id provides-od PK cust_id [FK] PK customer_id course_id [FR] PK inst_id [FK] address pois_taught name takes PK inst_id [FR] is_taught address course_id [FK) name takes Course Course Taking PK course_id + for - PK course_id [FK] offers description PK customer_id [FK] fee PK instructor_id [FK] OnSite Course RegularCourse PK course_id [FR] GPK course_id [FR] PK room_no Note: For this question, there will be a penalty of 0.25 point for each incorrect

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!