Understand the concept of sql

Assignment Help Business Management
Reference no: EM131036611

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: EM131036611

Questions Cloud

Understandability and comparability when evaluating a cost : What should be included in a management report to further understandability and comparability when evaluating a cost center?
What about monetary and fiscal policy can we use them : Do you agree? Justify your answer. what about monetary and fiscal policy can we use them in that situation ?
Corporate leadership in expresing theit leadership skills : According to female executives. which of the following factors least hinder women from advancing to corporate leadership in expresing theit leadership skills?
How much will be in the account at the end of the 10-year : how much will be in the account at the end of the 10-year period?
Understand the concept of sql : This assignment has been designed so that you understand the concept of SQL
Some of the challenges that face accountants : South British Company is a solar energy company located in the southern part of the United Kingdom. The company specializes in generating electricity, which is then sold to local towns and villages. Due to the global decrease in oil prices, the de..
Based upon your professional experience or recent event : Based upon your professional experience or a recent event, provide an example of how an organization successfully or unsuccessfully incorporated risk managBased upon your professional experience or a recent eventement into their strategic plan. What ..
Process control-what is the probability that observed data : What is the probability that an observed data point would fall outside the UCL? Assume that the process changes and there is a mean shift but the variance stays the same. If the old control chart is being used and the mean shift is equal to plus one ..
Why is this issue of market definition important : Dupont argued that the definition of the market should be changed to include all wrapping paper. Why is this issue of market definition important? (DuPont's position prevailed).

Reviews

Write a Review

 

Business Management Questions & Answers

  Service request create a benefits election system

The different project for this course is in the form of a Service Request from Huffman Trucking. It is essential for the student to access Service Request Create a Benefits Election System.

  Give a specific example from your own experience

Give a specific example from your own experience to highlight one of the stages. If you have no team experience, utilize the case study you completed in connection with same.

  How regulations as well as laws affecting the restaurant

How regulations as well as laws affecting the restaurant industry, In what ways do government regulations inspiration the industry? What are key regulatory matters that affect the industry's future

  What is the goal of the times in creating thepaywall

What is the goal of the Times in creating thepaywall?

  Artists during war

During war times many had zero money or they were fighting in the war itself. European areas that were under Nazi control would not allow such art to be displayed or even purchased

  Explain katrina is walking through a store drops her wallet

Explain Katrina is walking through a store when she accidentally drops her wallet. Katrina does not know that she has dropped it, categorize who has the best right to the wallet.

  Corporation in reference to current global affairs

As a US heavy and outsized air cargo carrier, what are the three most important challenges facing this corporation in reference to current global affairs.

  Conflict-resolution methodologiescompare and contrast

conflict-resolution methodologiescompare and contrast various conflict resolution techniques. apply these techniques to

  Discuss the challenge in managing complexity

Discuss the challenge in managing complexity and variability in support processes associated with service systems design.

  Leadership styles cultural values and rewards

Leadership Styles, Cultural Values and Rewards

  What are the advantages of working in a team

(1)what are the advantages of working in a team at school (rather than working on your own)? (2) From your perspective, what are the disadvantages of being a part of a team for a college course

  Sexual harrassment policy of ferrum

Creating an intimidating, hostile, or offensive working/learning environment or substantially interfering with job or academic performance.

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