Question: 5 1. a) Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year,

5 1. a) Assume the following table- Degree (degcode, name, subject)

5 1. a) Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode - degree code, name - name of the degree (Eg. BSc.), subject - subject of the course (Eg. DBMS), papcode - paper code (Eg. CSE-3105)] Solve the following queries using SQL; i. The name, subject and number of candidates for MSc degrees ii. The names of all the candidate who have got greater than 60 marks 9 in BSc. DBMS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

a) Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

I only need for the economics and financial performance part to be done as per the table in the assignment question attachment. 600-800 words. I have completed the rest of the assignment already. The...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

ACCT2060- Accounting for Organisations and Society Marking Rubric for Individual assignment Semester 1 2016 High distinction 10 Distinction 7.5 Credit 6.5 Pass 5 Below standards 2.5 Title page, and...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

1) Describe the sourcing trends that are important for IT. A) introduction on ITsourcing strategies B) Value of IT outsourcing (include an example of a company) C) Value of IT insourcing (include an...

A project is expected to sell one million units initially at a price per unit of $18.50 and a cost per unit of $8.50. Units sold will increase by 10% each year over the project's 3 year life....

How does the ownership position of the government affect the cost of capital? Please discuss how governance inefficiencies, specially those associated with the ownership structure, impact the cost of...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

LO2 Outline key provisions in the Civil Rights Acts of 1964 and 1991 and compare the two theories of unlawful employment discrimination.

1. Why do HR personnel need to think more strategically in companies? Why might such an approach enable HR to be taken more seriously by other managers?

LO1 Identify the major government agencies that enforce employment discrimination laws.