Reference no: EM13895136
Perform the following operations using SQL.
1. Create a Database ('fdb') using any one from Oracle, Sybase, DB-2, SQL Server or MySQL.
2. Create the following tables and fill them with the data.
Table Name: student
| id |
name |
birth |
gpa |
grad |
| 1 |
Anderson |
10/22/1987 |
3.9 |
2009 |
| 2 |
jones |
4/16/1990 |
2.4 |
2010 |
| 3 |
Hernandez |
8/12/1989 |
3.1 |
2011 |
| 4 |
Chen |
2/4/1990 |
3.2 |
2011 |
Table Name: courses
| id |
number |
name |
quarter |
| 1 |
CS142 |
CP II |
Winter 2015 |
| 2 |
ART101 |
Finger painting |
Fall 2014 |
| 3 |
ART101 |
Finger painting |
Winter 2015 |
| 4 |
PE204 |
Mud wreatling |
Winter 2015 |
Create a join table course_students describing which student took which courses.
| course_id |
student_id |
| 1 |
1 |
| 3 |
1 |
| 4 |
1 |
| 1 |
2 |
| 2 |
2 |
| 1 |
3 |
| 2 |
4 |
| 4 |
4 |
3. Write SQL query to select students having GPA greater than 3 and the result should be sorted according to name.
4. Update student's (Jones) GPA to 2.5.
5. Find all students who took a CS142 course.
6. Delete record of student named "Jones".
7. Add one column ("degree") to students table.
8. Delete table courses_ students.
|
Pan-hellenic empire by athens
: The Persian wars and the formation of Delian League transformed Athens into a powerful nation. The members of the league were about 200 in number contributed money, ships, and men into the common pool.
|
|
Elemental iodine (i2) is a solid at room temperature
: Elemental iodine (I2) is a solid at room temperature. What is the major attractive force that exists among different I2 molecules in the solid?
|
|
How might managers ensure their bidding procedure is fair
: With regard to the case, Coral Construction, Inc v. San Francisco, without using preferential bidding, how might managers ensure that their bidding procedure is fair to all businesses, including those that may be suffering the effects of past disc..
|
|
Calculate the effect on profits of processing product
: What should Elm do if it wants to maximize its profit for the period and calculate the effect on profits of processing Product A further beyond the split-off point - Calculate the effect on profits of processing Product D further beyond the split-off..
|
|
Write sql query to select students having gpa greater than 3
: Perform the following operations using SQL. Create a Database ('fdb') using any one from Oracle, Sybase, DB-2, SQL Server or MySQL. Write SQL query to select students having GPA greater than 3 and the result should be sorted according to name
|
|
Nacl dissolves in water, aqueous na+ and cl- ions result
: When NaCl dissolves in water, aqueous Na+ and Cl- ions result. The force of attraction that exists between Na+ and H2O is called ____ interaction.
|
|
What is the firm s average tax rate?
: what is the firm s average tax rate?
|
|
Can people increase their collaboration skills
: Eexplain why it is an important skill for business professionals. Describe what is working with regards to your group's process and what is not working. Can people increase their collaboration skills? If so, how? If not, why not?
|
|
Different kinds of separations in gc chromatography
: What are the different kinds of separations in GC chromatography?
|