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 DM001, Trigonometry would be TR004, 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 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 Programming Questions!