Consider the following Presentation Layer ERD:

Using the foreign key design, specify the logical scheme in the following ways:

a. with directed arcs

b. in terms of inclusion dependencies

c. using the information-preserving grammar

Also, list the metadata present in the ERD and indicate the ones captured by each of the three designs of the logical schema.

(This is all the information available, the Presentation Layer ERD is at the top of the question.)

Name Size Headquarters Name Major O Status Year Quarter COMPANY STUDENT Location Period Stipend m . INTERNSHIP Provides > Gets ets Name Size Headquarters Name Major O Status Year Quarter COMPANY STUDENT Location Period Stipend m . INTERNSHIP Provides > Gets ets