Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor.

The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor. The hospital has a pharmacy where the customers buy the medications. For every item in the inventory, the following information is recorded: identification number, name, description, price, quantity on hand and safety stock level. Construct an E-R diagram (based on a Chen's model) to represent the above
Transcribed Image Text:The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor. The hospital has a pharmacy where the customers buy the medications. For every item in the inventory, the following information is recorded: identification number, name, description, price, quantity on hand and safety stock level. Construct an E-R diagram (based on a Chen's model) to represent the above
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS