Write a relational algera expression that will do exactly

Assignment Help Computer Engineering

Reference no: EM132178533

Anwer the following business questions:

relation schema below to answer following questions

credit (credit-number, branch name, balance, max credit) borrower credit-number)

a" write an SQL statement to show all the customer names, credit balance are less than $500 away from the whose maximium credit line, that is max 500.

b. Write a relational algera expression that will do exactly same asthe soL above.

2. Consider the following relational schema

Wha Student (ID GPA) ID is a key Players (ID, sport) KID, sport is the primary key

Where ID is student identification number in both schemas, sport is the name of the sport (like baseball, football etc.)

Write a SQL query using aggregate functions to find out the average GPA for each sport. (3 points)

Reference no: EM132178533

Questions Cloud

Difference between status reports provided for teams : What are the challenges of different status report and what are the difference between status reports provided for teams, sponsors and steering commitee.

Write a program that will display the first name : You are on the Welcoming Committee at "Geeks -R- Us", you are tasked with building a basic information data sheet on the new potential employees.

What is a gantt chart : What is a Gantt Chart? Describe its key components.

Unexpected operating system updates are soon be released : A software project is 50% complete. What should a PM do if unexpected operating system updates are soon be released?

Write a relational algera expression that will do exactly : Write an SQL statement to show all the customer names, credit balance are less than $500 away from the whose maximium credit line, that is max 500.

Decision making process when sourcing a need : Are there any pros and cons when specifying by performance during the decision making process when sourcing a need.

Difference between a leader and a manager : What is the key difference between a leader and a manager?

How would you describe active directory domain services : How would you describe Active Directory Domain Services? How do you think an administrator benefits from implementing Active Directory Domain Services?

Media play many different roles in health service delivery : Social media play many different roles in health service delivery. Explain any three such health service delivery with examples?

User Account

All Pages