Activity 3
IT Service Delivery Solution
Activity 3
IT Service Delivery Solution
Deze slide heeft geen instructies
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)
Deze slide heeft geen instructies
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.
Deze slide heeft geen instructies
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.
Deze slide heeft geen instructies
What attributes might an ERD for this scenario contain?
Deze slide heeft geen instructies
Example ERD
Deze slide heeft geen instructies
Data Flow DiagramExample
Deze slide heeft geen instructies
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.
Deze slide heeft geen instructies
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.
Deze slide heeft geen instructies
Exemplar
This got 15/20, what do you feel is missing?
Deze slide heeft geen instructies
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.
Deze slide heeft geen instructies
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?
Deze slide heeft geen instructies