Question: Read the given business scenario. Using Crow's Foot notation, draw the entities TEACHER and COURSE and CLASS. List the attributes underneath each entity. Specify whether
Read the given business scenario. Using Crow's Foot notation, draw the entities TEACHER and COURSE and CLASS. List the attributes underneath each entity. Specify whether they are mandatory or optional. Identify the UIDs.
We have several teachers at our school. A teacher can be assigned up to three classes per semester. If a teacher is on
sabbatical, he doesnt teach that semester. We keep a record of the teachers first name, last name, address, phone number, and
email address.
Our school offers many courses such as Data Modeling, Introduction to SQL Trigonometry, Physics, and Biology. Each course
has a code. For example: Data Modeling would be DM Trigonometry would be TR etc. During each semester, a course
may be taught in several classes so there could be two classes of Physics, three classes of Biology, etc. Each class can be
taught by only one teacher. We assign a unique ID for each class, and we also keep track of the day it is taught, the time, and the
classroom.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
