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 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
Get step-by-step solutions from verified subject matter experts
