Computers and Technology, 02.06.2020 21:57 SiegeHatake4534

Consider the following relational schema, where the primary keys are Bold,
Students(sid, sname, address, dept_id)
Courses(cid, cname, dept_id)
Departments(dept_id, dname, college)
Grades(sid, cid, year, semester, grade)
Write the following queries in SQL. Only use the tables that are absolutely needed for the corresponding query.
1. Find the sids and snames of students who took "Database" course (i. e., cname = ‘Database’) in Fall 2019.
2. Find the average grade of all the students who took "CS327" (i. e., cid=‘CS327’) in Fall 2019. You can assume grade is a numerical attribute.
3. Find the number of distinct courses offered by each department in Fall 2019.
4. Find the sids of students who have taken at least 10 different courses offered by "Computer Science" department (i. e., dname = ‘Computer Science’).

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 23:30

Creating "smart interfaces" in all sectors of industry, government, and the public arena is one of the fastest growing hct areas. these interfaces model, interpret, and analyze such human characteristics as speech, gesture, and vision. the field of biometrics, in which humans authenticate themselves to machines, is an area of considerable interest to hct practitioners. fingerprint scans are one of the most frequently used biometric options, and this article, biometric student identification: practical solutions for accountability & security in schools, makes a case for the implementation of fingerprint scans in schools. critique the article, and answer the following questions: according to the author, what are the main benefits of adopting fingerprint scans in schools for student identification? according to the author, what are the main drawbacks of adopting fingerprint scans in schools for student identification? do you agree with the author's assessment of the pl

Answers: 2

Answer

Computers and Technology, 23.06.2019 16:30

If i wanted to include a built-in calendar in a document, what option could i select? draw table insert table insert chart quick tables

Answers: 1

Answer

Computers and Technology, 23.06.2019 20:30

If an appliance consumes 500 w of power and is left on for 5 hours, how much energy is used over this time period? a. 2.5 kwh b. 25 kwh c. 250 kwh d. 2500 kwh

Answers: 1

Answer

Computers and Technology, 24.06.2019 00:30

Afiling system in which an intermediary source of reference, such as a file card, must be consulted to locate specific files is called a(n) system. a. shelf filing b. direct filing c. indirect filing d. shingling

Answers: 1

Answer

You know the right answer?

Consider the following relational schema, where the primary keys are Bold,
Students(sid, snam...

Questions

Computers and Technology, 17.07.2019 08:00

Application software definition word excel powerpoint microsoft...