Model in Dia

Hello people, I have two small Entity-Correlation Models i need for $20 USD . Deliver the Entity Correlation diagrams for the following: You must deliver three files .jpg or .png images and the editable file with your answers . Beware, images must have been created with Dia software and not paintings photographed with your cell phone. (1) I want you to design a database for an online store. It should be the basis your data to keep information for manufacturers, products, customers and orders, and specifically: • For manufacturers, their name and address. • For the products manufactured by each manufacturer, the type of product, the model number and their value. Different manufacturers (eg HP, SONY) may use the same model number (eg A152L) for different products (eg HP has an A152L printer while SONY TV with the same code number), but one supplier does not use the same model number for different products (for HP, for example, code A152L is unique to the printer and not used for another product). • For customers, their name, address, contact phone number and address their email. Still the system will also retain credit card information customers in their markets. Every client can have many credit cards but one card belongs to a unique customer. For credit cards will their type, number and expiry date are retained. • Each order has a unique code, and an order date and corresponds to a single customer. Customers make orders using one of their credit cards, so a customer can make many orders and with a different credit card each time. However it should be unable to do so client order with a credit that does not belong to him. Each order can also includes different products and in a different quantity from each. (2) You are asked to design a database for a catering company. The base you should keep information about company employees as well as customers and the events the company undertakes to feed. Specifically: • Each customer is identified by his / her unique VAT number and has a brand name, an address and phone. • Employees of the company include cooks and waiters. All the workers are registered with the AMKA system, and they still have surname, address and telephone number. The cooks have a salary while the waiters are paid according to the hours they have worked each month. • The company has a number of dishes that it offers to customers. The dishes have a descriptive name, a species (eg cold appetizing, vegetarian, etc.) and one price. • The company undertakes to feed a customer event for which it should to know the chosen dishes, the number of people to include or event, type of event, venue and date, as well as an estimate of duration. Also for each event are the waiters who will work as well as the cooks involved in preparing her dishes event. We assume that for the same event we can have many cooks preparing a different crowd from the same dish. (3) Do you want to implement a database for a site where users are criticizing actors who have roles in films. • A movie has title and year of release. • There are roles for which we list their name (eg, role name = "Father"). In each movie there are many roles and a role can be used in many movies. • An actor has a name and surname. • We want to record the role that each actor plays in a movie. An actor can have many roles in a movie and a role to play by many actors in the same movie. • In the application can be written users for whom we record the name, their surname and email. • A user can rate (0 to 10) his / her view of the interpretation of one actress in a role in a movie. I will be happy to work with you