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
|
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Ω,
|