Each table has at least 3 attributes. In addition to the PKs in each table, the many-table has an FK. Also, the one-table has at least 5 rows and the many-table has at least 10 rows of data. The data values in the FK must be constrained to one of the PK values of the one-table. However, make sure one or two PK values of the one-table do not exist in the FKs of the many-table.

Queries. Copy and paste the SELECT statement in text form and then run and crop the MySQL result screen for each query.

***Make the table in a medical setting with one table being about the patients***