ERD 1: The Olympic facilities are divided into sports complexes Sports complexes are divided into one spoet and multisport types. Multisport complexes have areas of the complex designated for each port with a location indicator center, North East comme south cle). A complessa location, chief organising individual, total occupied area, and so on. Each complex holds a series of events (eg, the track tadium may hold many different tacea). For each event there is planned date, duration, anber of participants, number of officials, and so on. A list of all officials will be maintained together with the list of events each official will be involved in Different equipment is needed for the events les gral posts, poles, parallel bars) as well as another set of equipment is needed for the maintenance of each sports complex des cleaning equipment, ass cutters, etc. The two types of facilities (one-sport and multisport) will have different types of information. For each type of facility, there are number of amenities available (eg intemet caf gym, pool. etc.) together with an approximate budget for each amenity ERD 2: Consider an online auction database system in which members buyers and sellers participate in the sale of item. The data requirements for this system are summarized as follows: The online site has members who are identified by a unique member id and are described by an email address, their name, a password, their home address, and a phone number A member may be a buyer or a seller. A buyer has a shipping address recorded in the database. A seller has a bank account number and routing sumber recorded in the database liems are placed by a seller for sale and are identified by a unique item number assigned by the system Items are also described by an item title, an item description, a starting bid price. bidding increment, the start date of the action, and the end date of the action. Items are also categorized based on fixed classification hierare hy (for example a medem may be classified as computer hardware modem) Buyers make bids for items they are interested in A bidding price and time of bid placement is recorded. The person at the end of the auction with the highest bid price is declared the winner and a transaction between the buyer and the seller may proceed som afler Buyers and selle may place feedback ratings on the purchase or sale of an item The feedback contains a rating between 1 and 10 and a comment. Note that the ratings are placed on a completed transaction by the buyer or seller of the item in the transaction ERD 3: The data requirements of the libery application are sumunurised as follows: BOOK entity is identified by Bookld, it has title and multiple atheir names. PUBLISHER entity consists of Name Address, and theme attributes publisher may have many phone numbers Name is the key for the PUBLISHER. LIBRARY BRANCH ctity Branchld as key and Branchname attribute additionally. HORROWER entity has Breweld as key and additionally luas name, addres.phone attributes. Each LIBRARY BRANCH ne or more copies of the same book. In such a case no Copies attribute needs to be maintained by the relationship A boek is published by only one publisher A book can be loaned to a bomower at a specific library branch
