Reference no: EM131216693
Create a description of the tables mapped from the ER model created in Exercise 9.13 for the Perfect Pets case study described in
Appendix B.
Exercise 9.13
Create an ER model for the Perfect Pets case study described in Appendix B. (If appropriate, use the enhanced ER concepts.)
Appendix B
Data requirements Veterinary clinics Perfect Pets has many veterinary clinics located in the main cities of America. The details of each clinic include the clinic number, clinic address (consisting of the street, city, state, and zip code), and the telephone and fax numbers. Each clinic has a Manager and a number of staff (for example vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice. Staff The details stored on each member of staff include the staff number, name (first and last), address (street, city, state, and zip code), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice. Pet owners When a pet owner first contacts a clinic of Perfect Pets, the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city, state, and zip code), and home telephone number. The owner number is unique to a particular clinic. Pets The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, date of birth (if unknown, an approximate date is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic. Examinations When a sick pet is brought to a clinic, it is examined by the vet on duty. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.
|
Why do you think some people are troubled by the idea
: Why do you think some people are troubled by the idea that crime has a biological cause? Support your response using an article from the popular media presenting the biological argument for criminal behavior.
|
|
Determine the maximum voltage gain
: Derive the expression for the voltage transfer function T (s) = Vo(s)/Vi(s). - Determine the maximum voltage gain. - What is the bandwidth?
|
|
Why might these tasks be carried out by different people
: Explain the difference between logical and physical database design. Why might these tasks be carried out by different people?
|
|
Were there any casualties or injuries
: What tools, equipment, or technology could have significantly improved relief efforts? How? Were any special technologies or scientific developments used to restore the situation back to normal? If so, explain. Who should be responsible for funding ..
|
|
Create an er model for the perfect pets
: Create an ER model for the Perfect Pets case study described in Appendix B. (If appropriate, use the enhanced ER concepts.)
|
|
Determine the midband voltage gain
: Calculate the lower corner frequency. - Determine the midband voltage gain. - Sketch the Bode plot of the voltage gain magnitude.
|
|
Was probable cause a factor in this case
: How should probable cause be implemented, in general? As a law enforcement official, what are some of the questions that you might ask yourself in this case before you engage in a stop, search, or seizure or seek a warrant from the court?
|
|
What is the purpose of a bank reconciliation
: What is the purpose of a bank reconciliation? What are the reasons for differences between the cash reported in the accounting records, and the cash balance in the bank statements?
|
|
What way may views of biological causes of crime be related
: Why do you think some people are troubled by the idea that crime has a biological cause? Support your response using an article from the popular media presenting the biological argument for criminal behavior.
|