亚洲天堂免费在线,丰满人妻在公车被猛烈进入电影,国产又黄又潮娇喘视频在线观看 ,久久黄色大片,国产女人伦码一区二区三区不卡,校花娇荡吟喘上课,亚洲区中文字幕在线不卡电影,亚洲黄色网页

合肥生活安徽新聞合肥交通合肥房產生活服務合肥教育合肥招聘合肥旅游文化藝術合肥美食合肥地圖合肥社保合肥醫院企業服務合肥法律

COMP3013代做、代寫Python設計編程

時間:2024-05-14  來源:合肥網hfw.cc  作者:hfw.cc 我要糾錯



COMP3013 Database Management System
Course Project Requirements 2024 Spring

Introduction
In this project, you are supposed to model, design and implement a real-world web application that is related to database management. For example, a simple music management system, a university course arrangement system, a library book management system, an e-business inventory management system, a train ticket booking system, etc. (you are encouraged to propose your own application, innovative ideas will be given bonus points).  You should do the implementation using Python Django framework and MySQL DBMS. Your web application should provide users reasonable operations based on your application and problem.
This is a group-based project. Each group has 3-4 students and you should choose your group via the grouping link on iSpace. You can come up with your proposals.

Workflow
The project workflow goes through several stages described below.
1.Problem definition. Each group will need to select a topic and formulate the problem, e.g., music management, e-business inventory management or ticket booking, etc.
2.Data collection. Each group will need to collect the data using the web scraping techniques or downloading existing datasets. You can also generate synthetic datasets if necessary. 
3.Wrangle, prepare, cleanse the data. The collected data may contain missing and noisy entries or in consistency schemas. Therefore, you need to perform data preprocessing and data cleaning.
4.Database design. Design the database using the ER Model by creating an ER diagram and later on converting it into relations in MySQL DBMS.
5.Web development. Design and implement the website that provides a user interface to manage the database, including but not limited to query the database, insert/update/delete some records in database relations. 

Requirements
Front End Requirements
Your website needs at least 5 pages, each page needs to include navigation bars, logo, footers, etc. 
Your website should allow user registration and login. At least two user types should be offered. For example, suppose you are building a bookstore website, your user types could be administrator, registered user and anonymous visitor.
Your website needs to include at least four features. The more features you have, the higher score you will earn. Feature is a workflow that can allow the user to perform a complete task. Take the example of bookstore, the features could be:
oA user searches book.
oAn admin adds new books.
oAn admin views purchasing history and statistical/analysis results.
o…

Back End Requirements
Your ER diagram should have at least 6 entities and a few relationships.
On average, each table must have no less than 5,000 records. There are at least two tables consisting of more than 50,000 records. (Note: Not all the records have to be real but they should be realistic. You may generate records using some program.)
Your system takes less than 1 second to insert a record to any table.
Your system takes less than 2 seconds to delete or search a record.
You may have to create an index to accelerate delete or search.
The logical design of the database must follow the normal forms.

Presentation Requirements
10 minutes (pre) + 2 minutes (QA) for each group.
Make some good slides.

Report Requirements
Project description. Briefly introduce the purpose of this project. You should define which real-life problem you are solving, address the difficulty of the problem, give the abstraction of the problem, and major goal of the project.
Introduce the dataset, data collection and data preprocessing approaches in your project.
To design the database, you may need to make some assumptions for modeling because real-life problems sometimes do not provide enough information. But, all your assumptions have to be realistic.
Your report must include your final ER diagram and a brief description of each entity and relationship set.
You need to give all functional dependencies and schemas.
If your schemas are in the 3rd normal forms. If not, you need to decompose them and show the steps in detail.
You need to describe the primary keys.
List all front-end and back-end functions that you have implemented.
List the SQL codes and explanations of main functions in your project.
Workload and contribution of each team member.

