Situation 1: A local dog trainer holds obedience classes in the metro Detroit area. She teaches five levels of classes basic, intermediate, advanced_i, advanced_ii, advanced_iii. Dogs cannot be enrolled in the intermediate class unless they have taken the basic class, and they cannot be enrolled in the advanced classes unless they have taken the intermediate class. Each class is taught in one of the cities: troy, Detroit, and Royal Oak. All five levels are taught in each city. The trainer will never take more than eight dogs in a single class, and she will not cancel a class unless no one signs up for it. The database keeps track of information about each dog, the dog's owner, and each class. Owner information includes the name, address, phone, and email address. Dog information includes the dog's name, birthday, breed, colors (can have more than one color), and the dog's shot dates (can have multiple shot dates). Discounts may be applied if an owner brings in multiple dogs. Class information includes classic, the city, start and end dates, start time, class size (number of dogs attended). Each class is associated with a class level which includes the name, description, and the prerequisite. In addition, the trainer keeps track of the different skills that the dogs can perform after each class (such as fetch, rollover, heel, etc.). A dog may learn multiple skills from one class. for each skill learned, the trainer records the name of the skill and assigns a grade (good, fair, or situation 2: library checkout system you and your friend, Luke sky walker, checked out two copies of the same book, the chronicles of Narnia: the lion, the witch and the wardrobe for a book report you two needed to do for a class. while you were at the library, you checked out several other books written or co-authored by the same author, c. s. Lewis, and another novel on the same subjects. Luke also checked out 2 versions of the movies in DVD format based on the book, one made in 1979, and the other in 2005. Develop an entity-relationship diagram that would fully represent the data included in this scenario, in particular, the data underlined. note: You do not need to include all possible attributes for the entities you come up; but you need to include PKS for all the entities, and attributes whose data have been underlined in the description above.

Requirements for each situation:

1. Your ER diagrams need to include: entities, attributes, relationships, participation constraints, or relationship strength. remember to use good naming practices, and do not forget semantic information for the relationships you include.

2. You need to create an ERD for each situation using the crow’s foot model in vision 2010.

3. You need to provide a relational database schema including specifications of the tables you have designed, i.e. table name and list of attributes for each table,Example: vendor (vend_code, vend_contact, ven_areacode, vend_phone).

4. You need to provide the business rules that guide your design, and number the business rules (the same way i numbered the requirements). Do not forget the business rules for any relationship cardinality. If you make any assumptions in addition to the ones given below, please list them. Your assumptions should not contradict the information provided above.

Answer rating: 100% (QA)

Entity relationship modeling An entity relation diagram is a graphical representation of an information systems entities which may also be referred to as an object and relationships within those objec... View the full answer