Determine the data entities During requrements na)pis,you delarmined sdet a sche

Question

Determine the data entities During requrements na)pis,you delarmined sdet a schedules of students, and coursesn 2. Generate a list of potential entity pairings o Students to instructors Students to their schedules o Instructors to courses o Schedules of students to courses The current system does not include detailed instructor information (for example, instructor name) to be included on the schedule 3. Analyze the significant entity relationships. Students to instructors 1. Many students may be taught by an instructor. Many instructors may teach a student What is this relationship's cardnality o Students to their schedules 1. One student generates a student schedule, and a student schedule s generated by a student What is this relationship's cardnality? Instructor to courses 1. An instructor teaches many courses, and each course is taught by an instructo What is this relationship's cardinality? 1. Many student schedules list courses. Many courses may be listed on a student schedule 1. All aforementioned relationships pertain to students in general However, there are two types of students A STUDENT can be ony an UNDERGRAD or a GRADUATE Schedules of students to oourses Note: the entity STUDENT and nothing eise What type of business rule governs this relationship: total vs partial, disjoint vs. overlap? 4. Develop an integrated ERD using pencil-and-paper frst. Afterwards, you will be using MS isio

Explanation / Answer

Answer1: Student (Name, Roll number, Class, taught by, course selected)

Instructor (Subject teaching, Number of lectures taken, number of teachers teaching)_

Schedule of students (coursde date, class, timing)

courses: (course name, students enrolled, name of instructor teaching )

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.