In Figure $1$ are examples of two relations that may be part of a university database. Use

these relations to answer the following:$[7$ marks, $1$ each$]$

$1.$ What are the names and types of attributes in each relation of the database?

$2.$ What are some examples of tuples that could exist in each relation of the database?

$3.$ For one tuple in each relation, what are the values of each attribute in the tuple?

$4.$ What are the relation schemas for each relation, including the names and types of

each attribute?

$5.$ What is the overall database schema, including the relationships between the

different relations?

$6.$ What are the possible ranges of values for each attribute in each relation?

$7.$ Can you provide alternative ways to present the same information in each relation,

such as reordering or renaming the attributes?