In the design process of the Hospital Database, relations that have been created. then they have to be normalized to remove dependencies as well as update anomalies. With the help of Database Design language(DBDL), the tables that have been created can be broken down and separated between the primary key, alternate key as well as the foreign key (Pratt & Last, 2014) .
As per the rule of DBDL, the keys are identified as follows, primary key as PK, alternate key as AK, secondary key as SK and foreign key as FK. Thus defining the tables of the hospital database will be represented by initial when the database is normalized (Pratt & Last, 2014) .
Delegate your assignment to our experts and they will do the rest.
The tables are as follow:
Physician ( staffID , LastName, FirstName, emailAddr, DOB,postalCode, salary,JobID, depNum)
PK= staffID
SK=LastName
AK=JobID
FK= depNum
Patient ( PatID , LastName, FirstName age, sex, weight, DOB, medcoverID,depID )
PK= PatID
AK=MedcoverID
SK=LastName
FK=depID
In the above notation, the tables have been normalized, and update anomalies have been removed.
Moreover, the attributes of each key have been clearly shown, or the columns associated with each has been revealed. Thus the Hospital Database integrity has been put in places which will ensure the Hospital database records consistency, durability, isolation and atomicity of the database. Every database has the following keys that clearly distinguishes attributes within each database (Pratt & Last, 2014).
References
Pratt, P. J., & Last, M. Z. (2014). Concepts of Database Management . Boston, MA: Cengage Learning.
