Question: 1. Start your text editor to create a file named students.sql 2. Write the CREATE DATABASE statement needed to create a database named students. If
1. Start your text editor to create a file named students.sql 2. Write the CREATE DATABASE statement needed to create a database named students. If the database already exists, drop it. 3. Write the use statement that selects the database. 4. Write Create Table statements to create the following table names grades in the students database. Column Name Data Type Length Null or Not Null Primary key? Auto Increment studentID INT FirstName Varchar 50 Not Null LastName Varchar 50 Not Null TotalPoints INT Yes No No No Yes No No No 10 Not Null 50 Not Null 5. Write INSERT statements that adds at least 10 sets of data in the table you created in the students database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
