Reference no: EM131037668
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
|
Develop a risk management plan for a reliable power
: 49006 RISK MANAGEMENT IN ENGINEERING, Assessment Task 1 - Autumn 2016. Introduction of enforced traffic regulations: lowering the speed limit tolerance and increasing fines. Develop a risk management plan considering the impact on road safety. Dece..
|
|
Benefit of monopolistic competition
: One of the benefit of monopolistic competition over perfect competition is
|
|
Consider the cd-cg amplifier
: 8.100 Consider the CD-CG amplifier of Fig. 8.48(c) for the case gm= 5 mA/V, Rsig= 500 kΩ , and RL = 10 kΩ Neglecting ro, find Gv .
|
|
The signing of the affordable care act
: Please view the video Sickness Across America. After viewing the video, please state your reaction to the video. This video was made PRIOR to a lot of changes in our healthcare system. What aspects of this video have changed since the signing of the ..
|
|
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..
|