subject

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
Answers: 1

Other questions on the subject: Computers and Technology

image
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
Computers and Technology, 22.06.2019 18:00, crimhill
When is it appropriate to use an absolute reference
Answers: 1
image
Computers and Technology, 22.06.2019 20:00, jc624826
What side length would you specify if you were required to create a regular hexagonal plate that was composed of 33 cm(squared) of sheet metal? dimension the side length to 0.1 cm
Answers: 2
image
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
Mathematics, 30.08.2020 01:01
Konu
Mathematics, 30.08.2020 01:01