Introduction
这次代写的这个Web作业，题目很发散，按要求实现题目之一就好。
不过这是一个需要用Python和MySQL实现的Web作业，也算比较冷门的了。
Description
You will develop a web-based application with a database back-end for storage and retrieval of data. Choose your own adventure: select a subject matter related to your major or personal interests.
Examples
Some recent CS108 projects have included:
- Interactive dictionary for English/Junta language translation
- Inventory system for chemistry lab / reactive agents
- Social network for a gardening club
- High school basketball win/loss records & standings
- Fisheries information tracking endangered species
- Geographic information system for archeology dig
- Compact disc inventory and sales
- Calorie counting database/user interface
- Local artists list their works for sale (with pictures)
- Car rental and return
- Special of the day listing for restaurant
Detailed Requirements
You should begin by picking a concrete but simple interaction and modeling the data and functionality to implement it. For example, in a car rental application you might show a list of cars and allow a customer to complete a rental for one car. Start small; you can always add more interactions and details after you get the first one working.
Your application will model some kind of useful function, with a web-based interface (HTML) and data storage in a relational database (MySQL). A single interaction might be sufficient for this project, but a single web page certainly is not. You should have multiple web pages with logical transitions between the pages using buttons or links.
Projects must demonstrate reading from, inserting into, and updating database tables from your web interface. Points will be awarded for the general complexity of the project, with more complex projects scoring higher than very simple projects that mimic in-class assignments. After your work is functionally complete, you should enhance the look and feel of the application as the aesthetics (colors, images and fonts) will count for a small portion of your grade.
Topic Proposal
Your proposal should be brief (about 3 sentences) and describe the general subject matter (e.g., car rental), the specific interaction you will model (e.g. car selection and checkout) and the data you will require for this interaction (e.g., table of cars, table of customers, table of rentals which matches cars with customers).
Data Requirements
What kind of data will your application need to interact with? Describe the data in terms of records and fields. What attributes does each record need to have? How will you uniquely identify a record?
Make up some sample data (about 5 records) so that you can use to begin thinking about and testing the program’s interactions. You might want to use a spreadsheet program like Excel to create these records, which will also enable importing them into the database later. We will demonstrate how to create tables and records in MySQL at the scheduled lab session this week.
Planning Your Time
You have 4 weeks to complete this project. Here are some guidelines on what you should be working on at what time:
Week 1
- Select your topic and email to Aaron
- Define your project’s main interaction(s) (e.g., select car for rental, collect customer info, create rental) and which database tables you will need (e.g., cars, customers, rentals)
- Make up some sample data for each table you will need in Excel (a few records will suffice)
Week 2
- Build your database in MySQL, import your sample data
- Create a basic web application to view your data in a web page
- Begin building your interaction via forms, output pages, etc.
Week 3
- Continue building your interaction via forms, output pages, etc.
- Debugging, refine data as needed
- Validation of user inputs (i.e., don’t let your program crash due to missing or wrong inputs)
- Add additional interactions to increase the scope/complexity of the project
Week 4
- Debugging, refine data as needed
- Continue adding additional interactions to increase the scope/complexity of the project
- Work on the look and feel of the project (clean up HTML, CSS, tables, fonts, colors, images)
- Documenting your code with comments
- Prepare your short presentation of the project (plan for a 3-4 minute demo)
Project Demonstration Video
You will present your project by making a short (2-3 minute) video screen capture, with you narrating as you demonstrate the application. Think about this as a demonstration for a potential customer or employer. This will speed the grading, and provide you with a lasting artifact of your work, which you can demonstrate to potential employers. Your demonstration should not show any code or database records, but must demonstrate every major feature of your application.
I recommend that you write a brief outline of what you will show in which order. Then, use a screen capture tool (I suggest QuickTime player for Mac or Tiny Take for Windows or any similar program). Record your video, and post it to YouTube (a private/unlisted URL is fine).