System Design IMSE2113 – Intro. to Information Systems 2019 | March | 11
Assignment 2
Plan and design a web application from user requirement
Requirements
th Due Date: 2019 March 11
@ 5PM
Design a web application using the system design approached introduced in the tutorial, you are required to submit the following works:
1. Short description of your system, including the objective, users, etc.
2. Requirement description of the system, with each system user, objects, and methods highlighted
3. Conceptual Database Design of the system, write a short description on your database design. For each table, clearly specify the attributes, keys, and data types; draw the final design using ERD
4. Use case model of the system, with a narrative specification for each use case. Please limit your system to within 25-30 use cases
5. Activity diagram and Sequence diagram for each use case
6. Create wireframes for each of the proposed page. Share your U I wireframes with the TAs . For details, refer to the Submission Section
Submission
1. Submit your assignment as a zip file to Moodle before the submission deadline (i.e. 2019 March 11th @ 5PM)
• Pool all your texts and diagrams into a single word file and name it with your UID (e.g. 2019123456.doc)
• For the UI wireframes you’ve created on Lucidchart, name it also with your UID (e.g. 2019123456) and share it with the TAs on Lucidchart.
– Under My Documents, select the wireframe drawing and click the ”+” sign at the lower– right corner; then select TA names and choose ”can view”, and send the invitation
IMSE2113 – Assignment 2 Last modified: January 28, 2019 1
System Design
IMSE2113 – Intro. to Information Systems
2019 | March | 11
Grading Criteria
Criteria %
System Description & Requirement 10% Conceptual database design 20% Use case model with narrative specifications 25% Activity diagrams 15% Sequence diagrams 15% Wireframes 10% Creativity 5%
Penalty
• Late submission will not be entertained, 100% penalty (zero mark ) will be strictly enforced
• Any act of plagiarism will disqualify the submission, zero mark will be awarded for the assignment
IMSE2113 – Assignment 2 Last modified: January 28, 2019 2
System Design IMSE2113 – Intro. to Information Systems 2019 | March | 11 Assignment Topics
Each systems’ user requirements are listed below, you are required to translate the user requirements into system requirements (describe what the system should or should not do, instead what the user expect the system to do). You are required to design your system to fulfil all user requirements while keeping an appropriate system scope for implementation, so please include the use cases that’s absolutely essential to the system.
Topic 1 – Wine Cellar management system
General idea: Information system to keep track of different goods in this Wine Cellar. Keep track of information of different wine, which section are they stored, user can check inventory level of each wine. Track stock movement for marketing decisions.
User requirements:
R1: I want to find wine from specific country and year, check the amount of stocks remaining and reserve a certain amount
R2: I would like to be able to move inventory to different wine cellar or add new purchased stocks into the current cellars. I would need to check if the cellars inventory status.
R3: I would like to check What type of wine have been reserved most frequently under different time frame and visual reminder to restock.
R4: I would like to monitor which user have moved inventory and reserved inventory to track staff performance records
R5: I want a report to show a snapshot of the wine cellar at the current time with a report of the most popular wine.
IMSE2113 – Assignment 2 Last modified: January 28, 2019 3
System Design IMSE2113 – Intro. to Information Systems 2019 | March | 11 Topic 2 – Cargo Port management system
General idea: information to keep track on cargoes entering and leaving port. Manage port conditions and inventory levels.
User requirements:
R1 – I would like to check the status of each Port and which one is most suitable for the new cargo arrival. I should also know what equipment are available for each port and it will recommend the suitable port for my cargo
R2- I would like to find out existing customer’s information and relationship with the company and identify loyal customer for marketing purposes.
R3- I would like to identify any items that are overdue in our storage. I would like to move these storages to other areas and contact the client on extra fees
R4. I would like a snap shot report on the current status of selected areas (or all areas) to gain better understanding of the utilization of the port.
R5. I would like to identify the trend on goods moving in the port to help formulate future developments to accommodate the increased demands.
Topic 3 – imseCAVE inventory system
General Idea: There are large variety of equipment in the imseCAVE, ranging from cables, HTC VIVE, projectors etc. The equipment could be used by people in the team or could be delivered to clients (external).
User requirements:
R1. Check the Item profile when searching through serial number, track the quantity and location of the item
R2. Can search the serial number of an item when looking for a specific type of good
R3. Can easily edit the quantity of the goods in inventory, warning when inventory is low
IMSE2113 – Assignment 2 Last modified: January 28, 2019 4
System Design IMSE2113 – Intro. to Information Systems 2019 | March | 11 R4. Clear record on time when borrowing equipment and time of return
R5. A snapshot on the current condition of the storage and inventory.
Topic 4 – Handmade music box workshop
General idea: A small business building music box on order from clients. They want a web application to help them manage orders and identify the parts they need to restock to satisfy the orders the receive. Careful inventory management is important as a small business they cannot afford to overstock on parts.
User requirements:
R1. I would like to show all the different models and songs I could provide on the website R2. I would like my clients to be able to order music box, mix and match songs and items
R3. I would like to know the inventory level of different parts of the music box, identify low inventory and different parts required to build a model music box
R4. I would like to add promotions and recommendations to customers for different events on the web application
R5. I would like a section for customers to leave feedback for my products and I could evaluate which the performance of each order to improve.
Topic 5 – Local restaurant
General idea: A restaurant near HKU trying to captivate as many customers as possible by introducing an online
ordering system. They also want to use the web application and promotion and communication strategy to the
IMSE2113 – Assignment 2 Last modified: January 28, 2019 5
System Design IMSE2113 – Intro. to Information Systems 2019 | March | 11 students.
User requirements:
R1. Allow online order for takeout, delivery or booking for a table and order food ahead of time.
R2. Kitchen staff/delivery staff can keep track of recent orders or urgent orders to manage their time in preparing food in the kitchen. Staffs are not proficient in computer skills; the interface have to be clear and user-friendly
R3. Identify popular dishes, provide promotions information on front page, loyalty programs, allow users to feed back on service or food quality
R4. Manage inventory and ingredients on back end (not for public users). Track what kind of ingredients are being used for ordered dish and double check on stock level. Allow user to put items off the menu if out of stock and order from suppliers
R5. Snapshot of inventory level, basic information of ingredients, suppliers and recommendation on restocking or not.
IMSE2113 – Assignment 2 Last modified: January 28, 2019 6