2_populate_db - 1 Student Table: i insert into student

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Student Table: 1 insert into student values(999112222,'John','Smith','12th street','Houston',92312); i insert into student values(888112311,'Ahmad','Patel','Howe Ave','San Francisco',93312); F insert into student values(222145667,'Jennifer','Walace','Arden Way','San Jose',77187); J insert into student values(998289901,'Sriniwas','Basani','Uni Ave','Sacramento',95825); A 2 Course Table: 2 insert into course values('C11','Database management', 'Computer Science'); i insert into course values('C21','Comp_Architecture', 'Computer Science'); i insert into course values('E110','VLSI', 'Electrical Engg'); i insert into course values('E214','Analog Circuits', 'Electrical Engg'); i 3 Classroom Table: 3 insert into classroom values(8,'RVR',50); i insert into classroom values(210,'RVR',30); i insert into classroom values(112,'Lassan Hall',25); i insert into classroom values(5,'Mendoccino_Hall',45); i 4 Section Table: 4 insert into section values('C11',1); i insert into section values('C11',3); i insert into section values('C21',1);
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/26/2009 for the course CSC CSC 134 taught by Professor Jinyin during the Spring '09 term at CSU Sacramento.

Page1 / 4

2_populate_db - 1 Student Table: i insert into student

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online