120 likes | 208 Views
Project Description and Requirement. Requirements. We have 3 projects for choice with each project worth for 100 points. You are also encouraged to work on your own project, which must have comparable work load as the provided projects .
E N D
Requirements • We have 3 projects for choice with each project worth for 100 points. • You are also encouraged to work on your own project, which must have comparable work load as the provided projects. • 5-10 bonus credits will be given to the students who work on their own projects. • If you choose to work on your own project, you have to send your project proposal (detailed project description, 1-2 pages) to my TA Mr. Guoliang Liu (gliu6@student.gsu.edu) before September 25 for approval. Only your project proposal gets approved, you are permitted to use your own project as the course project. • If you do not want to work on your own project, you have to work on at least one of the 3 provided projects. You can also work on more than 1 project if you want (I will assign you up to 50 bonus credits for the extra projects you have done).
Requirements • Every student has to send the TA Mr. Guoliang Liu (gliu6@student.gsu.edu) the project you plan to work on by September 27, 2012 in the format: YourName, Project Name. • The project will be graded according to 3 aspects: presentation and demo on class (30 points), program/source code (30 points), and the project report (40 points). • Requirements for presentation and demo: (i) you have to present your project and show the functions and features of your project in class; (ii) your presentation will be graded by the instructor (20% of the weight), the TA Mr. Guoliang Liu(20%), and your peers (60% of the weight)
Requirements • Requirements for program/source code: (i) you will have to send in a fully working program by November 13, 2012 to the TA Mr. Guoliang Liu; (ii) it is mandatory that you include a README file when you send your program, which states how to run your program, test cases, and results for test cases; (iii) when you send the program, put all the files, data, and other materials in a folder named in the format Your Name • Requirements for the project report: you will have to write a project report (about 7-10 pages, single space, 12pt font) that includes: • Design issues, what are the problems and how you solve them • Data structures you use, the decision behind selecting them • Algorithms you employ, again with a justification of your decision • Particular emphasis should be placed on the running time of your algorithm • The report will also include your test cases and results • Any other remarks or highlights about your design and implementation (you may get some bonus credits) • The due date for the report is November 29, 2012.
Requirements • You can get more bonus credits if you implement more functions and features in your project. Each extra function or feature worth for about 5-10 bonus credits.
Project I: Mini-Oracle • In this project, you are asked to develop a Mini-Oracle system, which is actually a DBMS system working in the manner of the real Oracle system. • It is not necessary to fulfill all the functions provided by Oracle in your Mini-Oracle system. However, your system should have the following functions • Create a database, e.g. CREATE DATABASE Company. • Create tables within a database, e.g. CREATE TABLE Company.Employee( FnameVarchar(15), NOT NULL, ……) • Basic Insert, Delete, and Update statements • Basic Retrieval Queries in SQL, e.g. Select <attribute list> From <table list> Where <condition>
Project I: Mini-Oracle • Except, Union, Intersect
Project I: Mini-Oracle • You have to implement keywords: Group by, Order by. • You are also encouraged to implement more complicated queries, e.g.
Project II: Mini-GOSOLAR of GSU • You have to implement a database-based Mini-GOSOLAR system, which implies you have to use database to store all the data and develop an application program to manipulate these data. • You have to implement 4 menus of the GOSOLAR system: Registration Menu, Student Records Menu, Student Accounts Menu, and Personal Information Menu. • Furthermore, you are encouraged to fulfill all the functions in the GOSOLAR system.
Project III: Mini-Amazon • You have to implement a mini-system working like Amazon. For details, please refer to http://www.amazon.com