Provide two visuals:

normalized relation schemas

normalized ERD diagram

Using the information given Below:

Textual ERD Description:

Entities and Their Attributes:

R$1$: Contains attributes D $($Primary Key$)$ and E$.$

R$3$: Contains attributes A $($Primary Key$)$ and C$.$

R$4$: Contains attributes A$,$ B$,$ and D$.$ B is the Primary Key, A and D

are Foreign Keys.

Relationships:

R$4$ to R$1$: A many$-$to$-$one relationship exists from R$4$ to R$1$ via the

attribute D $.$ This relationship indicates that multiple records in R $4$ can

reference a single record in R $1,$ facilitated by the foreign key D in R $4$

pointing to the primary key D in R $1.$

R$4$ to R$3$: A many$-$to$-$one relationship exists from R$4$ to R$3$ via the

attribute $A.$ This relationship signifies that multiple records in $R4$ can

reference a single record in R$3,$ with the foreign key $A$ in $R4$ pointing

to the primary key A in R$3.$

Here is the Rubric for the visuals:

Show all entities with sensible names, including the composite entity

has shown correct multiplicities for each relationship

has clearly indicated primary keys $($PK$)$ in each table

has clearly included foreign keys $($FK$)$ in their correct tables

has shown correct multiplicities for each relationship

has shown correct UML notation