Question: Draw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address,

Draw an ER diagram using Cardinality Notation for the following description:

A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.

1. When making this diagram, I connected cat and dog to client with its own relationship. Is that allowed?

2. Would the cardinality of 0..5 and 0..2 for cats and dogs be on the line going to the ISA or the line connecting cat/dog to the relationship with the client?

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!

Draw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet...

Make an Entityrelationship diagram using Cardinality Notation: [Use ISA] A vet hospital only treats chickens and cows. The clients have a phone number, address, clienr ID. Each animal has a name, a...

Design and Entity Relation Diagram from the above case using crows foot notation. Draw an ER diagram that captures the entity sets, relationships and attributes of the Heimlers Property database. The...

The purpose of this assignment is to provide practice in conceptual database design, using the entity-relationship (ER) model Draw an ER diagram to model a database for a no-kill cat shelter,...

For each of the situations below, draw an ER diagram and a database design outline. A database design outline is a description of a database using the following notation. Primary key fields must be...

Using the notation as described in the PowerPoint slides and chapters 2 and 3 of the Hoffer textbook, prepare a conceptual model ( ERD ) that reflects the data and relationships of the following...

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and...

Scenario The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance...

CIS336 Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be...

Deluxe Design Company makes custom furniture. On December 1, there were two jobs in process: Job 683 with a cost of $14,200 and Job 684 with a cost of $23,500. Jobs 685, 686, and 687 were started...

How does caching improve access time and reduce bandwidth requirements? What are locations for a cache and their specific advantages?

Suppose a 5 5 - year, $ 1 comma 0 0 0 1 , 0 0 0 bond with annual coupons has a price of $ 8 9 7 . 5 4 8 9 7 . 5 4 and a yield to maturity of 5 . 9 % 5 . 9 % . What is the bond's coupon rate?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

9. If you were asked to develop a career management system, what would it look like? How might you evaluate whether it was effective? What information would you use to develop the system?

7. What are the managers roles in a career management system? Which role do you think is most difficult for the typical manager? Which is easiest? List the reasons why managers might resist...

6. What is a psychological contract? How does the psychological contract influence career management?