Question: For this assignment, you need to make a database-backed website. You will have to create an application with which a user can manage the course

For this assignment, you need to make a database-backed website. You will have to create an application with which a user can manage the course catalog of a department. Each Course will have the following attributes (or the columns in your courses table). ID - The ID of the course (Eg: 1,2,3.....) Number - The course number (Eg: CS290) Name - The name of the course (Eg: Web development) Credits - Credit hours of that course (Eg: 4)

Requirements

Visiting the page will show a table displaying all the existing courses in the Database. The header should list all the columns. At the top of the page, there should be a button that let you navigate to a form and enter in all the data needed to make a new entry in the table with a button to submit it. Hitting that button should add the row to the table if it was successfully added to the database and navigate back to the course-listing page. If it was not successfully added (probably because the Name or ID was left blank and it is required) it should not add it to the table. Each row should have two buttons. One to delete the row and one to edit the row. Hitting the delete button should immediately remove the row from the table and from the database. Hitting the edit button should make it possible to edit the data. For this function, your app should allow the user to edit that specific course, save it and then take you back to the main page( The course-list page). The form to edit the course should be pre-populated with the existing data from that row (in other words if I go to the edit page, and then hit save, nothing should change because all the old values were in the edit form).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!