日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

代做COMP 636、Java程序設(shè)計代寫

時間:2024-06-09  來源:  作者: 我要糾錯



COMP 636: Web App Assessment 
Milestone submission due: 5pm Friday 10 May 2024 via Learn 
Final submission due: 5pm Wednesday 12 June 2024 via Learn 
Worth: 50% of COMP636 grade 
Submit via Akoraka | Learn, with files set up and available on GitHub and pythonanywhere. 
Introduction 
Selwyn Campground have decided that they want to upgrade their internal system from the textbased
 system to a web-based system. Your task is to develop a small Web Application to help them 
manage customers, sites, and bookings. You will also write a report. 
The system will only be used by office staff and does not require any form of login or authentication. 
Bookings are recorded in the system by making an entry for each night a site is booked. 
Download the Web Application Project Files from the Assessment block on the Learn page. These will 
get you started, including for the Milestone. You will add more routes and templates as you develop 
your app. 
The requirements presented are not exhaustive, you are expected to apply critical thought to them 
as a key aspect of the software development process. Ask clarifying questions in the in-person or 
online support sessions. 
Important 
This is an individual assessment. You may not collaborate or confer with others. You 
may help others by verbally explaining concepts and making suggestions in general 
terms, but without directly showing or sharing your own code. You must develop the 
logical structure and the detail of your code on your own. Code that is copied or shares a 
similar logic to others will receive zero marks for both parties. The University policy on 
Academic Integrity can be found here. 
 
Requirements 
 
 1) Create a private github repository called scg, this repository should be pulled locally and to 
pythonAnywhere. Your web application should be in a top level directory called scg 
(automatically created when you pull your repository), and your MySQL database should be 
called scg. You are required to commit and push changes from your local computer to your 
GitHub repository at least twice a week between milestone and final submissions. 
2) Host your web app on pythonAnywhere. 
3) Complete the camperlist.html template to display a list of campers who are camping on a 
particular night. The template should use bootstrap for formatting. 
4) Complete the /booking/add route to insert a booking into the database. 
5) Create templates and routes to allow customers to be searched and for the results to be 
displayed. 
6) Create templates and routes to allow customers to be added to the system, and ensure 
appropriate validation is in place.  

 
 7) Create or modify templates and routes to allow customer information to be edited. 
8) Create templates and routes to display a report that shows the total number of nights that a 
customer has booked (past, current and future booking combined). The report should show 
the name of the customer, the total number of nights booked and the average occupancy for 
this customer. 
9) Create a report as described in the Report section to be hosted in your github repository. 
 
Report 
Your report must be created using GitHub Markdown format and saved in the README.md file of 
your GitHub repository. It does not need to be a formal report – a tidy document using the following 
headings will be sufficient. Write a brief project report that includes: 
• Design decisions: 
o Discuss the design decisions you made when designing and developing your app: what 
design options you weighed up, why you designed your app the way that you did, your 
decisions about the routes, templates, navigation, broad layout, etc., that you made. 
o For example, when the edit button is clicked on a page, does that open a different template 
for editing or does it use the same template with IF statements to enable the editing? Did 
you use GET or POST to request and send data, and how and why? These are two examples, 
you do not have to include them in your own discussion. You will have considered many 
design possibilities; write in plain language about your own personal decisions. 
o Note your decisions as you work, so you do not forget them! 
• Database questions: Refer to the supplied scg_local.sql file to answer the following questions: 
1. What SQL statement creates the customer table and defines its fields/columns? 
(Copy and paste the relevant lines of SQL.) 
2. Which line of SQL code sets up the relationship between the customer and booking 
tables? 
3. Which lines of SQL code insert details into the sites table? 
4. Suppose that as part of an audit trail, the time and date a booking was added to the 
database needed to be recorded. What fields/columns would you need to add to 
which tables? Provide the table name, new column name and the data type. (Do not 
implement this change in your app.) 
5. Suppose the ability for customers to make their own bookings was added. Describe 
two different changes that would be needed to the data model to implement this. 
(Do not implement these changes in your app.) 
• Image sources: It is not necessary to use any external images in your web app, but if you do, 
ensure you reference the image source in your report. 
  

 
Data Model 
 
 
Model Notes: 
Child table.field * (refers to) Parent table.field 
bookings.customer 
 
