1h Diagram Tools

Question 0

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
and measurements.
• 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)

Answer 0

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

Question 1

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.

Answer 1

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
and BOOKING
 1 for locating the foreign key in ROOM when
identified as the link entity

Question 2

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)

Answer 2

Entities:
 APPOINTMENT
 PATIENT
 DENTIST
 TREATMENT
 PAYMENT
Five of the above entities = 2 marks, OR
Four of the above entities = 1 mark
Relationships:
 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

Question 3

A restaurant books tables for customers using a database. The restaurant has more than one table.
(a) Resolve the many to many relationship between TABLE and CUSTOMER. [2]

TABLE Many-Many CUSTOMER

Answer 3

Resolve the many to many relationship between TABLE and CUSTOMER.
Correct Answer Only:
 new entity in correct location (1)
 correct degree of relationship between TABLE and new entity
and new entity and CUSTOMER (1)