Question: In this practice exercise you will play with SQLite. First go through SQLite Tutorial (http://www.tutorialspoint.com/sqlite/ You can use any other SQLite tutorial) and see/learn basic

 In this practice exercise you will play with SQLite. First go
through SQLite Tutorial (http://www.tutorialspoint.com/sqlite/ You can use any other SQLite tutorial) and

In this practice exercise you will play with SQLite. First go through SQLite Tutorial (http://www.tutorialspoint.com/sqlite/ You can use any other SQLite tutorial) and see/learn basic SQLIte commands and basic SQL statements. Please do the following Read SQLite Tutorial, SQLIte Home - SQLIte-Insert Query Write (on paper) SQL statements for the following questions: Given the following database: Students(sid, fname, Iname, age, gpa) Courses(cid, cname, cdescription Enrolled(sid, cid, semester, grade) Faculty(fid, fac name, dept, ph number) Taugh Primary keys are underlined for all of the above tables/relations. Create Students table. Include primary key statement, each of the attributes should have a meaningful data type. Create Courses table. Include primary key statement, each of the attributes should have a meaningful data type. Create Enrolled table. Include primary key statement, each of the attributes should have a meaningful data type. Include a foreign key statement (sid in Enrolled is a foreign key that refers sid in Students table, cid in Enrolled table is a foreign key that refers cid in Courses table.) Write an SQL statement to delete table Enrolled. Write SQL statement to change name for Courses table to a new name: WSU Courses. Write SQL statement to delete age column from Students table. Write SQL statement to add student age into table Students. Write SQL statements to insert the following records/data into Students table: . . . 1123 John 1142 Kate 1109 Peter 1202 Michael Smith Smith White 21 3.4 20 3.5 Peterson 19 3.7 21 3.5 Write SQL statement to delete Kate White's record from Students table

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!