Scenario 1: Simple School Data Business rules:

Complete this assignment by creating entity-relationship diagrams (ERD) to store data corresponding to each of the following scenarios.

Scenario 1:  Simple School Data

Business rules:

The school offers numerous classes, each of which has a single instructor and is offered in a single section

Students may enroll in many during a semester

Instructors may teach many during a semester

Your goal: Use Gliffy to draw a practical ERD to keep track of students, instructors, and class enrollments during a single semester. Include primary keys and foreign keys necessary to store data pertaining to the described scenario within a relational data model. Paste your ERD into the space below.

Scenario 2: The Veterinarian’s Office

This office houses four vets, one who specializes in large animals and the others in small animals.  The veterinarians want to set up a database to track patients (animals), owners, and the associated veterinarian.

Business rules:

Veterinarians treat numerous patients

Each patient has a primary-care veterinarian assigned

A single owner is associated with each patient

Owners may have numerous patients (pets)

Each vet has only one specialty

Owner data is kept to provide contact information and to facilitate payment of bills

Your goal: Use Gliffy to draw a practical ERD to keep track of data requested by the veterinarians. Include primary keys, foreign keys, and requested attributes to store data pertaining to the described scenario within a relational data model. Paste your ERD in the space below.