Question: 1. From command line, use MySQL to create a table with the following columns: StudentID: this is your primary key, the values must be unque.
1. From command line, use MySQL to create a table with the following columns: StudentID: this is your primary key, the values must be unque. FirstName: this is student's first name. LastName: this is student's last name. Unit/: this is one of the units the student is enrolled in. Unit2: this is one of the units the student is enrolled in. Unit3: this is one of the units the student is enrolled in. Unit4: this is one of the units the student is enrolled in. Once the table is created, enter the information about at least four students in the table. From the command line, query the database about what units a student is enrolled in using student number first, and then using the first name only, the last name only and both the first name and the last name. For submission, please include a number screen shots in a Microsoft Word file wshowing that the database has been created and the table is populated wth contents and the results of SQL queries. 2. Create a web application that displays an HTML form. The form allows the user to enter the student number, student's first name and the student's last name. When the user clicks the submit button, the application will retrieve the the enrollment information stored in the MySQL database created in Exercise 1 and present the information to the user. Note that the user is not required to enter all three pieces of data about the student. Your application should be able to find the information about all matching students. For example, if the user entered only the first name John, your application should display the enrollment data about all students whose first name is John
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
