+1 862 207 3288 1). Draw an E-R diagram for the following scenario using notation appears in the textbook. You should include all minimum and maximum cardinalities, all attributes described, and specify identifying attributes for all entities. All composite attributes should be decomposed. No derived attributes should be included in your diagram. (Worth 25 points).
Seventy-One Rentals, a car rental company in Ontario, Canada, has hired you to design and develop a database. Seventy-One Rentals has various outlets throughout Ontario. Each outlet has an outlet number, address, phone number, and fax number. Each site is allocated at least one vehicle to rent out and each vehicle is always assigned to one outlet. The registration number uniquely identifies each vehicle. Information stored on the rental vehicles includes: the vehicle registration number, model, make, and engine size.
A lease agreement is recorded for each vehicle rental. A lease number uniquely identifies each lease agreement. The data stored on a lease agreement includes the lease number, lease start date, lease end date, lease amount, beginning mileage, and ending mileage. A lease agreement describes the rental of one car. If a customer rents more than one car, then a separate lease agreement is created for each car. Some rental vehicles have been leased many times while others have never been leased.
Seventy-One Rentals also needs to store information about their customers. The data stored on customers includes the customer number, name, address, email address, and phone number. The customer number uniquely identifies each customer. Sometimes customer information is stored before the customer actually leases a vehicle, and a customer can agree to many leases.
2.) Draw an E-R diagram for the following scenario using the textbook or Visio notation. You should include all minimum and maximum cardinalities, all attributes described, and specify identifying attributes for all entities. All composite attributes should be decomposed. No derived attributes should be included in your diagram. Completeness and disjointness constraints should be specified, and you should include the subtype discriminator attribute(s). (Worth 25 points).
You are building a database to store information about real estate properties in the town of Valdosta, Georgia. There are three types of property: residential, commercial, and municipal. For residential property, the town needs to store the unique plot number, the address, and the size of the property. For commercial real estate, the town needs to store the unique plot number, address, zone type, and size of the property. For municipal property, the town needs to store the unique plot number, address, and size of the property. The town offers a special mixed-use program that causes some property to be classified as both residential and commercial property at the same time.
All properties have at least one owner and potentially many owners. Some owners have many different properties, or may not own any property. The property percentage owned needs to be stored with the relationship between owners and property. The town of Valdosta needs to store the social security number, name, and address of each owner.
There are real estate restrictions that exist in the town of Valdosta, but these restrictions only apply to residential properties. The town needs to store the restriction number, name, and a description for each restriction. Each restriction applies to at least one residential property but may apply to many. Some residential properties have no restrictions while others have at most one restriction.
3). Draw an E-R diagram for the following scenario using either the textbook or Visio notation. You should include all minimum and maximum cardinalities, all attributes described, and specify identifying attributes for all entities. All composite attributes should be decomposed. No derived attributes should be included in your diagram. (worth 10 points).
Cougar Computers receives price quotes on computer parts from many suppliers. The company needs to store the supplier number and name for each supplier. For each part, the company needs to store the part number, part name, and quantity on hand. A supplier may provide price quotes for many parts, but provides a price quote for at least one part. Each part may have many different price quotes or no price quote at all. The part number and the supplier number, together, serve as the identifier for each quote. For each price quote, the quoted part price needs to be stored.
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!
