Given the following database, indicate in the first column that each table$/$entity is R$,$ E$,$ or A$.$

Write down "relationship" if the table is a relationship table $($to be used to link tables having a

many to many relationship$)$ in the database. Please notice that a relationship table should not be

categorized as R$,$ E or A$.$

Use red color to indicate the primary key and underline the foreign key$($s$)$ in the attribute's

column for each table. Not all tables have foreign key$($s$).$

General comments: attributes called "name" and "date" are not clear for which tables.

Can someone draw a simple data model based on the given table and attributes