1 / 12

Project Description and Requirement

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 .

river
Download Presentation

Project Description and Requirement

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Project Description and Requirement

  2. 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).

  3. 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)

  4. 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.

  5. 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.

  6. 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>

  7. Project I: Mini-Oracle

  8. Project I: Mini-Oracle

  9. Project I: Mini-Oracle • Except, Union, Intersect

  10. Project I: Mini-Oracle • You have to implement keywords: Group by, Order by. • You are also encouraged to implement more complicated queries, e.g.

  11. 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.

  12. Project III: Mini-Amazon • You have to implement a mini-system working like Amazon. For details, please refer to http://www.amazon.com

More Related