Understand the concept of sql

Assignment Help PL-SQL Programming
Reference no: EM131037664

The Assignment:

Consider the tables given below:

TEACHER (teacherId,T_name,T_address,T_phoneNo,Hometown)

STUDENT (studentId,teacherId,S_name,S_address,S_phoneNo,DOB)    

COURSE (couseCode,CourseName,CreditHours)

STUDENT_COURSE (teacherId,studentId,GPA)

Write SQL queries for the following:

List the teachers showing only the Name and Hometown.

List  all the student Id and teacher Id   where GPA is 3 or more than 3.

List all the students of the teacher whose name is 'John Eric'.

List student Id, name, and address of all the students whose date of birth is 1983.

List all the Course Code  where the credit hours are 4

Objective

  • This assignment has been designed so that you understand the concept of SQL

Reference no: EM131037664

Questions Cloud

Understand the concept of sql : List  all the student Id and teacher Id where GPA is 3 or more than 3. List all the students of the teacher whose name is 'John Eric'. List student Id, name, and address of all the students whose date of birth is 1983. List all the Course Code  where..
Signal vsig having a source resistance rsig : 8.99 For the amplifier in Fig. 8.48(a), let I = 0.5 mA and β = 100, and neglect ro. Assume that a load resistance of 10 kΩ is connected to the output terminal. If the amplifier is fed with a signal vsig having a source resistance Rsig =10 kΩ, find..
How do you understand the plain-sense meaning : Briefly state your methodological procedure (1/2 page). How is it that you are going to bring the original, contextual meaning to light (e.g., archaeology, language, iconography)? You may freely take material from your first major paper and incorp..
Approaches to organisational strategy and human resource : Analyze both the conventional and alternative approaches to organisational strategy and human resource. What role do people issue play in how strategy is made , developed and executed in an organization.
Understand the concept of sql : List  all the student Id and teacher Id where GPA is 3 or more than 3. List all the students of the teacher whose name is 'John Eric'. List student Id, name, and address of all the students whose date of birth is 1983. List all the Course Code  where..
Would you have handled bp strategy execution differently : Debate whether or not a for-profit company competing with rivals can effectively balance ethical business practices while competing for market share in today's marketplace.
Npv and irr calculations : Find the IRR and NPV for given question - NPV and IRR calculations
After plotting demand for four periods : After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand.
The bjts in the darlington follower : 8.98 The BJTs in the Darlington follower of Fig. P8.98 have β = 100. If the follower is fed with a source having a 100-kΩ resistance and is loaded with 1 kΩ,

Reviews

Write a Review

 

PL-SQL Programming Questions & Answers

  Display the product line id and the average standard price

SQL queries on a single table. Show how many different items were ordered on order number 1004. List the employee names and ids of employees whose first name starts with an "R".

  Write a sql expression to display the status

Write a SQL statement to display the Major of students with no duplications. Do not display student names.

  Develop a pl/sql user-defined function

Develop a PL/SQL user-defined function ZIP_CODE_SALES_WINNER that returns the zip code with the largest total car purchases. Since there can be a tie with two or more zip codes, ensure that the lowest numeric zip code is returned.

  Compare and contrast the three phases of database design

Write an SQL select statement to list all double or family rooms with a price less than $255 per night in ascending order of price.

  What selection criteria are used

Which fields are displayed in the query results

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Create qrycustomersm that selects all customers

Write the SQL below that would display all Customers whose first name begins with the letter J. Your query should display the FirstName, LastName, Phone, and MembershipStatus fields from the tblMember table.

  Relational model and integrity constraints

Answer all questions with reference to the STUDENT, COURSE, and GRADE tables presented below for which the primary keys, foreign keys, and referential integrity constraints are specified.

  What types of users would typically use a dml statement

You must begin by understanding the different types of SQL statements. Adhere to the following deliverables for this Discussion Board.

  Select statement to return one row

Write a SELECT statement that returns one row for each general ledger account number which contains three columns.

  Write command to list all the employees in year

Write the command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

  Advanced sql and pl sql

Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

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