GSU CIS 8040 - Requested Problem (3 pages)

Previewing page 1 of 3 page document View the full content.
View Full Document

Requested Problem



Previewing page 1 of actual document.

View the full content.
View Full Document
View Full Document

Requested Problem

155 views


Pages:
3
School:
Georgia State University
Course:
Cis 8040 - Fndmtls of Dbase Mgt Sys

Unformatted text preview:

Here you go I ve pulled this from some materials on my HD Try to do the conceptual design Remind me next Monday or Tuesday and I ll post the solution From Connolly T Begg C Database Systems A Practical Approach to Design Implementation and Management Third Ed Addison Wesley 2002 Perfect Pets Case Study A practice called Perfect Pets provides private health care for domestic pets throughout America This service is provided through various clinics located in the main cities of America The Director of Perfect Pets is concerned that there is a lack of communication within the practice and particularly in the sharing of information and resources across the various clinics To resolve this problem the Director has requested the creation of a centralized database system to assist in the more effective and efficient running of the practice The Director has provided the following description of the current system 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 zipcode 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 zipcode 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 zipcode 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



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Requested Problem and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Requested Problem and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?