Higher Database Design & Development

A relational database is developed for a hospital. State which of the following are end-user requirements.

• The nurses must be able to count how many patients should be in each room.

• The doctors must be able to change the diagnosis of a patients.

• The database must store information about the staff, patients, rooms and appointments.

• A simple update query will be used to change the room that a patient occupying.

• A complex search query will be used to show the details of a patient's appointment by searching using their patientID and appointment date and appointment time.

A relational database is developed for a hospital. State which of the following are functional requirements.

• The nurses must be able to to enter a new patients into the database.

• The receptionists must be able to add a new appointment for the patient and assign it to a doctor and room.

• The database must allow the patients current medication to be updated using a simple update query.

• A simple search query will be used with wildcards to allow the user to search for a patient using just the first letter of their surname.

• A complex search query will be used to show the details of a patient's appointment by searching using their patientID and appointment date and appointment time.

State the cardinality between the two table shown in the Entity Occurrence Diagram

• One to one

• One to Many

• Many to Many

State the cardinality between the two table shown in the Entity Occurrence Diagram

• One to one

• One to Many

• Many to Many

State the cardinality between the two table shown in the Entity Occurrence Diagram

• One to one

• One to Many

• Many to Many

State which of the following Entity Occurrence Diagrams correctly demonstrate some or all of the relationships between the entities in the Entity Relationship Diagram shown.

• 
• 
• 
• 

State the purpose of a compound key.

• To join multiple fields together to create a unique combination of data that can be used in place of a primary key.

• An aggregate function that is used to calculate compounding interest in a financial database.

• Used in conjunction with the primary key to create a unique identifier for each record.

• Used in encryption to decrypt and encrypt plain text messages.

Using the image provided, state a suitable compound key.

• StudentID + CourseID

• CourseID + EnrollmentDate

• StudentID + CourseID + ExamDate

• ExamDate + ExamTime

The data dictionary shown is used to store the details of when an employee is working in a shop. State the errors with this data dictionary.

• Wrong Primary Key

• Should use a Compound Key

• Validation missing condition on Department field

• Incorrect data types

• Sizes are incorrect

State any errors that are present in the data dictionary shown.

• Birthday should have a length check

• The entity should have a compound key

• The field EmployeeID should not have a presence check

• StoreID should have referential integrity applied to it in the validation

• There are no errors