代写范文

留学资讯

写作技巧

论文代写专题

服务承诺

资金托管
原创保证
实力保障
24小时客服
使命必达

51Due提供Essay,Paper,Report,Assignment等学科作业的代写与辅导,同时涵盖Personal Statement,转学申请等留学文书代写。

51Due将让你达成学业目标
51Due将让你达成学业目标
51Due将让你达成学业目标
51Due将让你达成学业目标

私人订制你的未来职场 世界名企,高端行业岗位等 在新的起点上实现更高水平的发展

积累工作经验
多元化文化交流
专业实操技能
建立人际资源圈

Assignment代写:Database Systems and Design

2018-04-19 来源: 51due教员组 类别: 更多范文

下面为大家整理一篇优秀的assignment代写范文- Database Systems and Design,供大家参考学习,这篇论文讨论了phpmysqlCodeIgniter Framework框架等方面的内容。

Database Systems,Design,assignment代写,美国作业代写,作业代写

Introduction

Design and implement a sport session (e.g. Muay Thai, Jogging training, biking training, Yoga) online booking platform that let users search and reserve upcoming sport sessions in the cities.

Design the required data model that will support the required functional features.

Use MySQL database, PHP and CodeIgniter Framework for implementation.

System Requirements

Successful programming features are built on the foundation of a well-designed data model and database implementation. Therefore, your project will start with system analysis and database modeling and design, but not jumping right into creating table and PHP programming.

Data Model Requirements

A sport session must be created with session details such as session title, session theme photo (a nice photo that can attract user’s attention), short description (display at session listing and preview page), long description (display at session details page), date, time (e.g. 19:00 – 20:00), city, number of available ticket, price, venue etc. A session will be assigned to one and only one session format such as “Personal Training” or “Group”. A session belongs to one level: “Let me try”, “Beginner”, “Intermediate” & “Advanced”. A session can have zero or multiple trainers. A session must have at least one organizer (e.g. Warrior Muay Thai center). A session can be set related to zero or multiple other sessions so that it can serve to suggest “relevant sessions” to user when they are browsing the website. “Related session” is bidirectional. If A is related B, B is also related to A, meaning B will be shown as related session at the details pages of A, while A will be shown as related session at the details page of B.

You have to create your own set of testing data for all the table. The number of records for each table must be sufficient for demonstration of your program features, such as for searching and listing.

Functional Requirements

Homepage (index.php)

Homepage is one of the most visited page for a website. You want to make good use of this page to show featured session, recommended sessions or sessions that are on-going on the day. It must also provide convenient main navigations menu for visitors to browse various sessions, for example, quick link to browse session by types, session level, cities, featured trainers, featured organizers, price (e.g. free sessions or session within certain price range) etc.

Searching & Listing

When a user inputs a keyword to search sessions, the database will execute search of matching keyword to session title, long description, trainer’s names and organizer’s name. The search result will be presented in the format of a listing in which only the minimal/critical session information such as title, date, time, format, level, trainer, price and short description are displayed. Clicking at a session title or theme photo, user will be brought to session detailed page. Sessions listing must be presented in ascending date and time order. Expired sessions won’t be shown.

Other Listing Page

You also need to work out listing pages that you think enhance user’s browsing experience, e.g. all sessions from the same trainer, all session from the same organizer or all sessions from the same venue (an organizer can have many venues).

Showing session details

When users choose to view a session from the listing, all the session details including session title, long description, date, time, format, level, city, price, venue, trainer(s), organizer(s) will all be shown. If tickets are still available (number of reaming tickets > 0), user can choose “Book” button to reserve a session, otherwise it shows “Full”. When users click at a trainer’s name, profile of the trainer will be shown and other sessions delivered by the same trainer will be listed out and further linked to session details. Similar thing happens when users click at an organizer’s name, or venue. Besides, user can also see related sessions alongside (e.g. on a right column). If users click at the related sessions, they will be brought to the details page of the chosen related session.

Booking a session

Users will be asked to input first name, last name, email and mobile number to complete the booking. Assume user will be paying at arrival at the session and therefore no online payment is needed. Once booking is successful, deduct the remaining number of tickets and create booking record and present a booking number to user (In real life, user will usually receive and confirmation email).

Convenient links/navigations

Well-designed navigation enhances users’ browsing experience and help them to better reach their interested sessions. And most importantly, it will increase average user browsing time and average number of page views. You must at least provide these quick navigations on every page so that users can easily reach session listing by session format, session level, cities, organizers and so on.

Features for bonus marks

If you implement features besides all the above required requirements, you might receive BONUS marks. You should mention your extra features in your design report or at demonstration.

Group

Form a group of 3 – 5 people (more than 5 people a group is NOT allowed). Register your group’s members on Canvas. Grouping must be confirmed before 26th October.

Marking criteria

Criterion*

Excellent

Good

Adequate

Marginal

Failure

Database Design (35%)

Highly capable to apply database design skill, data modelling skill to model real life database application as design document

Significantly capable to apply database design skill, data modelling skill to model real life database application as design document

Moderately capable to apply database design skill, data modelling skill to model real life database application as design document

Basically capable to apply database design skill, data modelling skill to model real life database application as design document

Inadequate to apply database design skill, data modelling skill to model real life database application as design document

Database Implementation (35%)

Highly capable to convert the design document and implement working database system using database management system on the market

Significantly capable to convert the design document and implement working database system using database management system on the market

Moderately capable to convert the design document and implement working database system using database management system on the market

Basically capable to convert the design document and implement working database system using database management system on the market

Inadequate to convert the design document and implement working database system using database management system on the market

Web-based Database Application and Programming Skills (30%)

Highly capable to build fully working web based database application using web programming and frameworks taught in the course

Significantly capable to build fully working web based database application using web programming and frameworks taught in the course

Moderately capable to build fully working web based database application using web programming and frameworks taught in the course

Basically capable to build fully working web based database application using web programming and frameworks taught in the course

Inadequate to build fully working web based database application using web programming and frameworks taught in the course

What to submit?

You will have to submit

A detailed report includes the database design (ER Diagram and Data Dictionary) and webpage screen captures. Designs tool that we’ve introduced at lab 6 will help you on this.

Each member need to make a personal statement (a few paragraphs) describing the parts of jobs that he/she is responsible for. Explain the challenges and difficulties he/she has encountered and how he/she has solved them. Combine all the personal statements into ONE SINGLE word documents. Indicate each member’s full name and student ID in the statement.

PHP source codes and exported SQL must be zipped.

Provide a demonstration of your final implementation/prototype at the last week of the course. (Demonstration time-slot to be announced later).

51due留学教育原创版权郑重声明:原创assignment代写范文源自编辑创作,未经官方许可,网站谢绝转载。对于侵权行为,未经同意的情况下,51Due有权追究法律责任。主要业务有assignment代写、essay代写、paper代写、美国作业代写服务。

51due为留学生提供最好的assignment代写服务,亲们可以进入主页了解和获取更多assignment代写范文 提供作业代写服务,详情可以咨询我们的客服QQ:800020041。

上一篇:Assignment代写:Making Interactiv 下一篇:Assignment代写:Simulate Caches