Assignment Project - Design and Build an Information System
Developing an Information System for the Revenue Process.
Al Lee Exotic Gifts Pty Ltd Part 1 Requirements: Design an Information System
1. Completed ASIC form 201: Application for registration as an Australian company.
2. Create a Gantt chart in Microsoft Project showing project milestones and responsibilities in the design phase.
3. An engagement letter to the client outlining the project and your company's solution.
4. Create a process narrative table in Word (refer below) for Al Lee Exotic Gifts Pty Ltd. This table will help you with each step of the project and should facilitate drawing the DFDs, flowcharts and REA model. In addition, it should help with the database design related to table attributes, forms, and reports needed to meet user requirements. Please note: the first three entries have already been entered for you in the table.
|
No.
|
Division/Dept.
|
Entity
|
Input - (receives)
|
Process/Activity
|
Output - (sends)
|
|
1
|
|
Customer
|
|
|
New Customer details or Customer Number
|
|
2
|
Sales
|
Salesperson -Ali
|
New Customer details
|
Enter customer details into computer
|
Customer details keyed data
|
|
3
|
Computer
|
|
Customer details keyed data
|
Allocates new customer number and saves
|
New customer number
|
5. Prepare two Process Maps in MS Visio - Sales Order and Cash Receipts Processes.
6. Prepare data flow diagrams in MS Visio (Context, physical, and Level 0 - logical data flow diagram) of the Sales Order and Cash Receipts systems described.
7. Create systems flowcharts in MS Visio of the Sales Order and Cash Receipts Processes.
8. Develop a Resources Events Agents (REA) diagram for the revenue cycle, with cardinalities based on the procedures described in the narrative and requirement 4 above. Use the REA Entity-Relationship (ER) modeling techniques as discussed in class.
9. Convert your REA diagram into a relational database structure, i.e. tables and relationships. At this stage you are designing the database on paper. There is no need to start entering it in Access until Part 2 of the assignment. Make sure you use meaningful table and attribute names and show primary and foreign keys. Use the conventions as discussed and shown in classes.
10. Self and Peer Assessment of Contribution to the Team Project.
11. Continuity (i.e. consistency between all submitted items).
12. Overall company professionalism.
Attachment:- Assignment File.rar