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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!