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

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 11:00

Which law requires employers to provide safe working environments for their employees? a. civil rights act b. fair labor standards act c. occupational safety and health act d. wagner act

Answers: 1

Answer

Computers and Technology, 22.06.2019 22:00

Consider the following declarations (1, 2, 3, 5, 7)class bagtype{public: void set(string, double, double, double, double); void print() const; string getstyle() const; double getprice() const; void get(double, double, double, double); bagtype(); bagtype(string, double, double, double, double); private: string style: double l; double w; double h; double price; }; a.) write the definition of the number function set so that private members are set according to the parametersb.) write the definition of the member function print that prints the values of the data membersc.) write the definition of the default constructor of the class bagtype so that the private member variables are initialized to "", 0.0, 0.0, 0.0, 0.0, respectively d.) write a c++ statement that prints the value of the object newbag.e.) write a c++ statement that declares the object tempbag of type bagtype, and initialize the member variables of tempbag to "backpack", 15, 8, 20 and 49.99, respectively

Answers: 3

Answer

Computers and Technology, 23.06.2019 06:00

What makes myhexadecimalnumber a child of mynumber? which methods does myhexadecimalnumber inherit directly from the mynumber class? what can an instance of the mynumber class do? what can an instance of the myhexadecimalnumber class do? which methods are overridden? why are they overridden? how many examples of overloading are there? why was this done? where is the super keyword used? what is it doing? why isn’t the incoming value set immediately in the second myhexadecimalnumber constructor? how many examples can you find of an inherited method being called?

Answers: 1

Answer

Computers and Technology, 23.06.2019 07:30

What are ways to switch windows in excel? check all that apply. on the status bar, click the windows button, and then click the file name. on the task bar, click to display the excel jump list, and then click the file name. on the view tab, in the window group, click switch windows, and then click the file name. on the review tab, in the viewing group, click files, and then click the file name.

Answers: 1

Answer

You know the right answer?

Given the following tables: students(sid, name, age, gpa) courses(cid, deptid, name) professors(ssn,...

Questions