Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
INFS1603 Introduction to Business
Team Assignment
Phantom App Store
2 | P a g e
Contents
1. Overview
2. Key Dates
3. Formation of Groups and Contract agreement
3.1 Formation of Groups
3.2 Contract Agreement
3.3 Tips based on Previous Experience
4. Private Group Channel (in Microsoft Teams)
4.1 Planner
5. Case Study
5.1 Phantom App Store (PAS) Case
5.2 SQL Queries Requirements
6. Tasks and Deliverables
6.1 Report A: Tasks, Format and Deliverables
6.2 Report B: Tasks
6.3 Report B: Format and Deliverables
6.4 Video Presentation
7. Teamwork
8. Self and Peer Assessments
9. General Rules
9.1 Proper Academic Conduct
9.2 Assignment Submission
10. Rubrics
11. References
3 | P a g e
1. Overview
For this assignment, you will be assessed on:
(1.) Two written reports (Part A and Part B)
(2.) Implement a database system using Oracle in Part B
(3.) Video presentation in Part B
• The assignment is worth 30% (Part A 10% and Part B 20%) of the marks of the
course.
• The assignment is to be undertaken in groups of four (three or five is allowed)
students, all of which must be from the same lab class.
• Please note that some of the requirements are based on number of
students/members in a group.
For example, a group of five members is expected to create an ER Model
with a minimum of 20 entities whereas a group of three members only has to
create a minimum of 12 entities of ER Model.
• You will need to:
• Use the modelling knowledge you gain from the lectures, class exercises
and textbook to develop the ER model in Assignment Report A.
• Use the modelling knowledge you gain from the lectures, class exercises
and textbook to develop the relational model.
• Use the Oracle skills you gained from the labs, lab exercises and textbook
to complete the Oracle SQL implementation.
• The group will be awarded a group mark as a baseline mark. This baseline
mark may or may not be adjusted for the individual group members (based on the
within group peer review).
Important:
• Make every effort to learn Oracle, including outside the lab!
• Keep backup copies of all your work!
• Hold group meetings at least once, better twice, per week!
• Define roles and responsibilities within the team; especially you will need a Team
Leader (group coordinator for handling submissions, scheduling meetings, etc.).
• Get started as soon as possible!
4 | P a g e
2. Key Dates
What? When?
Project group formation (students need
to find their own groups)
Week 2 Tutorial
Assignment Part A Due: Submission of
assignment written report
PDF file submission via Moodle before
Wednesday, 29th June 2022, 11:00 am (Sydney
Time) (Week 05)
Assignment Part B Due: Submission of
assignment written report
PDF and ZIP file submission via Moodle before
Friday, 29th July 2022, 3:00 pm (Sydney Time)
(Week 09)
Video (Face-to-Face and Overseas
Online classes) presentations
Video file submitted via Moodle before Monday,
1st August 2022, 3:00 pm (Week 10)
5 | P a g e
3. Formation of Groups and Contract agreement
3.1 Formation of Groups
• You will sign up to a group in your class.
• All group members must come from the same class.
• You will form a group of four (three or five is only allowed if there is an uneven
number of students in the class, and can only be approved by the tutor)
• A team leader should be elected. The team leader is responsible for taking the
minutes in a meeting, submit assignments, update the planner, and driving the team
to complete the assignment on time.
3.2 Contract Agreement
• To ensure all the group members participate and contribute evenly to the
assignment, there will be a contract agreement to be negotiated and signed by all
the group members.
• A template of the contract agreement can be downloaded from Moodle.
• The contract agreement is an agreement between all the group members. Thus, all
the group members have to agree up front what tasks are to be delivered and when
the tasks are to be delivered.
• This contract agreement can be re-examined if one group member has withdrawn
from the course, or an unexpected event happened to one of the group members.
Please let the tutor know if the contract agreement has changed.
• The group contract agreement to be signed by all group members and to be
submitted by the team leader on Moodle.
3.3 Tips based on Previous Experience
• Make every effort to learn Oracle, including outside the lab!
• Keep backup copies of all your work!
• Hold group meetings at least once, better twice, per week!
• Define roles and responsibilities within the team; especially you will need a team
leader (group coordinator for handling submissions, scheduling meetings, etc.).
6 | P a g e
4. Private Group Channel (in Microsoft Teams)
(a) A private group channel will be created in Microsoft Teams by the teaching
team after the group formation at the end of Week 2 or beginning of Week
3.
(b) The name of your private group channel is same as your group ID.
(c) Only your group members and the teaching team will have access to your
private group channel. That is, no member from outside the group can
access to your private group channel.
(d) All conversations and files saved in the private group channel remain in the
private group channel.
(e) The purpose of the private group channel is to work as an environment for
you to meet, chat, leave messages, and upload/download files. Moreover,
the teaching team can communicate directly with the group in this channel.
(f) All the posts, files, meeting times and other group activities will be saved in
the channel.
(g) Another important factor of using the private group channel in Microsoft
Teams is it is transparent to all the group members and the teaching team.
When there is a dispute between the group members, the LiC will only
examine evidence such as posts, meeting activities and uploaded files in the
private group channel. The LiC will not examine other communication
channels such as WhatsApp, Facebook, and WeChat.
4.1 Planner
• Planner such as Microsoft Planner (if you have access) or a Weekly Chore Schedule
template or something similar which can be found in Microsoft Excel can be used
to improve planning of tasks.
• The whole team can access the planner so there will be no excuse such as, “I don’t
know what’s going on”.
• Notifications can be used as a reminder task to be completed.
• Planner should be maintained by the team leader or an appointee. All other group
members should also assist in managing the tasks in the Planner.
Note: One of the key PLOs is 4 Teamwork. We will examine the activities such as
chat and planner in the channel as the means of assessing teamwork.
7 | P a g e
5. Case Study
5.1 Phantom App Store (PAS) Case
Your team (i.e., your assignment group) has been hired as a group of database experts by
Phantom App Store (PAS). Your client Phantom App Store is based in Sydney. Your job is
to design and implement the PAS database.
Online mobile application stores, e.g., Apple App Store and Google Play Store, are very
popular. As a rising star in the application market, Phantom App Store has developed and
sold thousands of highly prestigious and popular applications to Apple and Android users. To
improve PAS’s market strategy and develop more user-friendly applications, PAS has a
platform that keeps the information and downloaded records of applications and most
importantly, recommends relevant applications to users. With an account, a user can
download applications, write reviews about applications, rate applications, and comment on
reviews.