Activity 3

Activity 3

IT Service Delivery Solution 

What you need to produce 

🔏An Entity Relationship Diagram in PowerPoint (Unit 2)

🔧A Network Diagram in either Visio or Draw.io (Unit 11)

💻A Description of Hardware and Software in Word (Unit 1)

What is an ERD?

ERDs are used in database design and data modelling to depict the structure and relationships of data.

An Entity Relationship Diagram (ERD) is a visual representation of the relationships between entities within a database/information system.

They can help us understand database designers and stakeholders. Understand the data flow, structure and how different entities interact.

Key Terms 

Attributes: Attributes describe the properties or details of an entity. For example, an Employee entity might have attributes such as EmployeeID. 

Entities: These are objects in a database that store information. Entities are usually represented by rectangles. 

Primary Key: A primary key is a unique identifier for each record in a database table. It ensures that each row can be identified. 

Foreign Key: A foreign key is a field in one table that creates a link between the data in two tables. The foreign key in one table corresponds to the primary key in another. 

What attributes might an ERD for this scenario contain?

Entity	Attributes
Staff	StaffID (PK), Name, Role, Email, Phone, EmploymentType (Permanent/Casual), SupervisorID (FK)
Vehicle	VehicleID (PK), Type (Minibus/Coach), RegistrationNumber, Capacity, Status, LastServiceDate
Booking	BookingID (PK), CustomerName, CustomerContact, VehicleID (FK), StartDate, EndDate, Status, PaymentStatus
Maintenance	MaintenanceID (PK), VehicleID (FK), Date, Description, MechanicID (FK), Cost
Customer	CustomerID (PK), Name, ContactDetails, Email, Address
Payment	PaymentID (PK), BookingID (FK), Amount, Date, Method, Status

Example ERD

Finish the Entities and Attributes

Entity	Attributes
Office
Marketing
Security Camera

OfficeID (PK), Location, StaffAssigned

CampaignID (PK), Description, StartDate, EndDate, Channel (Website/Social Media/Press), ResponsibleStaffID (FK)


CameraID (PK), Location, Status, LastMaintenanceDate, RemoteAccess (Yes/No)

Data Flow DiagramExample

Activity Three Report 

Activity 3 is the biggest activity, most of the marks (20) and time are allocated to this task.

So far we have covered the ERD and DFD.

Activity 3 Report 

This report should be roughly 1-2

pages in length.

You now take each stakeholder

(Remember you have outlined them

already in Task 2) and comment on

the:

• Hardware, they have (based on

your decisions)

• Software (based on your

decisions)

• Data – what data do they need

and how has your solution

allowed them to access to this

data.

Exemplar 

This got 15/20, what do you feel is missing?

Examiners Report June 2024 

Using an online mind map software, take each job role and summarize the contents for it.

Make sure you highlight any key points you think would be useful for your exam. 

The examiners report is available on canvas.

Activity 3 Recap 

You are now going to be split into three groups.

Each group will be given one of the sections from activity three to focus on.

Each group will have an A3 sheet, create a guide on how you will complete your allocated task, this could be a mind map or set of steps. 

DFD

ERD

REPORT 

Is there anything you want to go over again from this lesson?