I need help with this prompt: Using a MySQL server you will create a database ta
ID: 3825374 • Letter: I
Question
I need help with this prompt:
Using a MySQL server you will create a database table that contains 30 student records.
Your record(s) will have the following fields:
Student Name (First and Last)
Student ID (8 digit)
Student Email Address
Courses Student is registered in (Max 4 consisting of Course name)
Student Transcript (Max 8 consisting Course name and Final Grade)
Once the database is created you are to design a form (how the form looks is up to you) that will allow the user to access your database and print out the table containing the student records you created. I will need to have access to your original DB file to verify that information printed is indeed what is stored within your DB table.
Explanation / Answer
CREATE TABLE Student Records (first name VARCHAR(30) NOT NULL,last name VARCHAR (30) NOT NULL,Student ID INT (8) UNSIGNED,AUTO_INCREMENT PRIMARY KEY,email VARCHAR (50),department VARCHAR (40),course name CHAR (30),Final Grade INT(20),);
INSERT INTO Student Records VALUES('pranay','Krishna','20175059','pranaykrishn.com','mechanical','engineering','8th')
mysql> SHOW TABLES;
I have just taken one example of values