Write sql query to select students having gpa greater than 3

Assignment Help Database Management System
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.

Reference no: EM13895136

Questions Cloud

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?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd