What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: HigherRelationalDatabasesPIQuestions
Select a size
Relational Database Questions
Relational Database Peer Instruction Questions
Q. When reading a relationship between 2 entities, the relationship is read:
from left to right
from right to left
from left to right and from right to left
takes part in
Q. Look at the diagram below and choose the ERDish sentence that describes the relationship.
Each Student can take part in one or more Sports.
Each Sport can be performed by one or more Students.
Each Student takes part in one Sport, each Sport is performed by one or more Student.
Each Sport can be performed by one or more Students, each Student can take part in one or more Sports.
A hospital uses a relational database to store details of wards and patients in two separate entities. Each ward in the hospital looks after many patients while each patient can be resident in only one ward.
Q. Which ERD correctly models the hospital system?
Q. What type of relationship is represented in the above diagram
Q. In a business that sells computer games, choose the best description of the relationship between CUSTOMER to GAME.
Each CUSTOMER can buy one or more GAMEs
Each CUSTOMER can buy one or more GAMEs, each GAME can be purchased by one CUSTOMER
Each GAME can be purchased by many CUSTOMERs, each CUSTOMER can buy one or more GAMEs
Each GAME can be purchased by one or more CUSTOMERs
Here is part of a relational database showing the tracks on a CD.
Q. What type of relationship exists between this CD and the tracks?
The following ERD is used to model a relational database about school basketball teams.
Q. Which descriptions fully describes this relationship?
Each player represents one team.
Each team is represented by many players.
Each player represents many teams.
Each player represents one team and each team is represented by many players.
Each player represents many teams and each team is represented by many players.
DriveAway Ltd are a car hire company with locations in six cities throughout the UK: Aberdeen;
Glasgow; York; Birmingham; London and Portsmouth.
Each location has a unique ID number. A wide range of cars are available at each location. Customers rent cars for a specific time period. The rental system operates under the following conditions.
One customer can make many rentals.
Each car is associated with one location.
Q. Which E-R Diagram represents the data model.
Q. Which term best describes this image?
Q. Which of the following terms best describes this image
BigTech Gadgets are organising an exhibition to showcase cutting edge developments in technology. BigTech Gadgets want to store the details of products being demonstrated by companies.
Some sample data is shown in the table below.
Q. To avoid data duplication, a database with two linked tables is proposed – EXHIBITOR table and PRODUCT table. Which of the following lists of fields is correct
A University database stores information about students and the tutor groups they belong to. The following E-R diagram shows the relationship between the two entities.
Q. Which of the following data dictionary extracts would be correct?
Tutor Group Code
Q. To avoid data duplication, a database with two linked tables is proposed – ACTOR table and FILM table. Which of the following lists of fields is correct.
Below is part of the data dictionary for the Result table
Q. Which of the following correctly defines the keys
(ii ) PK
B. (i) PK/FK
C. (i) PK
D. (i) PK/FK
(ii ) PK/FK
Lookup value from MEMBER table
Lookup value from DVD table
Q. The screenshot shows part of a data dictionary. Which one of the following fully describes the loan table
The Loan table has three primary keys
The loan table has a compound key consisting of: Member Number, DVD Code and Date Hired
The DVD Code in the Loan table is a primary key
A relational database is used to store details of the ski trails available in various holiday resorts. A table called Resort is used to store details of 7 different ski resorts.
A table called Trail is used to store details of the 181 trails in those 7 resorts. Part of that table is shown on the right
Q. A new ski resort with 12 ski trails has been opened in Scotland. Details of the trails must be added to the database . How should data about the new resort and it’s trails be added to the database?
Data about the new ski resort must be added to the Resort table after data about the trails has been added to the Trail table.
Data about the new ski resort must be added to the Resort table before data about the trails can be added to the Trail table.
Data about the new ski resort and its trails can be added at any time as soon as the information is available.
Look at the following data model.
Q. The company want data showing the number of rentals for each location. Which entities are required to produce this?
Location, Car, Rental
A relational database is used to store details of bookings for ski resorts.
The output shown is produced from the database.
Q. Which aggregate function is used to calculate the total number of bookings shown in the output?
A relational database stores details of customers, products and orders in 4 separate entities:
The database is used to support an e-commerce website. An HTML form is used to capture details of all orders placed.
Q. Which of the following statements is true?
The database file contains 4 related tables and the HTML form.
The database file contains 4 related tables.
The database file contains 4 related tables, the HTML form and PHP script used to add new order details to the Order and OrderItem tables.
Correct Answer C – all relationships need to be read in 2 directions – from left to right AND from right to left.
A – If a relationship makes sense reading from left to right it’s the correct one.
B – If a relationship makes sense reading from right to left it’s the correct one.
Correct Answer D – the diagram is read in 2 directions – from left to right AND from right to left.
A – this sentence only describes the relationship from left to right. All relationships can be read in 2 directions; from left to right AND from right to left.
B – this sentence only describes the relationship from right to left. All relationships can be read in 2 directions; from left to right AND from right to left.
C – although this sentence describes the relationship in 2 directions, the relationship in the diagram, indicates that each Student can take part in one or more sports.
Misconception: You can work out a relationship using your own knowledge instead of the information provided.
Correct Answer D) This ERD states that each ward looks after many patients; it also states that each patient is looked after (or is resident) in only one ward.
This ERD states that each patients is looked after (or is resident) in many wards.
This ERD states that a ward looks after only one patient; it also states that each patient is looked after (or is resident) in many wards.
This ERD states that each ward only looks after one patient,
Correct Answer B) Each doctor can have many patients but each patient has only one doctor
A) Although one of the Drs only has one patient, the fact that the others have more than one means that the relationship cannot be one-to-one
C) Over a persons lifetime they can have more than one doctor so one doctor has many patients and one patient can have many doctors
Correct Answer C – The relationship needs to be read in two directions to identify that it’s a many to many relationship
A – this describes half of the relationship. It does not indicate how many CUSTOMERs can purchase each GAME.
B – the first half of the description is correct but each GAME can be purchased by one or more CUSTOMERs.
D - this describes half of the relationship. It does not indicate how many GAMEs each CUSTOMER can purchase.
Misconception: The ER model exactly matches every possibility that can happen in real life.
Correct Answer B) One CD has many tracks
Learner is just guessing as a CD would never just have one track.
One CD has many tracks but one track isn’t on many CDs in this example.
One CD has many tracks and one track can be on many CDs. This happens all the time with best of collections etc.
Misconception: A relationship can be fully understood by examining it in just one direction
Correct Answer D) Each player represents one team and each team is represented by many players.
A) Each player will belong to one team. This is only partially correct as this is only one side of the relationship.
B) Each team has many players. This is only partially correct as this is only one side of the relationship.
C) The many part of the relationship is with players so each player represents many teams. They aren’t reading the relationship correctly
E) Each team has many players and each player has many teams. They may be using their background knowledge instead of the diagram. It is possible that some people belong to more than one sports team even in the same sport.
Correct Answer A: Many cars only have one location and a particular rental can only be for one car. Finally a customer can make many rentals but a rental is only for a specific customer.
B: Each car has one location so the pupil is thinking about specific instances not the collection of all cars.
C: Each customer can visit many locations because the pupil is using their intuitive knowledge rather than the description.
D: Each customer can rent many cars but this would be a many to many relationship however we need an intermediate entity to create the association.
Misconception:- The complete set of data in a table is the same thing as the database or the database file.
Correct Answer B) This is a table within the database and there can be more than one table
A) This is a database because it has all of the information that is being stored
C) Records are organised into a file so it’s a file.
Misconception- Data dictionaries are the same as a database, entity or table.
Correct Answer- D this is a data dictionary because it lists the data types and validation rules.
A- It lists the name of the entity and the attributes it has. Confusion between logical design and the design for the implementation.
B- This is all of the information stored in the database.
C- The information is arranged into a table.
Correct Answer A:-
Correct Answer C)
Correct Answer- B
Misconception: Where the foreign key is placed depends on the location of the table relative to the other one.
Correct Answer- D Foreign keys go on the many side of a relationship no matter what side it is.
A Foreign keys always go on the one side of the relationship
B Foreign keys always go into the table on the right side of the relationship
C Foreign keys always go into the table on the left side of the relationship
Misconception: You can have more than one primary key in a table
Correct Answer B) A compound key is shown by a PK against each of the fields that will be included in the key.
A) These three fields are marked as PK so they are the primary keys
C) DVD’s are the things being loaned so DVD code is the main primary key
Misconception: New instances can be added to a table with a foreign key value that doesn’t have a corresponding entry in the linked table yet.
Correct Answer B) Resort is a foreign key in the Trail table. By adding details of the new resort to the Resort table first, the resort name can then be selected from the drop down list of known resorts in the Trail table.
The trails need to be added before they are linked to a particular resort.
C) It doesn’t matter the order in which resorts and trails are added to the database.
Correct Answer A:- Information from linking table Car is needed in order to match a particular rental to it’s location
B:- They haven’t read the question carefully enough
C:- They haven’t read the question carefully enough
D:- You need information about the locations and information about rentals
Misconception: Confusion about which aggregate function to use for particular types of problem
Correct Answer D) SUM
A) Random guess due to not reading the question and scenario carefully enough. Average would be 2.67 bookings.
B) You need to count the booking for each resort. They haven’t looked at the output carefully enough otherwise they would see the number of bookings for each resort is already known.
C) Random guess due to not reading the question and scenario carefully enough. Max would be 5 bookings.
E) Total because you need to create a total number of bookings. They can’t distinguish between what they’d like the database to do and the function that is required to carry this operation out.
Misconception: User interface elements are part of the database data.
Correct Answer B) The database file stores the data in tables and all of the files to display the data are stored separately.
A) The database store the 4 tables and the HTML form as it’s being used to display the data. The learner doesn’t realise data return by the database engine can be processed by another program or system.
D) The database stores the data in the tables, the HTML form and the PHP script used to add new order details to the Order and OrderItem tables. The learner doesn’t realise other programs and systems can send queries to manipulate data stored in the database.itive knowledge rather than the description.
B) You need to count the booking for each resort. They haven’t looked at the output carefully enough otherwise they would see the number of