The task is to create an E/R model that most accurately fits given the following information: We are hired to build a database for a photographic shop. The shop sells photos that can be bought over the internet. More precisely, the shop sells the rights to use a photo. In this sense, a photo can be sold only once. We need to model two very distinct parts: on one hand the information and activities that support the catalog of photos, models, and photographers and on the other hand the information and activities to support the transactions and customers. We store some technical information for every photo, like the type (color or black and white), type of film, shutter speed, f-stop, price, resolution, the photographer etc. A photo can be made by a single photographer. If the photographer of a photo is known, we record the date of the shooting. The photos are grouped into several broad categories: landscapes, portraits and abstracts (everything that is not a landscape or a portrait). We are told that a photo cannot be a landscape and a portrait at the same time. We store some biographical information of the photographers. We also store some information about the models (in the case of portraits) and information about the location the photo was taken in (for landscapes). For photographers, we record their name, date of birth, short bio, address, and nationality. We also store information about other photographer(s) that influenced their work. We might need to record information about photographers, even if they have not made any of the photos we sell or sold at the store. The reason is to provide the customers with a database of photographers. For every landscape photo location we need to record the place, the country and a short description of the area. Multiple landscape photos may have been taken at the same location. For a portrait model, we need to record his/her name, date of birth, sex and a short bio. A photo may picture several models. For every participation of a model in a portrait photo, we record the agency that provided the model (if available). For abstract photos we might store a comment. Although the customers can browse the catalog without registering, in order to buy one or more photos they need to have an account/profile and they need to register with a user name and password so the user name can be used as a key for Customers. For a customer, we record her user name, password, name, type, address and billing address. In the same transaction (or shopping cart) a customer can buy several photos. The attribute TotalAmount can be calculated from the individual price of every photo. Although this may, apparently, introduce some redundancy it gives us the flexibility to adapt the total price based on the type of customer or promotions or any other business rules (not to be included in our schema). For every transaction, we record the date and the credit card information of the buyer. Attributes like Name and Address need to be represented with their various component attributes First Name, Last Name, Street Address, State, Zip Code and the like. Other key attributes might need to be introduced. Thank you in advance