+====================================+ | DATABASE SYSTEMS PROJECT | | Phase V: | | Graphics User Interface | | Design and Implementation | | Updated November 28, 2016 | +====================================+ Phase V of database system class is the last phase, and it will be use to replace the final exam. Students will hand in the complete project document including the final and previous phases. Phase V: Design and implement a graphics user interface in the form of local window/form or web-based application for part of your database project. You can used any programming languages such as C#, Java, php and etc. Two examples local GUI applicaiotn in C# and Java UGI program are available at www.cs.csubak.edu/~wang/CS342/ folder. An example Java GUI program will be given later. I. General Description In this phase, the student will 1.1. Each memnber of the team will design and implement one GUI application for different user groups in differnt languages. 1.2. The GUI must contain data entry and report generation. The GUI must be complex enough and approved by instructor. 1.3. The GUI appliocation must use some server-side programs such as views, stored subprograms, and triggers if possible. 1.4. The reports must use views wih one or more level of group-by function. 1.5. Each applicaiton must involve multiple tables. 1.6 You are encouraged to use existing ingrated development tool such as MS Studio.net, NetBean, BootStrip and etc. II. In your report, The following must be included: Phase V Graphic User Interface for XYZ Users 5.1 Functionalities and User group of the GUI Application. 5.1.1 Itemized decriptions of GUI applicaion, and reports generated. 5.1.2 Screen shots of the application Deciption functionalities of each command buttons, contents of data, reports and etc. 5.1.3 Tables, Views Stored Subprograms, used Triggers used. 5.2. Programming Sections 5.2.1 Sever-Side Programming For each view and subprogram, list the code or screen shot. and describe their purposes. 5.2.2 Middle-Tire Programming Code for database connection. code sections which use view mehtod of calling stored subprobgfram. Any other code sections you like to mention 5.2.3 Client-side programming Any Javascrip code that will be executed at browser side. 5.3. Survey Questions In this course, in what degree do you think you have the achieved each of following 4 outcomes? Your answer is between 1 (lowest) and 10 (highest). Each member of the team should have his/her own answers. ------------------------------------------------------+------------------ | Members' Outcome | Answers | btw 1 & 10 ------------------------------------------------------+------------------ | | member 1's answer (3b) An ability to analyze a problem, and identify and| define the computing requirements and specifications |------------------ appropriate to its solution. | member 2's answer | ------------------------------------------------------+------------------ | (3e) An ability to design, implement and evaluate a | computer-based system, process, component, or | program to meet desired needs. An ability to |------------------ understand the analysis, design, and implementation | of a computerized solution to a real-life problem. | | ------------------------------------------------------+------------------ | (3f) An ability to communicate effectively with a | range of audiences. An ability to write a technical | document such as a software specification white |------------------ paper or a user manual. | | ------------------------------------------------------+------------------ | (3j) An ability to apply mathematical foundations, | algorithmic principles, and computer science theory | in the modeling and design of computer-based systems |------------------ in a way that demonstrates comprehension of the | tradeoffs involved in design choices. | | ------------------------------------------------------+------------------- III . Zip your document (in pdf), programs for creating database, relations, stored procedures generating reports and images of reports, and key screenshots. Don't forget put your group number, your (own) name in each of every file names.