System analysis and design
Budget: £10 – £70 GBP
This is an individual assignment. Choose a business process that is performed by an organisation, such as
• Automating a technical support system (Help Desk)
• Booking a seat at a theatre
• Buying a car insurance policy
For your chosen process:
• Briefly describe the business process that you selected and its functionality.
• Construct a Data Flow Diagrams (DFD) for it.
• Construct an Entity Relationship Diagram (ERD).
• Design and implement an Access database system for your chosen process.
• Submit a report documenting both the analysis and implementation of your system. Your report must include (not included in the word count) the following diagrams:
o Data Flow Diagrams: levels 0, 1 and 2
o Entity Relationship Diagram: The entities needed to support the business processes.
o Screen shots of your database SQL tables and queries.
You are required to produce an 800-word report (plus or minus 10%). It is permissible to go 10% over the target word count. Any material that goes beyond the target plus 10%, however, will not be considered during the marking process
• Automating a technical support system (Help Desk)
• Booking a seat at a theatre
• Buying a car insurance policy
For your chosen process:
• Briefly describe the business process that you selected and its functionality.
• Construct a Data Flow Diagrams (DFD) for it.
• Construct an Entity Relationship Diagram (ERD).
• Design and implement an Access database system for your chosen process.
• Submit a report documenting both the analysis and implementation of your system. Your report must include (not included in the word count) the following diagrams:
o Data Flow Diagrams: levels 0, 1 and 2
o Entity Relationship Diagram: The entities needed to support the business processes.
o Screen shots of your database SQL tables and queries.
You are required to produce an 800-word report (plus or minus 10%). It is permissible to go 10% over the target word count. Any material that goes beyond the target plus 10%, however, will not be considered during the marking process