customers.customer_id 
bookings.site 
 
sites.site_id 
 * the ‘Foreign Key’ 
 
Project Constraints 
You must: 
• Use only the COMP636 technologies (Python & Flask, Bootstrap CSS, MySQL). Do not use 
SQLAlchemy or ReactJS (or other similar technologies) in your solution. 
Do not use any scripts, including JavaScript, except for the <script> at the bottom of base.html. Do 
not write your own CSS (use Bootstrap). 
• Use the provided SQL files to create a database within your local MySQL and in 
pythonanywhere. Each script also creates initial data in the database. 
o You can re-run the appropriate SQL script at any time to reset your data back to the original 
version and remove any changes you made to it. 
• Use the provided files to develop a Flask Webapp that: 
o Must be in a top level folder called ‘scg’ (locally and on pythonanywhere). 
o Meets the functional requirements. 
o Is appropriately commented. 
o Connects to your database. 
o Uses %s to insert values into SQL statements. 
o Provides appropriate routes for the different functions. 
o Provides templates and incorporates HTML forms to take input data. 
o Uses Bootstrap CSS to provide styling and formatting. 
• Include your report as outlined above.  

 
o This report must be created using GitHub Markdown and saved in the README.md file of 
your GitHub repository. 
• Create a private GitHub repository called scg that contains: 
o All Python, HTML, images and any other required files for the web app. 
o A requirements.txt file showing the required pip packages. 
o Your project report as the README.md document. 
o Your repository must have a .gitignore file and therefore not have a copy of your virtual 
environment. 
o Add lincolnmac (computing@lincoln.ac.nz) as a collaborator to your GitHub repository. 
o Your repository must show a minimum of two commits per week after the milestone 
submission. 
• Host your system (including database) using pythonanywhere. 
o Add lincolnmac as your “teacher” via Account > Education. 
o The webapp must be in a folder called ‘scg’ 
 
Project Hints 
Create your GitHub repository first, and create all your required code and files in your local folder. 
You are required to commit and push changes from your local computer to your GitHub repository at 
least twice a week. 
pythonanywhere is case sensitive so test your app early – we will mark the pythonanywhere version 
of your app. 
Spend some time sketching the structure of your application before you start developing. Think 
about which features could share the same (or nearly the same) templates. Remember that you can 
nest templates (templates within templates). 
Take note of your design decisions, compromises, workarounds, etc. for your report as you develop 
your web app. Otherwise afterwards you may struggle to remember all of the issues you worked 
through, when it comes time to discuss some of those design decisions. Do not include masses of 
insignificant decisions in your report. 
The requirements in this project brief are not exhaustive, you are expected to apply critical thought 
and think about the user experience of the web application. 
  

 
Milestone Submission (5 marks, due 10 May) 
This milestone is to ensure that your app is correctly configured, and any set-up issues are resolved 
early. The milestone does not require any changes to the code and templates provided. By this date 
you only need to sync and share the provided files on GitHub, provide us teacher access to your 
PythonAnywhere and host the provided code on PythonAnywhere so that the web app and provided 
routes run correctly. 
Submit the following via the link on the Learn COMP636 page: 
• Your pythonanywhere URL (e.g., joebloggs1987654.PythonAnywhere.com/ ) 
• Your GitHub username and repository name (e.g., joe-bloggs-1987654/scg) 
 
