Yorkville High School Computer Science Department
Yorkville High School Computer Science Department on Facebook  Yorkville High School Computer Science Department Twitter Feed  Yorkville High School Computer Science Department on Instagram

Yorkville High School Computer Science

ASSIGNMENTS: Compiler Part 1 - November 28, 2017 :: Compiler Part 2 - December 6, 2017 :: Challenges 7 - December 8, 2017 >>

Database Programming :: Projects :: Table Creation

Rubric
Lesson
Due: Sep 15

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.

Yorkville High School Computer Science Department on Facebook Yorkville High School Computer Science Department Twitter Feed Yorkville High School Computer Science Department on Instagram