GitHub repository: kneesham/DBMS_Project1
Primary language: PHP
Created: 2020-02-03T04:52:10Z
Description: First, I will use the following university database (link to the university database) to help you with this project assignment. In this programming project, we will practice several basic features both in SQL and web programming. As a first project this can be challenging for beginners, but for those of you that find it easy, you can also consider the bonus question which is worth an additional 10Pts (total 110 Pts out of 100). You have four weeks to do this first project. Thus, plan to work on it early so you don't use any of your flex days on this project.  We will practice the following features in this project: SQL Features Basic Select statements Insert new data into the tables. Update old data in the tables based on the row numbers. Delete records from the tables based on the row numbers. Find the primary key of the current table through information_schema. Web Programming Features Use Bootstrap (Glyphicons) on the buttons. Use CSS to adjust the styles of GUI components. Pass data through hidden parameters. Invoke PHP programs from JavaScript functions. Change GUI components using JavaScript functions. Send data to the server through HTML forms or parameters. Use a uniformed way to access data in different tables Use a single file for all tables. For instance index.php is used to dispaly all tables.