1) Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.
2) Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.Yes, you can use much of the information that you have used in prior
assignments, but you need to make it 4 entities. You can create
two reports that you would use and the user roles. For the
reports you will be creating two queries and discussing why you picked
these queries and what type of reports and why they are needed.
The other aspect is that you will be creating the user roles that are
specifc for those two individuals-thus you will have to identify how
you will limit the information to each of those users.
The reports will be geared toward creating the queries and the
information contained in those queries.