Higher Database Design & Development
Authored by Chris Meechan
Instructional Technology
10th - 12th Grade
Used 31+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
25 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
1 min • 2 pts
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.
2.
MULTIPLE SELECT QUESTION
1 min • 3 pts
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.
The Database must be able to store the Doctor, Staff and Patient details. This should include validation to ensure the data that is being stored is valid and correct.
3.
MULTIPLE CHOICE QUESTION
0 sec • 1 pt
State the cardinality between the two table shown in the Entity Occurrence Diagram
One to one
One to Many
Many to Many
4.
MULTIPLE CHOICE QUESTION
0 sec • 1 pt
State the cardinality between the two table shown in the Entity Occurrence Diagram
One to one
One to Many
Many to Many
5.
MULTIPLE CHOICE QUESTION
0 sec • 1 pt
State the cardinality between the two table shown in the Entity Occurrence Diagram
One to one
One to Many
Many to Many
6.
MULTIPLE SELECT QUESTION
1 min • 3 pts
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.
7.
MULTIPLE CHOICE QUESTION
0 sec • 1 pt
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.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
