Design a database to hold the information described below

Sustainability taskforce: You have signed on as a member of Sustainability Taskforce, which sponsors ecologically oriented community projects of various kinds (such as building and distributing composters or constructing energy‐efficient low‐income housing). You have volunteered to start building a relational database to replace the hodgepodge of spreadsheets currently being used to track membership and projects. Assume you have access to a zip code table and plan to include it in the database. First, you want to keep track of all the taskforce’s members. For each member, you want to store the following information: first name, middle name, last name, date of birth, address information (street address, city, state, and zip code), phone number, e‐mail address, and date of joining the organization. Furthermore, most members have a mentor, who is another member of the taskforce. For each project, you want to store a name, worksite address (street address, city, state, and zip code), description, date started, and date ended (blank if the project is still ongoing). Furthermore, you want the database to remember which members are involved in each project: a project can involve as few as 1 member and in some cases as many as 25. A small number of the members involved in each project are designated project leaders; usually there is just one leader per project, but for some larger projects there may be two or three. Design a database to hold the information described above. Draw an ER diagram, and write a database design outline.

find the cost of your paper

Complete independent research and review two (2) to three (3) online end-user license agreements.

Complete independent research and review two (2) to three (3) online end-user license agreements. Compare and contrast each EULA with each other. In your response, please consider the following: ·….

Write a SQL query that identifies the number of prescriptions grouped by drug name.

ALY6030 Final Project Assignment – Pharmacy Claims Due End of Week 6 Background: The excel file “ALY 6030 Final Project Data Set.xlsx” contains sample pharmacy claims for made-up members of….

Create a JavaFX program to allow a user to query the Northwind database.

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:   Print order total (not….