For this submission you must have: 
• Your GitHub repository set up correctly. 
• The provided files loaded in GitHub and in PythonAnywhere. 
• Your database set up on PythonAnywhere. 
• Your app hosted on PythonAnywhere. 
• The /booking route working (as provided in the files). 
• Granted access to your PythonAnywhere account (set lincolnmac as teacher). 
• Granted access to your GitHub repository (invite lincolnmac or computing@lincoln.ac.nz as 
collaborator). 
IMPORTANT: Do not pull further changes to your PythonAnywhere files until after you have 
received your Milestone marks. You may continue to work in the local copy on your computer in the 
meantime and you should also commit and push to your GitHub repository. 
 
At this submission we will check your GitHub, PythonAnywhere and database setup. 
Set-up Requirement Marks Available 
GitHub Repository set up and shared 1 marks 
PythonAnywhere web app hosting correctly configured, including 
home URL and database setup, and teacher access granted 
3 marks 
/booking route and page (as provided) running on 
PythonAnywhere 
1 marks 
TOTAL 5 marks 
 
 
  

 
Final Submission (95 marks, due 12 June) 
Submit your URLs again via the link on the Learn COMP636 page: 
• Your pythonanywhere URL (e.g., joebloggs1987654.pythonanywhere.com/ ) 
• Your GitHub username and repository name (eg, joe-bloggs-1987654/scg ) 
 
This confirms where your work is, and tells us that your final submission is ready for marking. 
Final Submission Marking 
Report and General Project Aspects (25 marks): 
Project Element Marks Available 
Project Report – Part 1: 
• Discuss your design decisions (minimum 
one per task). Also detail assumptions that 
you made, if any. 
• Report created using GitHub Markdown 
and saved in the README.md file of your 
GitHub repository. 
 
8 marks 
• 7 marks for appropriate personal 
discussion, in your own words. 
• 1 mark for .md being in the right place and 
a reasonable length. (Just a heading, or a 
couple of sentences, is not a reasonable 
length.) 
Project Report – Part 2: 
• Report Database Questions sufficiently 
answered. 
 
10 marks 
 
Spelling, presentation, etc. 2 marks 
Spelling, punctuation, grammar, and 
presentation, and appropriate 
referencing of external images (if any). 
 
Consistent ‘Look and Feel’ (interface, Bootstrap 
styling & templates, ease of use, etc). No extra 
css or scripts. Comp636 technologies only. 
 
5 marks 
TOTAL 25 marks 
 
Functional Project Aspects (70 marks): 
Within each of the functional areas (see table below with indicative marks) we are looking for: 
• Functionality working as specified in the requirements and demonstrating critical thought 
about the implementation and user experience. 
• Well commented and formatted HTML, SQL, and Python code throughout. 
• A user interface that looks and functions to a professional standard, including Bootstrap 
colour and styling choices, sensible navigation and appropriate sorting of lists. 
• ID numbers for table rows are mainly for internal system use only and should only be made 
visible to system users when mentioned in the requirements. 
• Data Validation on forms. Wise choice of form elements. 
• Well-structured SQL queries. 
• Appropriate naming, both of variables and labels. 
  

 
An indication of marks (may be adjusted when marking) : 
Item Functionality 
Approx. 
Marks 
Access Home page exists via ‘/’ route, with appropriate layout and no 
broken links. 

Navigation Appropriate use of extending templates. Sensible, well laid-out 
navigation throughout. 

List campers Shows appropriate list of campers for that night including 
occupancy. 
Well formatted list with appropriate styling using bootstrap. 

Add booking Route implementation added to add a database row per night of 
booking. 
Appropriate confirmation page or redirection in place. 
Database is successfully updated. 
10 
Customer - search Customers can be searched, including partial text matches. 
Appropriate display of results. 

Customer - add Appropriate interface, forms, and validation. Customer is added 
correctly. 
15 
Customer - edit Appropriate interface to choose customer. 
Sensible updates can be made, with suitable validation. 
12 
Summary report Can select customer, and with appropriate interface. 
Suitable display and correct results. Considered order and layout. 
12 
TOTAL 70 
 
You may modify data in your database for testing purposes and may add new data, but you must not 
modify the schema. 
Markers will modify or add alternative data to your database as part of the marking process. 

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











 

