Problem $1$:

Read the given business scenario. Draw the entities BAND and MUSICIAN.

List the attributes underneath each entity. Specify whether they are

mandatory or optional. Identify the UIDs. Write out the relationship in

English, including optionality and cardinality.

$$I am an agent for several musicians and bands. A musician may be a solo

performer or may belong to a band. A band will always have one or more

musicians in it$.$ Some musi$-$cians are a one$-$man band. However, a musician

can belong to only one band. Since I schedule them for concerts and events,

I need to keep track of certain information: the musician$$s first name, last

name, address, phone number, and hourly rate. If it$$s a band, I need to know

the band name in addition to the information I already keep for the member

musicians. I$$ve handled bands with the same name, so just to make sure I

book the right band, I assign an ID to each one. The hourly rate for a band is

the total of the hourly rates of its members.$$

Problem $2$:

Read the given business scenario. Draw the entities TEACHER and COURSE

and CLASS. List the attributes underneath each entity. Specify whether they

are mandatory or optional. Identify the UIDs. Write out the relationship in

English, including optionality and cardinality.

$$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 doesn$$t teach

that semester. We keep a record of the teacher$$s 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$001,$ Trigonometry would be TR$004,$

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.$$

Convert ERD developed in problem $1$ and $2($Assignment $3)$ to Physical model

Design the logical model then convert it to relational model

generate DDL script

Submit the word document that contains:

Physical model $($multiple tables$)$ of each problem $(1$ and $2)$

Screenshot of Developed Logical model for each problem

Screenshot of relational models. Add technical documentation