Question: Convert the conceptual design to a collection of SQL CREATE statements. Make sure all primary and foreign keys are represented. please do use MySQL Workbench

Convert the conceptual design to a collection of SQL CREATE statements. Make sure all primary and foreign keys are represented.

please do use MySQL WorkbenchConvert the conceptual design to a collection of SQL CREATE statements. Make

Schema 1 Pet clinic: A company called Perfect Pets runs a number of clinics. A clinic has many staff members who work at it. A staff member may only work at one clinic. One of the staff members at each clinic has additional responsibilities and is responsible for the management of the clinic. This staff member, known as the manager, can manage at most one clinic. Each clinic has a unique clinic number (clinicNo) and each member of staff has a unique staff number (staffNo). When a pet owner contacts a clinic, the owner's pet is registered with the clinic. An owner can own one or more pets, but a pet can only be owned by one owner and be registered with one clinic. Each owner has a unique owner number (ownerNo) and each pet has a unique pet number (petNo). When a pet is brought to a clinic, it undergoes an examination by a member of the staff. The examination may result in the pet being prescribed with zero or more treatments. Each examination has a unique examination number (examNo) and each type of treatment has a unique treatment number (treatNo)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!