Bonus (Maximum 10%)
Use foreign keys. For example, the table student has students’ information and the table registration has courses registered by each student. If one tuple is removed from student, the corresponding tuple(s) will also be removed from registration.
Use triggers to implement constraints other than not null, primary key, unique, or referential. For example, the table student has an attribute credit showing the total credits earned by each student. Then, if a student finishes a course of 3 credits, his/her credit will be increased by 3 automatically.
Other outstanding or innovative features in addition to the implementation of correct and complete fundamental functions.
Presentation & Report Tips
The presentation should follow the top-down procedure. Please start your presentation from the problem definition and assume that audiences know nothing about your project.
Describe your database design on a high level, ER diagram for example.
Highlight the critical points, constraints and triggers for example.
Prepare some good slides.
Do NOT make your presentation as function demonstration.
Time is limited. You cannot show all details in a short presentation. Attract people’s attention by some shining gold.

Grading
Report 20%
Presentation 10%
Website Implementation 20%
Database Design and Implementation 50%
Bonus 10% (maximum)
Submission
We established the following milestones to ensure that no one begins working on the project at the eleventh hour.
1.April 8 – April 12nd: Choose your group via the grouping link on iSpace. You need to find your teammates. Each group consists of 3 students. For the students who cannot find groups, contact TA for help.
2.April 12nd - April 26th: Project proposal submission, which contains:
A problem description. You should define the problem that you are solving, why you are interested in this problem, the information that you want to model in your system, and the features that your system will include.
The first draft of the ER diagram.
Assumptions and expected outcomes of your project.
3.April 26th - May 18st: Web Application Development.
4.May 20th - May 25th: Project presentation and final submission. The submission includes:
oThe report of the whole project.
oAll code for your application, including the web scraping code, data preprocessing and analysis code, database code (.sql) and web development code.
oAny auxiliary files needed by your program to create the database and application.

One group only submits one copy to iSpace by the team leader. For proposal submission, rename your files as “COMP3013_ProposalGroup###.docx”, where ### is your group number. And also rename your final submission package as “COMP3013_Group###.zip”.

請加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp
















 

掃一掃在手機打開當前頁
  • 上一篇:代做CNSCC.361、代寫MATLAB編程設計
  • 下一篇:代做EIE111、代寫C++語言編程
  • 無相關信息
    合肥生活資訊

    合肥圖文信息
    仿真分析咨詢外包服務-結構 / 熱 / CFD流體 / 電磁 / 光學CAE代做
    仿真分析咨詢外包服務-結構 / 熱 / CFD流體
    流體仿真外包多少錢_專業CFD分析代做_友商科技CAE仿真
    流體仿真外包多少錢_專業CFD分析代做_友商科
    CAE仿真分析代做公司 CFD流體仿真服務 管路流場仿真外包
    CAE仿真分析代做公司 CFD流體仿真服務 管路
    流體CFD仿真分析_代做咨詢服務_Fluent 仿真技術服務
    流體CFD仿真分析_代做咨詢服務_Fluent 仿真
    結構仿真分析服務_CAE代做咨詢外包_剛強度疲勞振動
    結構仿真分析服務_CAE代做咨詢外包_剛強度疲
    流體cfd仿真分析服務 7類仿真分析代做服務40個行業
    流體cfd仿真分析服務 7類仿真分析代做服務4
    超全面的拼多多電商運營技巧,多多開團助手,多多出評軟件徽y1698861
    超全面的拼多多電商運營技巧,多多開團助手
    CAE有限元仿真分析團隊,2026仿真代做咨詢服務平臺
    CAE有限元仿真分析團隊,2026仿真代做咨詢服
  • 豆包網頁版入口 Trae 目錄網 排行網

    關于我們 | 打賞支持 | 廣告服務 | 聯系我們 | 網站地圖 | 免責聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 hfw.cc Inc. All Rights Reserved. 合肥網 版權所有
    ICP備06013414號-3 公安備 42010502001045