標(biāo)簽:

掃一掃在手機(jī)打開當(dāng)前頁
  • 上一篇:代寫COMPX222、代做Java/SQL編程語言
  • 下一篇:ICS3U編程代寫、代做Java/Python程序設(shè)計
  • 無相關(guān)信息
    昆明生活資訊

    昆明圖文信息
    蝴蝶泉(4A)-大理旅游
    蝴蝶泉(4A)-大理旅游
    油炸竹蟲
    油炸竹蟲
    酸筍煮魚(雞)
    酸筍煮魚(雞)
    竹筒飯
    竹筒飯
    香茅草烤魚
    香茅草烤魚
    檸檬烤魚
    檸檬烤魚
    昆明西山國家級風(fēng)景名勝區(qū)
    昆明西山國家級風(fēng)景名勝區(qū)
    昆明旅游索道攻略
    昆明旅游索道攻略
  • NBA直播 短信驗證碼平臺 幣安官網(wǎng)下載 歐冠直播 WPS下載

    關(guān)于我們 | 打賞支持 | 廣告服務(wù) | 聯(lián)系我們 | 網(wǎng)站地圖 | 免責(zé)聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 kmw.cc Inc. All Rights Reserved. 昆明網(wǎng) 版權(quán)所有
    ICP備06013414號-3 公安備 42010502001045

    日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

              国产一区二区高清| 麻豆91精品| 国产亚洲精品一区二区| 久久蜜桃av一区精品变态类天堂| 亚洲美女淫视频| 亚洲第一中文字幕| 国产麻豆精品视频| 欧美精品一区二区高清在线观看| 亚洲欧美日韩中文视频| 亚洲成色www久久网站| 国产亚洲视频在线观看| 国产精品丝袜91| 欧美日韩在线观看一区二区| 欧美激情bt| 免费观看日韩av| 久久在线观看视频| 久久久噜噜噜久噜久久| 久久精品国产2020观看福利| 亚洲午夜激情网页| 一区二区久久久久| 9l国产精品久久久久麻豆| 欧美精品免费在线| 欧美激情综合| 欧美日韩精品二区第二页| 欧美精品二区| 欧美日韩综合久久| 欧美性理论片在线观看片免费| 欧美男人的天堂| 欧美日韩视频一区二区三区| 欧美日韩国产色站一区二区三区| 欧美精品一区三区在线观看| 欧美理论在线播放| 国产精品福利在线观看网址| 国产精品日日摸夜夜添夜夜av| 国产精品国产亚洲精品看不卡15| 国产精品久久久久久av下载红粉| 国产精品色午夜在线观看| 国产精品久久久久9999吃药| 国产婷婷成人久久av免费高清 | 一区二区精品国产| 亚洲一级黄色片| 亚欧美中日韩视频| 久久久久久综合| 欧美日韩成人在线观看| 国产精品自拍三区| 精品91在线| 日韩性生活视频| 亚洲一区二区三区777| 久久激情综合网| 欧美肥婆在线| 国产精品一区久久久| 在线观看国产欧美| 一区二区三区视频免费在线观看| 亚洲免费人成在线视频观看| 欧美伊人久久久久久久久影院| 麻豆精品91| 国产精品久久久久一区二区三区共 | 欧美日韩三级视频| 国产一区在线免费观看| 99国产精品99久久久久久| 欧美一级专区| 欧美日韩精品不卡| 国语精品一区| 亚洲天堂网在线观看| 久久久精品999| 国产精品美腿一区在线看| 亚洲黄色三级| 欧美一区影院| 国产精品成人午夜| 亚洲人久久久| 久久久久久亚洲精品中文字幕| 欧美日韩第一页| 在线日韩av片| 久久久7777| 国产伦精品一区二区三区| 亚洲精品综合在线| 久久久久国产精品午夜一区| 国产精品黄视频| 99热免费精品| 欧美精品三区| 日韩亚洲不卡在线| 免费欧美在线视频| 韩国av一区二区三区| 亚洲欧美日韩另类| 国产精品s色| 亚洲丝袜av一区| 欧美日韩国产成人高清视频| 亚洲片在线观看| 欧美在线视频不卡| 国产九区一区在线| 欧美亚洲在线| 国产日韩亚洲欧美| 欧美一区二区三区视频在线观看 | 国产精品欧美在线| 一区二区三区高清视频在线观看| 欧美激情一区二区| 亚洲免费成人| 欧美日韩播放| 亚洲综合精品| 国产欧美日韩三级| 久久久久久尹人网香蕉| 黄色日韩在线| 免费人成网站在线观看欧美高清| 亚洲国产婷婷香蕉久久久久久| 毛片一区二区| 一本久久a久久免费精品不卡| 欧美日本亚洲视频| 亚洲自拍偷拍麻豆| 国产三级精品在线不卡| 久久婷婷蜜乳一本欲蜜臀| 精品二区视频| 欧美日韩伦理在线| 亚洲女性裸体视频| 国产亚洲一级| 欧美另类综合| 香蕉免费一区二区三区在线观看| 国产三级欧美三级日产三级99| 久久亚洲综合色一区二区三区| 亚洲第一福利在线观看| 欧美日韩三级视频| 欧美一区二区免费视频| 在线免费日韩片| 国产精品久久久久久久久久尿 | 国产亚洲女人久久久久毛片| 蜜臀av一级做a爰片久久| 亚洲狼人精品一区二区三区| 国产精品一区在线观看你懂的 | 国产精品综合不卡av | 国外成人在线视频| 欧美国产日产韩国视频| 亚洲欧美在线免费| 亚洲国产毛片完整版| 国产精品免费一区二区三区在线观看| 久久久久久久久一区二区| 一区二区三区国产在线观看| 韩国三级电影久久久久久| 欧美日韩免费高清| 麻豆成人在线播放| 欧美亚洲专区| 亚洲视频精选在线| 亚洲国产成人在线播放| 国产精品主播| 欧美三日本三级少妇三2023| 久久久噜噜噜久久人人看| 国产精品99久久久久久人| 亚洲第一在线| 国产日韩欧美在线观看| 欧美三级午夜理伦三级中视频| 久久精品国产精品亚洲| 亚洲欧美日韩一区在线| 日韩系列欧美系列| 亚洲人成高清| ●精品国产综合乱码久久久久| 国产毛片精品国产一区二区三区| 欧美日本亚洲| 欧美日韩国产综合视频在线| 久久久人成影片一区二区三区观看 | 亚洲欧美成人| 一区二区三区精品视频| 日韩视频免费观看| 国产日韩欧美一区| 国产农村妇女毛片精品久久莱园子 | 国产免费成人在线视频| 欧美性jizz18性欧美| 欧美久久久久久久久久| 欧美高清在线一区二区| 欧美成年人网| 蜜月aⅴ免费一区二区三区 | 久久亚洲私人国产精品va| 久久精品国产免费观看| 久久激情网站| 久久婷婷久久一区二区三区| 久久精品一区二区三区四区| 久久久久一区二区| 蜜桃av一区| 欧美精品性视频| 国产精品扒开腿爽爽爽视频| 国产精品人人爽人人做我的可爱 | 国产精品夫妻自拍| 国产精品久久久久久久久久直播| 国产精品久久久久久久久久ktv | 久久久国产成人精品| 久热国产精品| 麻豆精品视频在线观看视频| 欧美极品色图| 国产免费亚洲高清| 国内精品久久久久久久影视蜜臀| 精品不卡一区| 一本到12不卡视频在线dvd| 午夜欧美大片免费观看| 久久久久久91香蕉国产| 欧美黑人在线播放| 国产精品老女人精品视频| 国产欧美亚洲视频| 在线播放一区| 亚洲一区二区三区四区五区黄 | 久久久另类综合| 欧美精品色网| 国产亚洲欧美一区| 亚洲毛片在线|