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.
The post Design a database to hold the information described below appeared first on Best Custom Essay Writing Services | EssayBureau.com.
