$1\mathrm{.}6($Data redundancy$)$ Looking at the Emp$\_$Name and Emp$\_$Phone contents in the following

figure, what change$($s$)$ would you recommend?

The File Structure

Proj$\_$

Num

Proj$\_$Name Emp$\_$

Num

Emp$\_$Name Job$\_$

Code

Job$\_$Chg$\_$

Hour

Proj$\_$

Hours

Emp$\_$Phone

$1$ Hurricane $101$ John D$.$ Newson EE $85\mathrm{.}0013\mathrm{.}3653-234-3245$

$1$ Hurricane $105$ David F$.$ Schwann CT $60\mathrm{.}0016\mathrm{.}2653-234-1123$

$1$ Hurricane $110$ Anne R$.$ Ramoras CT $60\mathrm{.}0014\mathrm{.}3615-233-5568$

$2$ Coast $101$ John D$.$ Newson EE $85\mathrm{.}0019\mathrm{.}8653-234-3245$

$2$ Coast $108$ June H$.$ Sattlemeir EE $85\mathrm{.}0017\mathrm{.}5905-554-7812$

$3$ Satellite $110$ Anne R$.$ Ramoras CT $62\mathrm{.}0011\mathrm{.}6615-233-5568$

$3$ Satellite $105$ David F$.$ Schwann CT $26\mathrm{.}0023\mathrm{.}4653-234-1123$

$3$ Satellite $123$ Mary D$.$ Chen EE $85\mathrm{.}0019\mathrm{.}1615-233-5432$

$3$ Satellite $112$ Allecia R$.$ Smith EE $85\mathrm{.}0020\mathrm{.}7615-678-6879$

$2\mathrm{.}9($ER diagram$)$ Typically, a hospital patient receives medications that have been ordered by a

particular doctor. Because the patient often receives several medications per day, there is a $1$:M

relationship between Patient and Order. Similarly, each order can include several medications,

creating a M:N relationship between Order and Medication.

a$.$ Identify the business rules for Patient, Order, and Medication.

b$.$ Create a Crow$$s Foot ERD that depicts a relational database model to capture these business

rules.

$3\mathrm{.}10($Relational algebra$)$ Use the following tables to create the table that would result from

$\_,\_().$

Table Name: Student

Stu$\_$Code Prof$\_$Code

$100278$

$1285692$

$5122724$

$5312352$

$531268$

$5534271$

Table Name: Professor

Prof$\_$Code Dept$\_$Code

$12$

$26$

$36$

$44$

$4\mathrm{.}2($Strong relationship$)$ What is a strong $($or identifying$)$ relationship, and how is it depicted in a

Crow$$s Foot ERD?