该表只是一个格式,具体数据库表格自行设计，请将所有的表设计写入一个excel表Here is just a format for reference, please complete database table design on your own, and put them all in one excel file.4.功能需求（Functionality Requirements）：提供登录表单，允许用户以不同身份（管理员或学员）登录，登录后转到不同页面执行不同操作。There must be a login form that allows a user to log in either as a student or as an administrator, and redirect the user to either a student page or an administrator page correspondingly, thus handling different operations.1.管理员登录后可进行如下操作(Administrator Functionality)：i. 修改管理员密码Change administrator passwordii. 管理注册用户，可对注册用户进行增删改查和禁用，一旦禁用用户，用户需要向管理员发送通知或邮件请求账户解冻。Manage registered users, including adding a new user, modify information of a user, delete a user, view details of a user, and disable a user. Once a user is disabled, the user needs to apply for account unfreezing through sending a message or an email to the administrator side.iii. 管理景点、酒店、美食店信息，对这些信息进行增删改查。Manage details about scenic spots, hotels, etc, and implement CRUD operations on the same.iv. 审核组团游申请，管理员批准后，其他旅游爱好者才能参与该组团游活动。Verify and approve applications for group travelling, users interested can not apply for one group traveling unless the activity gets verified and approved.v. 删除游记功能，例如对用户举报的游记进行删除，并发送通知或邮件给发布游记的用户。Delete travelling notes, for example, delete a note reported by other users, and send a notice or an email to the user who published that note.vi. 查询功能（Search Requirement）除非查询的数据为单条记录，否则请使用分页功能将查询结果分页Please implement data paging for the result retrieved unless only a single record is retrieved除非有特殊需求，查询数据尽量不要跳转页面，所以请使用Ajax发送异步请求在本页面进行局部刷新Please send ajax requests for querying data and display result on the same page unless you have a need for displaying data on a different page1)按照关键字、城市检索美食店、景点、酒店信息，显示列表后可对每项信息进行修改、删除和查看详情，并可根据一些条件，如好评，对检索的结果列表进行排序。Search for information about restaurants, scenic spots, hotels based on a keyword or a city, administrators are able to implement CRUD operations on the list retrieved, and sort the same based on some criteria such as rating of the hotels, restaurants or scenic sports in the result list.2)按照关键字、作者、发布日期、日期范围检索游记，并对检索出的游记进行查看、禁止浏览、删除等。并可根据作者、发布日期等进行排序。Search for travelling notes based on such criteria as a keyword, an author, a publishing date, or a date range, and view details, disable or delete a note in the list. Result list can also be sorted based on author name or publishing date.3)按照用户ID、名称、等级（根据注册天数更新等级，等级自行定义）检索用户，向用户发送通知给指定用户以及删除指定用户等。Search for a user or users based on user ID, or user name or rating of a user (Each team decides how to rate a user on your own, rating shall be updated based on the number of days passed after registration), administrators can also send notices to specified users or delete selected users. 4)查询被举报的游记的信息，并对其进行处理，如发送通知或邮件给发布用户或直接删除游记。Search for notes reported by users and deal with the same, such as sending a notice or an email to the user who published that note or deleting a note directly.5)查看被举报的用户的信息，并对其进行处理，比如暂时禁用其账号，并发送通知或邮件给用户。View users reported by other users, and deal with the same, such as disabling a user or send a notice or a email to that user.6）查看组团游申请，并对列表中显示的每个申请进行处理，如批准或不批准，并发送通知或邮件给发起人用户。View applications for group travelling, and implement operations on each application, such as approving or disapproving, and send a notice or email to the user who launched the activity.vii. 退出登录Log out2. 用户可进行如下操作(Student Functionality)：i. 根据关键字检索酒店、美食店、景点、游记的信息以及对酒店、美食店、景点、游记等点赞或取消点赞、查看评论、发布评论和删除评论，检索的列表可根据一些条件进行排序查看，如游记按照发布日期和点赞数进行排序，酒店可根据价格等排序，美食店可根据好评、类型等排序，景点可根据等级和点赞数量等进行排序等，所有的检索都可根据点赞数进行排序。并可预订酒店和接受预订的美食店Search for hotels, restaurants, scenic spots by entering a keyword, implement such operations as liking or disliking an item, view details, publish comments or delete your own comments for an item, the result list can be sorted based on some criteria, such as sorting notes by publish date, sorting hotels by price, sorting restaurants by rating or type, sorting scenic sports by rating, etc, all kinds of search can be sorted by the number of likes. And then a user can reserve hotels or restaurants.ii. 注册成为正式用户，并进行登录Register as a normal user, and log in thereafteriii. 查看和修改个人信息（等级信息不可更改，等级根据成为用户天数自动更新）及密码View personal profile and modify the same, including updating personal information and password, the rating information of a user is not allowed to be modified and should be updated automatically according to the number of days passed after registration.iv. 发布、修改和删除游记Publish, modify and delete a travelling note.v. 举报包含不当言论的游记或行为不当的用户Report a user who behaves improperly or a travelling note that contains illegal contents to the administrators.vi. 申请组团游，列出团游标题、景点、时间长短、费用、人数限制、出行方式、入住酒店、截止日期等。发布后可查看和更新申请状态，并可在其他用户申请后查看申请用户列表，用户在团泳结束后可对本次体验进行点评和删除评论. 只有管理员审核通过该申请后，其他用户才可申请加入团游。Launch a group travelling by providing such details as title, scenic spot, duration, budget, number limited for participants, transporting tool, hotel to check in, deadline, etc. The user who publishes an application can view or update the status of the application and check the list of applicants, and people involved in the activity is allowed to comment on the trip and delete their comments if they want, please note that a trip can not be applied for by other users unless the application gets approved by the administrator side.vii. 退出登录Log out3. 首页要求（Home page requirements）i.首页提供导航菜单，方便用户到不同页面查看和检索不同类型的信息，如酒店、景点、美食、游记、组团游。The homepage shall provide a navigation menu that guides the users to different pages and makes it convenient for users to search for different information, such as hotels, scenic spots, food restaurants, notes and group travelling activities.ii.首页提供用户登录和注册的链接Provide users links for logging and registration on the home page.iii.首页提供用户检索功能，方便用户根据关键字检索景点、美食店和酒店检索Provide users with the functionality of searching for information by entering a keyword on the home page.iv.首页显示几个最热门旅游城市和各城市至少6个最热门景点的链接Show at least 6 hot scenic spots of several hot travelling cities on the home page.v.首页显示热门游记的链接Show links of the top several travelling notes on the home page.vi.景点页面显示当前定位的城市，以及热门城市和对应城市的景点推荐，首先显示当前城市的热门景点推荐和景点搜索功能Show the city of the current location on the scenic spot page, and list recommended or hot scenic spots from the several hottest cities, the first city should be the current city where a user stays.vii.美食页面显示当前定位的城市，并显示当前城市的热门小吃或店家推荐，以及其他热门城市的美食推荐Show the city of the current location on the food page, list the most popular food or restaurants of the current city, and also food recommendations of other cities.viii.游记页面显示热门游记，并提供基于关键字的游记检索以及基于指定条件对游记列表排序，如按照评价数量、好评、发布时间等Show some of the most popular or best rated travelling notes on the note page, and provide users with the functionality of sorting notes based on some criteria, such as the number of comments or likes, date of publish, etc.5.备注：可自行添加其他扩展功能Remark: Students can add on to the project by implementing more extra functionality.代写CS Finance|建模|代码|系统|报告|考试编程类：C++,JAVA ,数据库,WEB,Linux,Nodejs,JSP,Html,Prolog,Python,Haskell,hadoop算法,系统 机器学习金融类：统计，计量，风险投资，金融工程，R语言，Python语言，Matlab，建立模型，数据分析，数据处理服务类：Lab/Assignment/Project/Course/Qzui/Midterm/Final/Exam/Test帮助代写代考辅导天才写手,代写CS,代写finance,代写statistics,考试助攻E-mail:[email protected]微信：BadGeniuscs 工作时间：无休息工作日-早上8点到凌晨3点如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。