Question: takes student ID ID course id deplome or cred ester wer grade section Courseld seld semester course course Id advisor depr name credits department dent

takes student ID ID course id deplome or cred ester wer grade section Courseld seld semester course course Id advisor depr name credits department dent name building budget building FOON Number time wid time_slot Time slord day art time end_time prerea cursed classroom building room number capacity instructor ID name de um salary teaches ID Curved ser Id Senester war Figure 2.9 Schema diagram for the university database. Using the university data base write the following queries using SQL 1. Find the name of all students in Physics' department 2. Find the name of all students with total credit greater than 20 3. Find the name of all students who takes courses in Fall semester, year 2018 4. Find the name of all instructor who taught in Fall semester , year 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Pacman finds himself inside the grid world MDP depicted in Figure S17.5. Each rectangle represents a possible state. At each state, Pacman can take actions up, down, left or right. If an action moves...

Consider the Schema diagram for a university database a. Find the department and course id of all classes that were taught or are being taught by an instructor from a different department. Use at...

Consider the Schema diagram for a university database a. Find the IDs of all students who have taken all of the CMPSC courses. Use the division operation. b. Do the same operation as in problem a,...

4. Find the names and IDs of all students who have taken a course taught by Dr. Who. Use at least one natural join in your answer. 5. Find the department and course id of all classes that were taught...

student ID dept nante akes ID course id sec id sennester ear tot cred rade sectio17 course department advisor itle dept name credits semester ET building OO no fine siot id building budget time slot...

. Identify set of entity or objects Identify name of possible attributes of objects Identify value of keys for objects Identify relationship among the objects takes ID student ID MATE dept_name...

1) Write a PL/SQL program with cursors to print a report that includes the name of each major (indicated by dept_name), printed once, then a line for each student in that major that includes the...

student takes ID course id sec id ID namme dept name tot cred year grade section course department dept name building budget advisor sec id title t name credits s id i_id time slot uilding roomno...

1) Write a PL/SQL program to find and print the average instructor salary by department. Output should include the department name and the average salary for that department. Output should be...

Grades are mapped to a grade point as follows: A:10, B:8, C:6, D:4 and F:0. Create a table to store these mappings and write a query to find the CPI of each student, using this table. Make sure...

Name the micro structural products of 4340 alloy steel specimens that are first completely transformed to austenite, then cooled to room temperature at the following rates: (a) 10C/s, (b) 1C/s, (c)...

Use this fact (and no row operations) to find scalars c1, c2, c3, such that 153 153 456 730

(Appendix 4B) Sequential Method Refer to the information for Sanjay Company. Now assume that Sanjay uses the sequential method to allocate support department costs. S1 is allocated first, then S2....

According to Bancography, a consulting firm in Birmingham, Ala., a customer who has just one product with a bank will stick with that bank for about 1 8 months, but add even one product - a savings...

What are Measures in OLAP Cubes?

How do OLAP Databases provide for Drilling Down into data?

How are OLAP Cubes different from Production Relational Databases?