Using the commands SELECT, PROJECT, and JOIN write a sequence of instructions to answer each of the following questions about branches and their courses in terms of the following database: a. Which branches offer IT665? b. List all the branches present in Branch relation. c. Which branches offer 4 credit courses? Course relation CName ID Networks IT655 DataBase CS543 VLSI EC653 Branch relation BName Computer Science Computer Science Electronics & Communication Electronics & Communication Information Technology Information Technology ID Credits CS543 4 EC653 5 IT655 4 EC653 5 CS543 4 IT655 4

Using the commands SELECT, PROJECT, and JOIN write a sequence of instructions to answer each of the following questions about branches and their courses in terms of the following database: a. Which branches offer IT665? b. List all the branches present in Branch relation. c. Which branches offer 4 credit courses? Course relation CName ID Networks IT655 DataBase CS543 VLSI EC653 Branch relation BName Computer Science Computer Science Electronics & Communication Electronics & Communication Information Technology Information Technology ID Credits CS543 4 EC653 5 IT655 4 EC653 5 CS543 4 IT655 4

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write the SQL statements to perform the following operations: a. Create a new course “CS-001”, titled “Weekly Seminar”, with 0 credits. b. Create a section of this course in Fall 2017, with sec id of 1, and with theclocation of this section not yet specified. c. Enroll every student in the Comp. Sci. department in the above section. d. Delete enrollments in the above section where the student’s ID is 12345. e. Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course? f. Delete all takes tuples (i.e., rows) corresponding to any section of any course with the word “advanced” as a part of the title; ignore case when matching the word with the title.
Using the Categories, Subjects, and Classes tables, list the category description, SubjectID, SubjectCode, and SubjectName for all subject that are taught on Wednesdays. Do not list any subject more than once.
Please use sql to answer the follwoing question (an erd has also been add) Task 2: Task: UPDATE all employees salary in department 40 or 60 depending on their current salary range. Create a cursor and load all the records belongs to employees who works in department either in 40 or 60 a) Include employee_id, last_name, department_id and salary in Cursor SELECT Cursor cur_emp1 IS SELECT employee_id, last_name, department_id, salary FROM EMPLOYEES WHERE department_id IN (40,60); b) Now inside BEGIN and END block create CURSOR FOR LOOP with k keyword. FOR k IN cur_emp1 LOOP END LOOP; now inside above for loop check each records salary IF If employee salary is less than 5000 then add 20% of their salary and update actual phsyical table update employees SET salary= salary*1.20 WHERE employee_id = k.salary; Else if if employee salary is less then 8000 add 15% update employees SET salary=…
Referring to the Set Operations image above, which relational operation should I use to list all certificates that all students have ever earned by STU#? Question 43 options: 1) Union 2) Intersect 3) Difference 4) Join 5) None of the above
Please help me as this is in regards to Oracle 12 database Question 7 IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you search Question 7 options: True False Question 8 What will the following statement return after execution? SELECT employeenumber, lastname, email FROM products ORDER BY employeenumber DESC and email; Question 8 options: The results are sorted first numerically and then alphabetically. The results are sorted first numerically from high to low and then alphabetically. The results are sorted first alphabetically and then numerically. The query returns an error. Question 9 Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000? Question 9 options: ORDER BY SALARY > 5000 GROUP BY SALARY > 5000 WITH SALARY > 5000 WHERE SALARY > 5000
You decided to create a client ID field for the primary key since some clients have the same name as others. Now you need to decide on a name for the field. The field name should make it clear that the field is a unique identifier for each record in order for it to be valuable for others using the database. What field name will help you track the relevant information as you work with this table? a)ClientID . b)PrimaryKey.
An employee of BITS Corporation created the query shown in Figure 2-48. She wants to list the client number and the task IDs associated with each order. Will the query results be correct? If so, list other fields that would be useful. If not, how should she modify the query to achieve this result?
For each of the following statements, circle T (True) or F (False) 1 A row of data has to be all the same data type T F 2 A column of data has to be all the same data type T F 3 A data warehouse is a repository of information gathered from one Relational database T F 4 A trigger can only be connected to one table, and only update one table T F 5 If none of the attributes in the WHERE clause have indexes, the DBMS engine will be forced to do full table scans T F 6 You can have multiple triggers on the same table, and a trigger can be assigned to multiple tables T F 7 You should put an index on any attribute found in a WHERE clause T F 8 Checkpoints help the Recovery Manger streamline the recovery procedure T F 9 Big Data applications strictly adhere to ACID properties T F 10 A data warehouse should be used for OLAP processing T F
please use the picture to answer the following question Normalize below user view to the third normal form. Show all steps (UNF, 1NF, Dependencies, 2NF, 3NF).
7a-
Based on the ERD below, write the SQL statement to change the job description of “Database Designer” to “Database Developer”. After completing this task examine the results with a select statement. (Hint: Use an Update Statement.)