Systems Analysis & Design Assignment 1
Student Number: 17303037
Systems Analysis & Design Assignment 1 Question 1 (data modelling) (7 marks): Create an entity relationship diagram (ERD) to represent the data requirements for the SHP reservation system. Add attributes to each data entity and show the primary keys (identifiers). Add correct relationships between entities, including multiplicities (cardinalities). Decompose any many to many relationships. Entity Relationship Diagram: Sunshine Holiday Park
Page 1 of 5
Student Number: 17303037
Question 2 (process modelling) (9 marks):
a) Draw a context diagram for the SHP reservation system. (1 mark)
Customer inquiry
Availability
Receptionist
Reservation System
Customer
(SHP)
Payment
Confirmation
b) Create an event table for the high level events that the SHP reservation system must be able to respond to. (The event table does not need to be handed in). Using the event table, create a data flow diagram (DFD) level 0 for the SHP reservation system, including (but not limited to) the high level process mentioned in part c below. Clearly identify and label all the processes, data stores, external agents and data flows. (6 marks) Event
Trigger
Source
Use Case
Response
Destination
Customer Checks Cabin and Site Availability
Cabin/Site Inquiry
Customer
Search for available cabins/site
Cabin/site Availability
Customer
Customer Reservation Customer/System Search for Information Books available on reservations availability Reservation requested by User Customer Selects Site
Vacancy
Customer Selects Cabin
Vacancy
System
System
Site Selection
Site specified chosen
Cabin Selection
Specified Cabin
Page 2 of 5
SHP System
SHP System
SHP System
Student Number: 17303037
Question 2)b) 1 Collection of order/customer details
3
Customer ID
Customer info
Check out Customer
Customer Checks Availabilities
Availabilities made, Customer Reservates .
SHP Staff 2 Check In
Page 3 of 5
Customer and reservation details
Student Number: 17303037
Question 3 (user interface/report design) (4 marks) a. Create the user interface design for making a new reservation for a customer. (2 marks)
Page 4 of 5
Student Number: 17303037
B) Create the report design for showing the monthly summary of number of nights each cabin and site have been rented out. (2 marks)
Monthly Bookings Jan Feb Mar Aprl May June July Aug Sept Oct Nov
Page 5 of 5
Systems Analysis & Design Assignment 1 Question 1 (data modelling) (7 marks): Create an entity relationship diagram (ERD) to represent the data requirements for the SHP reservation system. Add attributes to each data entity and show the primary keys (identifiers). Add correct relationships between entities, including multiplicities (cardinalities). Decompose any many to many relationships. Entity Relationship Diagram: Sunshine Holiday Park
Page 1 of 5
Student Number: 17303037
Question 2 (process modelling) (9 marks):
a) Draw a context diagram for the SHP reservation system. (1 mark)
Customer inquiry
Availability
Receptionist
Reservation System
Customer
(SHP)
Payment
Confirmation
b) Create an event table for the high level events that the SHP reservation system must be able to respond to. (The event table does not need to be handed in). Using the event table, create a data flow diagram (DFD) level 0 for the SHP reservation system, including (but not limited to) the high level process mentioned in part c below. Clearly identify and label all the processes, data stores, external agents and data flows. (6 marks) Event
Trigger
Source
Use Case
Response
Destination
Customer Checks Cabin and Site Availability
Cabin/Site Inquiry
Customer
Search for available cabins/site
Cabin/site Availability
Customer
Customer Reservation Customer/System Search for Information Books available on reservations availability Reservation requested by User Customer Selects Site
Vacancy
Customer Selects Cabin
Vacancy
System
System
Site Selection
Site specified chosen
Cabin Selection
Specified Cabin
Page 2 of 5
SHP System
SHP System
SHP System
Student Number: 17303037
Question 2)b) 1 Collection of order/customer details
3
Customer ID
Customer info
Check out Customer
Customer Checks Availabilities
Availabilities made, Customer Reservates .
SHP Staff 2 Check In
Page 3 of 5
Customer and reservation details
Student Number: 17303037
Question 3 (user interface/report design) (4 marks) a. Create the user interface design for making a new reservation for a customer. (2 marks)
Page 4 of 5
Student Number: 17303037
B) Create the report design for showing the monthly summary of number of nights each cabin and site have been rented out. (2 marks)
Monthly Bookings Jan Feb Mar Aprl May June July Aug Sept Oct Nov
Page 5 of 5
