1) Provide a brief synopsis

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.

<pstyle=”background-color: transparent;=”” color:=”” rgb(51,=”” 51,=”” 51);=”” font-size:=”” 13px;=”” font-variant-numeric:=”” normal;=”” font-variant-east-asian:=”” margin-bottom:=”” margin-top:=”” min-height:=”” 0px;”=”” style=”box-sizing: border-box; font-family: Roboto, sans-serif; font-size: 16px; background-color: rgb(255, 255, 255);”>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.</pstyle=”background-color:>

<pstyle=”background-color: transparent;=”” color:=”” rgb(51,=”” 51,=”” 51);=”” font-size:=”” 13px;=”” font-variant-numeric:=”” normal;=”” font-variant-east-asian:=”” margin-bottom:=”” margin-top:=”” min-height:=”” 0px;”=”” style=”box-sizing: border-box; font-family: Roboto, sans-serif; font-size: 16px; background-color: rgb(255, 255, 255);”></pstyle=”background-color:>

The reports will be geared toward creating the queries and the information contained in those queries