|
Basic
Database(s)
Admissions
- Hospital Patient Admissions
This is a very
simple database with three tables: Patients, Diagnostic Codes, and
Admissions. The Admissions Table is an intersection table, with two
foreign keys, implementing the many-to-many relationsahip between
Patients and Diagnostic Codes. There is also a table constraint on
the Admissions table that ensures that discharge dates are greater
than or equal to the admission dates. In addition to the table
constraint, there are various column constraints (validations) as appropriate.
All of the
relationships in this database are of the "HAS-A" variety.
There are no "IS-A" (supertype/subtype) relationships.
Download
here (you may have to right click, then save target as)...
|
