The Coca Cola Company in Atlanta, Georgia produces a wide range of products that are delivered to

a. The company records the following information about their customers: customer identification number, name, address, X (longitude) and Y (latitude) coordinates of their location, and the amount of time (in fractions of an hour) required making a stop at that location.

b. Each employee has an employee identification number, name, address (which consists of a city, state, and zip code), gender, birth date, position in the company, wage earned per hour of regular time work, wage earned per hour of overtime work, number of dependents, and number of years worked for the Coca Cola Company.

c. Each product has a product identification number, price, and number of units produced per day. Products may be ordered by one or more customers, and a customer may order one or more products. Furthermore, employees produce one or more products, and a product may be produced by exactly one employee. Draw an E-R diagram for the above description and add the minimum and maximum relationship cardinalities. Identify the key attributes for each entity and the composite attributes.

2. Consider the database in Problem 10. Update the E-R diagram for the cases described below. For each entity, identify the key attribute(s).

a. For tax purposes, the Coca Cola Company extends the data kept for each employee to include additional information about their dependents. This information consists of each dependent’s name, birth date, and age.

b. The company has decided to record information about their suppliers and the raw material(s) supplied by them. The following information is recorded for each supplier: the supplier identification number, the address, and the name of the contact person. The raw material information consists of the raw material identification number and the material’s name.

c. The company keeps a fleet of vehicles to facilitate the distribution of the products to the customers. Each vehicle has an identification number, model, and capacity.

</pstyle=”margin:>

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.