using database wellness clinic medical group

Step $5\mathrm{.}1$ Update the data dictionary and list of assumptions as needed. For each table,

write the table name and write out the names, data types, and sizes of all the data items,

and identify any constraints, using the conventions of the DBMS you will use for

implementation.

Step $5\mathrm{.}2$ Write and execute SQL statements to create all tables needed to implement the

design.

Step $5\mathrm{.}3$ Insert at least five records in each table, preserving all constraints. Put in

enough data to demonstrate how the database will function.

Step $5\mathrm{.}4$ Write SQL statements that will process five non$-$routine requests for

information from the database just created. For each, write the request in English,

followed by the corresponding SQL command