COMP7640讲解 、SQL设计程序辅导
COMP7640 Database Systems and Administration Group Project Assignment
Objective
In this project, each group is tasked with the creation and execution of a multi-vendor ecommerce platform with a focus on personalized user experiences.
Basic Requirements
• Vendor Portfolios: Each vendor on the platform will maintain a unique profile that
includes a vendor ID, business name, customer feedback score, geographical
presence, and an inventory of products. Products are identified by a unique product
ID, have a name, listed price, and up to three tags that encapsulate the product's nature,
which are set by the vendor.
• Customer Profiles: A comprehensive database must be maintained for customers,
which includes a customer ID, contact number, shipping details, and order history.
• Transaction Records: Every purchase transaction is linked to a customer profile
and must detail the acquisition of at least one product from a vendor's catalog.
Transactions can span multiple vendors within the same order.
Required Functionalities
• Vendor Administration: The platform should enable functionality to 1) display a
listing of all vendors, 2) onboard new vendors onto the marketplace.
• Product Catalog Management: Users should have the ability to 1) browse all
products offered by a specific vendor, 2) introduce new products to a vendor's
catalog.
• Product Discovery: The system must facilitate a search feature that allows users
to discover products using tags. The search should return products where the tag
matches any part of the product's name or its associated tags.
• Product Purchase: You should support product purchase. Record in database
which customer purchases which product.
• Order Modification: Users must have the option to modify their orders, including
the removal of specific products or the cancellation of the entire order before it
enters the shipping process.
System Implementation
• Write a Java or Python program (command line interface or GUI) to implement the
online retail application and required functions. For version, Java is Java11 and
Python is Python3.5.
• Use JDBC and PyMySQL to access MySQL from the Java and Python program,
respectively. MySQL is open source and can be freely download here.
COMP7640 Database Systems and Administration Group Project Assignment
Project Schedule
The project should be carried out in groups of 3-5 members, which includes two phases.
• Phase 1: Group forming
Each group should have a group leader and the group leader should send the list of
group members to Mr. ZHAO Yunxiang (csyxzhao@comp.hkbu.edu.hk), by
11:59pm, 27th February 2024. Kindly note that each group will be graded using the
same standard regardless of the number of members. If you do not send the email
to Mr. Zhao before the due date, you will be grouped randomly.
Each member of the same group will receive the same marks, so you need
to form your group carefully and learn how to collaborate with your group
members. Note that it is not necessary to be good if there are many members in
a group.
• Phase 2: Database design & System implementation
Each group must design an ER diagram and convert the diagram to relational
tables.
Each group must implement the required functionalities.
Each group needs to submit a soft copy of the final report and a soft copy of your
code of implementation.
Each group needs to write a readme file to specify how to run your code.
Each group needs to record a video, which must be less than or equal to 6
minutes, for selling the database system to the instructor (customer), which
includes the design of ER diagram, the design of relational tables, and the
demonstration of functionalities.
Grading Criteria
• Correctness (40%): You will get full marks if your implementation is correct.
Partial credit will be given to a partially correct submission.
• Video demonstration (40%): You will be graded based on the following
criteria.
1. Clearness of the presentation (for explaining the ER diagram, relational
tables, and functionalities) (20%)
2. Language proficiency (10%)
3. Number of functionalities in the demonstration (10%)
Note that the total marks of this component for each group will be multiplied
by the factor (3 - x) ÷ 3, where x is the number of minutes that the video time
exceeds 6 minutes. If the video is more than or equal to 9 minutes, we will give
this group zero mark in this component.
• Documentation (20%): The report should be short, clear, concise, and
informative.
COMP7640 Database Systems and Administration Group Project Assignment
Submission (due by 11:59pm, 28th March 2024)
• Each group should submit a compressed file named groupX.zip.
• Upload your compressed file groupX.zip to BUMoodle.
• Only ONE submission is required for each group, for multiple submissions, only the
latest one will be collected.
Notes
• Plagiarism (complete/partial copying of other people’s work or sharing your
own work with other groups): Those groups that involve in this case will get
a zero mark.
• Late Penalty: The total marks of the late project will be multiplied by the
factor (100 - 50x)%, where x is the number of days it is late (0 mark if x ≥ 2).
Any exceptions to this rule must be made prior to when the project is due,
and the excuse needs to be a good one – just too busy won't cut it. Individual
exceptions are unfair to other groups. Hence, they won't be made unless the
circumstances are truly exceptional.
The groupX.zip file should include the following items:
1. groupX_project.zip (the Java or Python project source files, which include
comments of all your implemented functions.)
2. groupX_insert_sql.txt (the SQL command file for creating your tables (with
constraints) and inserting sample data)
3. groupX_report.pdf (the project report should include: 1. group members,
including student IDs and names; 2. ER diagram, table designs, normalization
(if any), and the corresponding explanation for helping the instructor/TAs
understand your design; 3. a readme description for running your code.)
4. groupX_video.mp4 (the video)
Note: Replace 'X' with your group no. in the above-mentioned files.