Database Programming :: Projects :: Table Creation
Problem
For this assignment you will create and modify a table using SQL statements within phpMyAdmin. You can get to phpMyAdmin by going to db.yhscs.us. Your username is your first name followed by your graduation year and your password is "yhs" followed by your ID number.
Answer the questions below by running a SQL query in phpMyAdmin. You need to turn in a Google Doc with the query and results for each question.
Question One
In your database, create a table called student. The table should have a student number, which is the primary key, and a student name.
Question Two
Insert five records into your table and do a select statement to show all the rows.
Question Three
Add an attribute GPA, and provide values for each student. This attribute should not be allowed to be null. Do a select statement to show all the rows.
Question Four
Change the GPA of one of your students and do a select statement to show all the rows.
Question Five
Remove one of the rows from your table and do a select statement to show all the rows.
Question Six
Drop the student table.
