Hello the assignment is attached in the database 3400 file. Please follow directions thoroughly. If anyone question feel free to ask :) I need a few queries completed in access and a minor report.

 

My project is called: WorkFromHere (WFH) needs a straight-forward database and managementsystem (DBMS) for its co-working memberships.Since the business is small, using MicrosoftAccess 2016 is the optimal solution. It’s a user-friendly database implementation tool that canhandle up to 32,768 entries.More specifications are here:Create a relational database schema1.Place the queries down below in the Access file.SQL Query:1.How many members are on weekly memberships?2.How many members are on monthly memberships?3.How many inactive members are there?4.How many members are from NY and inactive?Your GUI design – the menus1.Forms2.ReportsE/R to relational translation. I will accept your relational database as it is, i.e., theinitialset of relations. Apply the normalization rules to normalize the set of relations to 3rdnormalform.Do not implement in Access; just show them in your report.Prepare a user manual for your database application. 

Attachments:

• 1495598096-database 3400 baruch.docx