Question: Exercise III: Structured Query Language (25 marks) Department(DeptId, Dname). Course(CrsId, Cname, DeptId). Student(StdId, Sname, level, DeptId). Enroll(StdId, CrsId, year). Evaluation(StdId, CrsId, grade, semester, DeptId). Lecturer(LId,

Exercise III: Structured Query Language (25 marks)

Department(DeptId, Dname).

Course(CrsId, Cname, DeptId).

Student(StdId, Sname, level, DeptId).

Enroll(StdId, CrsId, year).

Evaluation(StdId, CrsId, grade, semester, DeptId).

Lecturer(LId, Lname, rank, DeptId).

Teaching(LId, CrsId, semester, DeptId, year).

Express the following English queries in SQL

1. Find names of students who got A in the database in the Fall semester. (5 marks)

2. Find name of courses that 300 and 400 level computer science are taking together. (5 marks) 3. Find courses that Mr Hamid is teaching. (5 marks) 4. List names and Ids of students taught by Dr. Samura.(5 marks) 5. Find IDs and Name of students in 400 levels that have enrolled in a course that belongs to the computer science (CS) department.(5 marks)

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!

How should Powder River have recorded the sales of the working interests and the guaranteed payments made to the purchasers of those working interests in its accounting records?

Exercise III: Structured Query Language (25 marks) * Department (Deptid, Dname). * Course (CrsId, Cname, DeptId). * Student (Stdld, Sname, level, DeptId). * Enroll(stdia, Crsid, year). * Evaluation...

SQL Assignment ACCTG 333 - Fall 2021 (Professor Perols) Why should you learn SQL? Technology is drastically changing the accounting industry...and structured query language (SQL) is one of the...

SQL Assignment ACCTG 333 Fall 2021 (Professor Perols) Why should you learn SQL? Technology is drastically changing the accounting industryand structured query language (SQL) is one of the...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

QUESTION 4 Structured Query Language (TOTAL: 10 MARKS) Structured query language (SQL) allows database users to interrogate data in a database. Required: The New Zealand Police Department created a...

the question is listed in proper order The following is a set of tables for the Art Course database shown in Figure 1- 12. For the data for these tables, use the data shown in Figure 1-12. CUSTOMER...

Page 1 of 4 SQL Assignment ACCTG 333 - Fall 2019 Professor Perols Due Friday, November 8, 2019 Why should you learn SQL? Technology is drastically changing the accounting industry...and structured...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Assignment: Use the attached Assignment3.xlsx file as an example of a horrible database design. Your task is to create a list of "normalized" tables using "relational notation". You will need to...

Back ( 3 ) Week 5 Database Exercise Instructions CO 5 : Examine the rudiments of the Structured Query Language ( SQL ) . Instructions Note the techniques below associated with the rudiments of...

$20,000 and common shares $40,000. The acquisition differential was fully amortized by the end of Year 13. Barbara sold Land to Joel during Year 12 and recorded a $15,000 gain on the sale. At...

How does crowding affect shopping behavior?

if the market price of a bond exceeds it face amount: a. the coupon rate is less, b. the coupon rate is more, c. the company's ROI and working capital increase, d. the maturity rate has been declining

I need help with a java assignment: Pedagogical Note: Assignment: Pedagogical Note The exercises in Chapters 9-13 help you to achieve three objectives: 1. Design classes and draw UML class diagrams....

5. Do you have any foreign language proficiency?

4. How did AbbVies new system improve operations and management decision making?

2. Have you ever worked with online databases or database software? Exactly what did you do with these databases? Did you ever take a database course?