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

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 13:30
Best laptops for college [$100-$500 range]?
Answers: 2
question
Computers and Technology, 24.06.2019 03:00
Click the "draw structure" button to activate the drawing utility. draw two diastereomers of (1z,4r)−1,4−dimethylcyclodecene and name them, including (e)/(z) and (r)/(s) notation. part 1 out of 4 draw the diastereomer containing a chiral center with s configuration here. window open
Answers: 1
question
Computers and Technology, 24.06.2019 19:00
Luis is cloud-based( microsoft bot framework). true false
Answers: 1
question
Computers and Technology, 25.06.2019 06:30
Which component is typically used as an amplifier a battery a transistor a microchip a diode
Answers: 1
You know the right answer?
Given the following tables: students(sid, name, age, gpa) courses(cid, deptid, name) professors(ssn,...
Questions
question
Mathematics, 28.10.2020 18:30
question
Mathematics, 28.10.2020 18:30
question
Mathematics, 28.10.2020 18:30
Questions on the website: 13722360