![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 16.11.2020 18:00 queeneaf
Given the following tables: students(sid, name, age, gpa) courses(cid, deptid, name) professors(ssn, name, address, phone, deptid) enrollment(sid, cid, section, grade, foreign key (sid) references students, foreign key (cid) references courses foreign key (cid, section) references teaches) . teaches(cid, section, ssn foreign key (cid) references courses foreign key (ssn) references professors) Domain » cid is in '198:11','640:151','198:112',...^ . deptid is in ['cs','math','music',.. . grade is in ['A','B','C,... » section, age, ssn are an integers » address, phone, name are strings » gpa is float Provide SQL instructions for each of the following questions 1. Create the database schema. 2. Find the name of professors that work for the cs department. 3. Find those students (sid) enrolled in courses in the cs department 4. List ssn and name of professors that work for the cs department, but are not teaching any cs courses 5. List the number of courses offered by each department. Just the number of courses (not sections) 6. List of those departments that offer more than 10 courses 7. Produce a list of the name of those students whose professor's name starts with an M. Your result must have no duplicates
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 17:30, uh8hardiek
Ou listened to a song on your computer. did you use hardware or software?
Answers: 2
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 04:31, legendman27
Jennifer has to set up a network in a factory with an environment that has a lot of electrical interference. which cable would she prefer to use? jennifer would prefer to use because its metal sheath reduces interference.
Answers: 1
You know the right answer?
Given the following tables: students(sid, name, age, gpa) courses(cid, deptid, name) professors(ssn,...
Questions in other subjects:
![Konu](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 30.08.2020 01:01
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 30.08.2020 01:01
![Konu](/tpl/images/cats/obshestvoznanie.png)
![Konu](/tpl/images/cats/health.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 30.08.2020 01:01
![Konu](/tpl/images/cats/istoriya.png)
History, 30.08.2020 01:01