Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plzzzz help Questions 14-16 refer to the Entity-Relationship diagram below: Cares for Owner Ownerld {PK} OwnerAndPet Ownerld{PK} PetID{PK} 11..1 includes 1..1 Has Immunisation History Historyld{PK}

plzzzz helpimage text in transcribed

Questions 14-16 refer to the Entity-Relationship diagram below: Cares for Owner Ownerld {PK} OwnerAndPet Ownerld{PK} PetID{PK} 11..1 includes 1..1 Has Immunisation History Historyld{PK} PetID Pet PetID{PK} 14) Which of the following statements is NOT supported by the entities, attributes and relationship modelled? a) An owner may have many pets b) A Pet must have immunisation history c) A Pet may have many owners d) The primary key for the OwnerAndPet entity is a composite key 15) How many tables would be needed to construct a database to implement this ERD? a) 0 b) 2 c) 4 d) 5 16) The foreign key(s)s in this ERD are: a) HistoryID, PetID, OwnerID b) OwnerID and HistoryId c) PetID and OwnerId d) OwnerId 17) Which of the following is an objective of the ANSI-SPARC 3 level architecture? a) Increased data redundancy b) A users view should be immune to changes made in other levels c) A user should be aware of changes made at the physical level d) None of the above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions