Assignment
TASK 1 : Interviewing the Client/prospective customer
Adopt design thinking approach to interview prospective customer in order to get choice appointments system requirements. Tutor is your customer.
Based on the missing information identified in assignment scenario design a set of interview questions to determine complete set of requirements from the client (Choice Appointments). Conduct interviews with the client. Document the method used in the design thinking approach.
Discuss weekly team meeting reports to your tutor providing details of the agenda, task allocation and minutes of meeting. Each member of the team will present and demonstrate the task or tasks they have completed in the assignment. The presentation and demonstration will take place after the submission of the assignment.
TASK 2: Work-Centred Analysis Framework -
Identify and define the six system elements in the Choice Appointments case study based on work-centred analysis framework. Also list missing information or system elements
TASK 3: Performance Analysis - Business Value and Customer Value -
Conduct a Performance Analysis of Business Process and Product/Output Components identified in Task 2 to determine business value and customer value gains which can be obtained through design and deployment of an information system as sub-system of the work system.
TASK 4 : Architecture of the Information Component -
A. Develop an Entity Relationship Diagram (ERD) to represent the data identified in the information component of work-centred analysis framework for choice appointments information management system. The diagram of your ERD model must:
- Show all necessary entities, attributes and relationships
- show unique identifiers and nature of interaction between entities.
B. Map the ERD into a set of relations in at least Third Normal Form (3NF). You should demonstrate that each relation satisfies the rules for first normal form, second normal form, and third normal form. For example:
PROPRIETOR (ProprietorID, FamilyName, GivenName, PhoneNbr)
This relation is in 1NF because it does not contain any repeating groups. In your report you must also include a data dictionary. You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc.
Entity: PROPRIETOR - Each instance of proprietor is a person, who owns the kitchen.
|
Attribute
|
Meaning |
Data
Type
|
Format |
Other
|
|
ProprietoriD
|
A unique identifier of a proprietor.
|
integer
|
|
Index -Yes (No
Duplicates)
|
|
FamilyName
|
Family name of a proprietor
|
Text(20)
|
|
Example. "Hocking"
|
|
GivenName
|
First name of a proprietor
|
Text(20)
|
|
Example. "John"
|
|
PhoneNbr
|
Phone number of a proprietor
|
Text(12)
|
|
Not Null
|
TASK 5: Business Process Architecture - Data Flow Diagram (DFD) -
Using DFD techniques draw the context diagram of Business Process Architecture of choice appointments System. Also draw level 0 data flow diagram showing the major sub-processes, data stores and flow of data between various sub-processes or steps in the business process component.
The submitted work will therefore comprise: A Microsoft Word document containing:
1) Application of Design thinking approach as an interview methodology for determining the requirements of your information management systems
2) Mapping of requirements identified through the design thinking approach on to the 6 system elements of work-centred analysis framework.
3) Performance Analysis of business process and product/output components of Choise Appointment information management system
4) A list of brief descriptions for each entity and attribute that you have identified in your case study.
- A copy of your entity-relationship model(s).
- A copy of relational tables in 3rd normal form
- A list of any assumptions that you made (include any clarifications from your tutor).
- Context and level 0 dataflow diagram.
- Declaration form (Section
Assignment 2
Phase 2: Relational Database Implementation
TASK 6: - Data Dictionary - submission date:
In your report, you must include a data dictionary based on given model solution (i.e., normalised ERD). You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc. See table above, example of data dictionary.
TASK 7: - Database Implementation
A. Implement your data dictionary to create a relational database in Microsoft Access.
B. Create relationships and enforce referential integrity for all appropriate relationships in the database as appropriate.
C. Populate the database with sample data. Sufficient sample data must be included to demonstrate that the queries, view(s), and report(s) work correctly.
D. Create view objects ("SQL queries" in MS Access) to obtain tables that demonstrate following reports. (Note: it is strongly recommended that you do not use the Access query builder (QBE) - you should type the SQL queries in manually.)
E. Finally, write four reports, requiring a separate query to satisfy information needs of Choice appointments and their clients
Save the database structure, test data and query/report designs to the USB and submit during your group presentation. However, printout the result of your forms and reports and include these in the online submission.
TASK 8: User Manual -
Create a user manual for your Choice appointments Information System. This manual should explain all the features of your database and how to do each task. The manual should also include screen shots of what you are explaining. Screen shots can be taken by pressing Alt+PrintScreen, and then pasting it into your document.
TASKS 6, 7 and 8 are due on: st May
Submission for tasks 6, 7 and 8: soft online and Access database USB during your presentation time.
TASK 9: 10 minute Presentation and Demonstration of Tasks 1 to 8 in the lab in week 11 and 12
Attachment:- Scenario and Background.rar