Flashcards in 1h Diagram Tools Deck (4):
As guests check-in, they are currently registered on a database.
Three of the entities in the database are CUSTOMER, BOOKING and ROOM.
Draw an entity relationship diagram for this part of the database and state where a foreign key would be found.
a customer can book many rooms
a booking can consist of many rooms
1 for correct link entity
1 for correct degree of relationship between
CUSTOMER and ROOM
1 for correct degree of relationship between ROOM
1 for locating the foreign key in ROOM when
identified as the link entity
12 The estate agency requires a new ICT system to be developed.
(a) Create a data flow diagram to show the process below.
• A customer contacts the estate agency either by telephone or in person.
• An employee uses a form to record the customer details and the details of the property
and places in a folder.
• The employee makes arrangements to visit the property to photograph it and take details
• Whilst at the property the employee completes the form.
• On returning to the office the employee transfers all the details from the form onto a web
page and uploads it to the website. (6)
1 mark for links that have arrows connecting process – stores / entities - process 1 mark for recognisable and relevant data flow diagram
1 mark for identifying customer and property as external entities
1 mark for stage of customer, process and data store
1 mark for stage of property of to measurement process to measurement data store 1 mark for stage of creating web page from data stored
The dental surgery makes appointments for patients. The dental surgery has more than one dentist.
At each appointment, a patient will have at least one treatment. Payment is made after each appointment.
Create an Entity Relationship Diagram (ERD), resolving any many-to-many relationships and stating the degree of the relationship between the entities. (4)
Five of the above entities = 2 marks, OR
Four of the above entities = 1 mark
DENTIST - APPOINTMENT 1:M
PATIENT - APPOINTMENT 1:M
PAYMENT - APPOINTMENT 1:1
TREATMENT - APPOINTMENT M:1
Four of the above relationships = 2 marks, OR three of the above relationships = 1 mark