Draw the ERD TI e ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER ID NUMBER NOT NULL, USER NAME VARCHAR2(50) NOT NULL, USER EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ): CREATE TABLE PROJ_CERTIFIEDUSER USER ID NUMBER NOT NULL, CUSER REALNAME VARCHAR2(50) NOT NULL, CUSER CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );

Draw the ERD TI e ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER ID NUMBER NOT NULL, USER NAME VARCHAR2(50) NOT NULL, USER EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ): CREATE TABLE PROJ_CERTIFIEDUSER USER ID NUMBER NOT NULL, CUSER REALNAME VARCHAR2(50) NOT NULL, CUSER CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );

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

SQL QUERIES Employees(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID,DEPARTMENT_NAME)Department(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)Location(LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) Write a query in SQL to display the DEPARTMENT_NAME of all those Departments whoseDEPARTMENT_ID is greater than the DEPARTMENT_ID of Physics department. Write a Query in SQL to show the FIRST_NAME of all those employees whose salary is lessthan the salary of all those employees whose MANAGER_ID is 101 or 102.
Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.● Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)● After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11● Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305.…
HW2: Basic SQL 1. Write a query that will show all probation officers 2. Write a query that will show the first and last names of probation officers 3. Now write a query that shows first and last name of probation officers. Include the field prob_id but rename prob_id to probation officer ID. 4. Write a query that will show crime id, and the total charges for each crime ID. Include an alias for the total charges column called Total Charges. 5. Write a query that will concat the last and first names of criminals into one column. Add a space and comma between the last and first name of criminals. Give the column the alias Criminal Name. 6. List the last name and first name of all authors in only 1 column. Add a comma to separate the two names. 7. Run a query that will return the order#, item#, isbn, quantity, paideach. Include in the query a arithmetic operation that will total quantity and paideach. Alias the virtual column so it is labeled Item Total
WorksOn Database: Employee (EmployeeNumber, EmployeeName, BirthDate, Title, Salary, DepartmentNumber) Project (ProjectNumber, ProjectName, Budget, DepartmentNumber) Department (DepartmentNumber, DepartmentName, ManagerNumber) WorksOn (EmployeeNumber, ProjectNumber, Responsibility, Hours) Questions: 1) Write an SQL query that returns the project number and name for projects with a budget no greater than $1,050,000. 2) Write an SQL query that returns all works on records where hours worked is less than 5 and the responsibility is 'Manager'. 3) Write an SQL query that returns the employees (number and name only) who have a title of 'EE' or 'SA' and make more than $50,000. 4) Write an SQL query that returns the employees (name and salary only) in department 'D1' ordered by decreasing salary. 5) Write an SQL query that returns the departments (all fields) ordered by descending department name.
**In SQL** Write a SELECT statement that returns these columns: InstructorDept The DepartmentName column from the Departments table for a related instructor LastName The LastName column from the Instructors table FirstName The FirstName column from the Instructors table CourseDescription The CourseDescription column from the Courses table CourseDept The DepartmentName column from the Departments table for a related instructor Return one row for each course that’s in a different department than the department of the instructor assigned to teach that course. (Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.)
1.Question Workspace Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical. 2.Question Workspace Write an SQL query to display every therapist's first name and last name as their full name, but only for those instructors not living in zip code 72511.
Write the following SQL Statements: Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address from the Customers table A count of the number of orders The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.) Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the sum of the line item amounts. Write a SELECT statement that answers this question: What is the total amount ordered for each product? Return these columns: The product name from the Products table The total amount for each product in the Order_Items (Hint: You can calculate the total amount by subtracting the discount amount from the item price and then multiplying it by the quantity) Use the ROLLUP operator to include a row that gives the grand total. Write a SELECT statement that answers this question: Which customers have ordered more…
Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.
SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_ LAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME. Delete the guide whose number is stored in I_GUIDE_NUM
HOW TO FIX THIS CODE IN ORACLE SQL ?CREATE OR REPLACE PROCEDURE CONVERT_VAL(V1 VARCHAR,V2 VARCHAR,AMT NUMBER) IS val VARCHAR2(100); val1 VARCHAR2(2); val2 varchar2(2); amount number; DECLARE meter NUMBER := 0; Cem NUMBER := 0; BEGIN val1:=v1; val2:=v2; amount:=amt; Select case when val1!=val2 then case when lower(val1)='km' meter := km * 1000; Cem := meter * 100; dbms_output.Put_line('The value of KM NUMBER KM to meters is: ' ||meter); dbms_output.Put_line('The value of KM NUMBER KM to centimeters is: ' ||cem); when lower(val1)='m' dbms_output.Put_line('The value of M NUMBER M to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER M to centimeters is: ' ||cem); when lower(val1)='Cm' dbms_output.Put_line('The value of M NUMBER CM to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER CM to M is: ' ||M); else 'same…
Write an SQL statement that will insert an order in the orders table with the following data: cutomerID=3, orderDate = current date, shipAmount=20, taxAmount=23.56, shipDate=a week after current date, shipAddressID=3, cardType=2, cardNumber=4123123412341234, cardExpires=05/2024, billingAddressID=3 Write an SQL statement to delete all orders that are created between 2017-06-01 and 2017-06-07.