Installation of Postgres DBMS and Gradebook Database and Interface I. Folder and Necessary Files The folder https://www.cs.csub.edu/~hwang/CS342/ contains many files, the following files are user for postgres DBMS and gradebook database and a front-end GUI application based gradebook database. 1. psql_commands.txt A text file that lists ou Postgres online commands 2. gradebookOnPostgres_ObjectCreations.zip - A file contain files for creating all gradebook DB objects such as table, index, views, stored functions and etc. 3. gradebookOnPostgres_GUI.zip II, Installation of Postgres DBMS 1. Download Postgres from internet based on the type of your PC. 2. Remember the password during instalation. III. Installation of my Gradebook Database. Download file (2) gradebookOnPostgres_ObjectCreations.zip The file contain files for creating all gradebook DB objects such as table, index, views, stored functions and etc. Follow the steps to crate gradebook DB and it objects 1. Unzip the file and a new folder "Create_postgres_gradebook_objects" may be created. 2. go into the folder you will see around 20 sql file. 3. start 'psql' command like this: $ psql --u postgres Possword for user postgres: enter the password made during postgre installation. 4. In postgres postgres-# \i crt_First // run the first sql fle to create user, tablespace and database 5. Logout postgres: postgres-# \q 6. Re-login postgres: pgres --u gradebook using 'c3m4p2s' as possword to login into gradebook postgres-# \i crt_Second // Create all needed gradebook DB schema objects. The grdebook user and gradebook database are created.All grade book database objects such as tables, views indexes, stored functions are created. IV. Install Grabookbook Graphic User Interface 1. Download NetBeans : A free IDE for Java, C++ front-end development too. 2. Download file (3) gradebookOnPostgres_GUI.zip and DON'T unzip it. 3. Start NetBeans and import the zip file into NetBeans IDE, 4. Run the imported gradebook program, use export/import tab to import data. 5. you can test other functionalities.