It is a databases class project, which can be chosen from any topic (hopefully it is general one I can relate to).
I do not expect a 100 on this project (70-80 is all I hope). There is little time left on this assignment, but the project itself is VERY simple if the programmer is familiar with databases.
The price is negotiable.
During the course of the semester, you will be expected to complete a project involving the creation of a database-related system. You will be provided a MySQL database account and web space that will be PHP enabled on CS servers. The project will entail the design of a database, with all accompanying evidence of its good design, along with a front-end application (this does not have to be a website) that will interface with the database through record gathering, inserting, deleting, etc. The project can either be done individually, or with a partner, depending on your availability to work with others. The project must be complex enough so that it is not a trivial exercise, but cannot be so complex as to take longer than one month of effort.
This can be either an individual or partnered project. Partners will be expected to do more than individuals and will be graded accordingly. The objective is to design, implement, populate, test, and document a database of your choosing. The database can be for a situation and domain of your choosing. The project should not be trivial, nor should it be so ambitious that you cannot complete it in two month's time.
Your project will consist of:
• A database that you create in MySQL (all groups will set up their database on our MySQL server - no exceptions) that is populated with relevant data; and
• A well-designed application to interface with your database - this can be a stand-alone or web application - that is relevant to the "world" that you created your database for.
You will be submitting a document that will include the following:
• Requirements Document (including a complete description of the "world" to be modeled in your database with a discussion of who might use your database);
• Explanation of design decisions that you made in creating your application (i.e. why you choose the type of app you did, why that language, if your database should be secure, did you secure it and how, anything interesting or relevant, etc.);
• A description of your testing procedures for both the database and application;
• An E-R diagram;
• Database schema including integrity constraints;
• Proof that your database is in BCNF, 3NF, or other normal form;
• Sample data and sample queries from your application; and
• For partner projects, a candid evaluation by each member of the contributions
Note: You can request a certain browser for me to grade your project with, a Mozilla-varient, an IE-varient, Opera, or Chrome.
Your project grade will be 75% for the database and application and 25% for the documentation. To get full credit for the database and application, your database should be well designed (and proven so in the documentation) with enough relevant data to show that it does work properly. The application should be well-designed, free from technical errors, thoroughly tested, and should be good enough that, if this were a real-life project, you would be proud to turn it in to your boss. (i.e. doing little things to make your project stand out from the others is a good thing.) To get full credit for the documentation, it should be free from grammatical errors, contain all necessary information, and your train of thought in developing the application should be apparent.
• At least ten tables (5%)
- Rather self explanatory
• Good data (5%)
- Populated with enough different data to prove your queries work properly
- Data should be relevant (US phone numbers have 10 digits, etc.)
- Your data should be also releDescription
more information to be sent.