Due Date 10/29/22
This assignment includes several parts, for full credit make sure to complete all parts.
1. View the video previously provided on reverse and forward engineering using WorkBench.
A. Forward engineer your database from the previous assignment. In the options available, select to delete all information before creation. Take a screen shot which shows the file contents within WorkBench.
B.Save the file created, compress it, and submit it, along with the screen shot, to this drop box by the due date.
2. Save a copy of the file from #1 with a different name, but still with the sql file ending. Make the following changes to the code in the file.
A. Change the code to create all items (database and table) with your lastname and the previous name (such as smithclasses, smithdepartment, smithinstructor).
B. Change the code to create all column names with the tables to include CIST in the name (such as CISTName, CISTClassID).
C. Reverse engineer the file (running it inside of WorkBench) to create the new database, tables, and column names.
D. Take a screen shot of the result shown after the program has completed. Take a screen shot of the new ERD diagram created by Workbench showing the relationship of the new tables and columns.
E. Compress the file created, and the required screen shots, and submit by the due date.
3. Create a PHP program to display the new database, it's new tables, and new fields. Take screen shots of the results of the code executing.
A. Compress the PHP code and submit it, with the screen shots by the due date.