KEMBAR78
Hospital Database Design Guide | PDF | Finance & Money Management
Scribd
Upload
51 views2 pages

Hospital Database Design Guide

The document outlines a student's final project topic of a hospital database with two tables, Physician and Patient, identifying attributes for each table and the primary and foreign keys linking them.

Uploaded by

Julie Kiselev
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
51 views2 pages

Hospital Database Design Guide

The document outlines a student's final project topic of a hospital database with two tables, Physician and Patient, identifying attributes for each table and the primary and foreign keys linking them.

Uploaded by

Julie Kiselev
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1

FINAL PROJECT

Final Project Topic and Outline

Julie Khmelchenko

Dr. Thidarat

3/21/2021
2
FINAL PROJECT
After selecting and identifying your topic, complete the following:
 List at least two entities (i.e., tables) and identify primary key for each entity. Use
shorthand representation shown on page 32 of Concepts of Database Management (Pratt
and Last, 2015). Underline the primary key for each table.
 List attributes (i.e., columns) of each table. These attributes are data items that will be
stored in your database. Use shorthand representation shown on page 32 of Concepts of
Database Management (Pratt and Last, 2015).
 Identify the foreign key (i.e., which column, in which table). If you have two tables, there
should be one foreign key in one table that will link the two tables together. That column
must be the primary key of the other table.

Hospital Database
 Physician (PhysicianNum, FirstName, DOB, PhoneNum, RoomNum, Specialty,
LiscenceNum)
 Patient (PatientMRN, FirstName, LastName, DOB, PhoneNum, PhysicianNum)

PIMARY KEY (PhysicanNum)


FOREIGN KEY (PhysicianNum) REFERNCES Physician

You might also like