COMP7640代做、SQL设计程序代写

日期：2024-03-21 08:03

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.