Write schema for each scenario please!!

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 up to six classes during a semester Instructors may teach up to three classes 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) 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