![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
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 12:30
Some of the first computer games were created in the early 1970s by college students experimenting after hours to see what the were capable of doing.
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 22:10
Asequential circuit contains a register of four flip-flops. initially a binary number n (0000 ≤ n ≤ 1100) is stored in the flip-flops. after a single clock pulse is applied to the circuit, the register should contain n + 0011. in other words, the function of the sequential circuit is to add 3 to the contents of a 4-bit register. design and implement this circuit using j-k flip-flops.
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 06:00
What machine listens for http requests to come in to a website’s domain? a. a router b. a browser c. a server d. a uniform resource locator
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 17:30
Per the municipal solid waste report, what are the most common sources of waste (trash
Answers: 3
You know the right answer?
Given the following tables: students(sid, name, age, gpa) courses(cid, deptid, name) professors(ssn,...
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 03.01.2021 14:00
![question](/tpl/images/cats/mat.png)
Mathematics, 03.01.2021 14:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
English, 03.01.2021 14:00
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/health.png)
Health, 03.01.2021 14:00
![question](/tpl/images/cats/en.png)
English, 03.01.2021 14:00
![question](/tpl/images/cats/en.png)
English, 03.01.2021 14:00
![question](/tpl/images/cats/mat.png)
Mathematics, 03.01.2021 14:00
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 03.01.2021 14:00
![question](/tpl/images/cats/en.png)
English, 03.01.2021 14:00
![question](/tpl/images/cats/ekonomika.png)
Business, 03.01.2021 14:00
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 03.01.2021 14:00
![question](/tpl/images/cats/mat.png)