List:

• The primary key for each relation
• The candidate keys (if any) for each relation
• The foreign keys (if any) for each relation
• The domain of each attribute
• Two semantic constraints

Patient (number, fname, lname, SSN, dateofBirth)

Department (description, code, name, supervisor, building)

Description	Code	Name	Supervisor	building
facility where surgical operations are carried out in a sterile environment.	OPR	Operating	77881234	BlockB
medical treatment facility specializing in acute care of patients who present without prior appointment	EMM	Emergency	54546677	BlockA
systematic documentation of a single patient's medical history and care across time within one particular health care provider's jurisdiction	MDR	Medical record	99778525	BlockA