数据库代写|INFS7901 Database Principles Project Guidelines

Project Description

In this project, each student is required to select an application that would benefit from a database and build a database application from start to finish. The web user interface is not mandatory for this project, but can play an important role if you would like to obtain bonus points. The project requires two deliverables, where marking schemes are provided in both parts and bonus points are explained in Part 2.

Philosophy

Building a full database application from scratch allows you to control the process. Instead of having the pieces decided for you, you must make your own decisions at the beginning and can experience how they will affect the execution of your project. We will prepare practical sessions for the key skills needed, but this project will further facilitate more in-depth practices and take you on a tour of a database architect’s responsibilities when designing an application.

Goals

For time management, please note that populating the database is only for ensuring necessary query operations and is not the main focus of the project.

Schedule

There are two important deadlines that you must meet in order to ensure a successful project:

Part 1: Project Proposal

The goal of the project is to allow you to have the freedom to design your own application. With the project proposal, we can give you feedback on the project and tell you if you are on the right track – and suggest improvements if not. As an overarching picture, we expect that each project should eventually have:

Marking Scheme (In 100-point Scale)

The goal of this milestone is for you to tell us exactly what to expect from your final application.

Please submit one PDF file that includes the following information.

Part 2: Completed Project (Code and Report)

This is the main part of the project, building on what you have accomplished in the other project checkpoints in order to complete, demo and evaluate the project.

Marking Scheme (In 100-point Scale)

There are two components to be handed in, namely the project final report and the source code.

The requirements for both components are introduced below. More information on bonus points from optional GUI implementation can be found at the end of this instruction.

Project Report

The final report should be one PDF file describing the information below.

Code

The project’s code base and related scripts are submitted through Blackboard as one Zip file. Please ensure:

All primary keys and foreign keys must be declared appropriately.

(Optional) Bonus Points – GUI and Usability Features

So far, if all the requirements are met, one should be able to obtain full (100) marks. However, if you would like to go deeper with database applications, and want to secure some bonus points for Part 2 of your project, you can go ahead with the optional GUI development. The maximum bonus for this part is 10 points to be added to your Part 2’s final scores. Please note the final scores are strictly capped to 100. For example, if you scored 89/100 for your report+code and 10 in the bonus section, your final score for Part 2 will be 99. If you scored 95/100 for your report+code and 10 in the bonus section, your final score for Part 2 will be 100. The marks will be evaluated based on: