Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

5. (30 pts) For the following two relations, Patient and Doctor Patient Doctor 02 03 01 Patient ID Name DOB Gender Phone 128 279 Jack

image text in transcribed
5. (30 pts) For the following two relations, Patient and Doctor Patient Doctor 02 03 01 Patient ID Name DOB Gender Phone 128 279 Jack David Sasha 4-Apr-1990 Male 4567890 8-Aug-1973 Male 7265841 21-Mar-1995 Female 2147568 02 032 095 Heather 15-Jul-1989 Female 5871264 Lauren 09-5ep-1997 Female 3874135 Doctor Building- Doctor ID 01 02 03 Name Yuan Oberhoff Neurology Internal Internal A. Shastri 1) The degree of the Patient relation is (2 2) The cardinality of the Doctor relation is iven the data in the Patient relation, can the following attribute(s) be a primary key or foreign key? Answer yes or no? (8 points) rorigo Xey Primary Key Patient ID) Gender) Gender, Doctor) Patient ID, Doctor) 4) Given the data in the Doctor relation, are the following attributes super key or candidate key? Answer yes or no? (8 points) Candidate Key Super Key Doctor ID Specialty) Building) Doctor ID, Specialty) 5) If Doctor ID is a primary key of the Doctor relation, Its value in any tuple must not be NULL. True/false(2 points) This is an example of the entity integrity. True/false (2 points) 6) For Doctor ID in the Patient relation, Its value in any tuple may be NULL. True/false2 points) Its value in a new tuple may be 05. True/false (2 points) This is an example of the referential integrity. True/false (2 points)

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

Distributed Relational Database Architecture Connectivity Guide

Authors: Teresa Hopper

4th Edition

0133983064, 978-0133983067

More Books

Students also viewed these Databases questions

Question

List the components of the strategic management process. page 72

Answered: 1 week ago