Question
Given the following tables, identify Pk and FK of each able DOCTOR (doc_ID, doc_name, specialty, DOB) assumption a doctor has single specialty HOSPITAL (app_ID, hosp_id,
Given the following tables,
identify Pk and FK of each able DOCTOR (doc_ID, doc_name, specialty, DOB) assumption a doctor has single specialty
HOSPITAL (app_ID, hosp_id, Host_name, hosp_address, doc_ID, pat_ID) PATIENT (Pat_ID, pat_name, pat_address)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Modeling And Design
Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
5th Edition
0123820200, 978-0123820204
