{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cs4402 HK2 - Copy

cs4402 HK2 - Copy - mysql> select from St | Snum | Sname |...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
mysql> select * from St; +------+--------+-------------+------+--------+------------+ | Snum | Sname | City | Dept | Degree | Major_Pnum | +------+--------+-------------+------+--------+------------+ | s1 | Andy | Baton Rouge | ECE | M.S. | p1 | | s2 | Baty | Baton Rouge | CSC | M.S. | p3 | | s3 | Cathey | Lafayette | ECE | Ph.D. | p2 | | s4 | David | Lafayette | CSC | Ph.D. | p1 | | s5 | Emily | New Orleans | CSC | Ph.D. | p4 | | s6 | Forest | New Orleans | ECE | Ph.D. | p5 | | s7 | Grace | New Orleans | EE | Ph.D. | p2 | +------+--------+-------------+------+--------+------------+ 7 rows in set (0.00 sec) mysql> select * from Prof; +------+----------+-------------+------+ | Pnum | Pname | City | Dept | +------+----------+-------------+------+ | p1 | Ada | Baton Rouge | CSC | | p2 | Basic | New Orleans | ECE | | p3 | C# | New Orleans | EE | | p4 | Database | Baton Rouge | CSC | | p5 | Fortran | Baton Rouge | ECE | +------+----------+-------------+------+ 5 rows in set (0.00 sec)
Image of page 1

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

View Full Document Right Arrow Icon
mysql> select * from Com; +------+------+-------+ | Snum | Pnum | Hours |
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern