Healthy-Weight center Database Management System

The Healthy-Weight center aims to improve the overall wellness of their members by providing food plans that are healthy, well-balanced and interesting, and fit in with each of their members lifestyle. In order to keep track of their databases, the manager of the Healthy- Weight center has decided to build a database management system to maintain information about its memberships and food plans.

A member can register as either a private or a corporate type of member. Each member is assigned a unique member-id and other details of the member including address, date of birth, and phone number are stored in the system. For a corporate type of members, the name of the company is recorded and a special corporate discount is applied. For private members, the center provides a different kind of special services depending on the need of the individual member, such as free delivery service to their residence, vouchers for their friends and family members, etc.

The system maintains a large number of food plans, and each member will be prescribed one particular food plan. However, each member may be prescribed a number of different food plans on different period of time. Each food plan is given a unique plan-name. The food- plan-designer, plan-creation-date, and cost are stored for each plan. Each food plan may be made up of any number of servings, each of which is given a unique serving-name. A time- of-serving attribute is stored for each serving within a food plan. A serving-description is stored for each serving.

Each serving is made up of any amount of any number of food elements. For example, one particular serving may be made up of 10g of chicken, 20g potatoes, 5g of tomatoes, and 3g of peas. A food-id is used for each element, and a food-description is stored for each food element.

To allow the nutritional value of each food plan to be computed, nutrient values are associated with each food element, as follows:

A set of nutrients (e.g. VIT-A, VIT-B, etc.) is stored with their unit-of-measure (e.g. IU [International Unit] for VIT-A, mg [milligrams] for VIT-B, etc.). A nutrient-id and a nutrient-description are also stored.

The nutrient-content for each nutrient that applies to a particular food is stored for a standard-amount of that food.

Draw E-R for the scenario

The ER should contain all necessary information such as entities, attributes, primary

keys, relationships, cardinalities etc. Any assumptions should also be stated.

please draw very clearly