QUESTION 18 The maximum value that can be stored by defining an attribute as NUMBER (5,3) is O a. 99.999 O b. 9.999 Oc. 99999.999 O d. 55.333 QUESTION 19 ... will change department ID 20 of employee table to 15. O a. UPDATE Employee SET Department ID = 15 WHERE Department ID = 20; !! UPDATE Employee SET Department ID = 20 WHERE Department ID = 15; Ob. Oc. UPDATE Employee SET Department_ID = 20: Od UPDATE Employee SET Department_ID = 15

Q: The query that displays names of employees , sex , and evaluation of the salary for each department…

A: SELECT AVG(salary) /*incorrect*/ FROM EMPLOYEE, DEPENDENT  /* a salary is included once */ WHERE…

Q: Question 6 Consider the following table schema: CREATE TABLE members( member_id INT, first_name…

A: To Do: We need to identify the column for indexing.

Q: Create a Horse table with the following columns, data types, and constraints: ID - integer with…

A: I have provided the query to create a horse table with Id, RegistreredName, Breed and Height and…

Q: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.   Expected…

A: Required: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.…

Q: nsert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up…

A: Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set…

Q: Note that primary keys are in BOLD. Note also that attributes with the same name in different tables…

A: Here have to determine about SQL statement of given problem statement.

Q: Given the following table TABLE CUSTOMER Column Null? Туре CUS_ID NOT NULL NUMBER NAME VARCHAR2(50)…

A: B. SELECT cus_id "Customer_id", name From customer: It will  show error due to "Customer_id". C.…

Q: 1. Write a query to alter the “Student” table, by setting the default value of Age > 20. 2. Drop…

A: Q. IN MYSQL 1. Write a query to alter the “Student” table, by setting the default value of Age >…

Q: (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST NAME , EMAIL…

A: Which query is the most appropriate to display employee id, first name and salary in hundreds for…

Q: (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL…

A: B)  Not B Reason- Here, = is used for matching, as the subquery returns multiple records, equality…

Q: (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST_NAME , EMAIL…

A: Given data is shown below:

Q: Which attribute may return NULL?     %FOUND     %ISOPEN     %NOTFOUND     %ROWCOUNT

A: %FOUND A cursor attribute that can be appended to the name of a cursor or cursor variable. Before…

Q: the LIKE operator to match exactly one character, which one(s) of the following symbols should be…

A: The answer with correct options is given in step 2.

Q: For each item below, specify whether the statement is true (T) or false (F). It is possible for the…

A: Here the question is to find true(T) or False (F) statements which are given in step 2.

Q: 10. print FLOOR(SQRT(5)) statement returns a) 5. b) 2. с) 3. d) 2.23. e) 25. 11. Which one of the…

A: I have given an answer in step 2.

Q: Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set…

A: insert into CUSTOMER(CUST_LNAME, CUST_FNAME, CUST_BALANCE)values('Powers', 'Ruth', 500);

Q: We want to select all employees from a table named EMPLOYEE for employees whose last name is not…

A: SELECT * FROM employee WHERE Last_Name <>  'Adam' ;

Q: CREATE TABLE sales ( "year SMALLINT NOT NULL, "quarter' TINYINT NOT NULL, region VARCHAR (50) NOT…

A: CREATE TABLE sales( 'year' SMALLINT NOT NULL, 'quarter' TINYINT NOT NULL, region varchar(50) NOT…

Q: Consider the following relation schemas:   Department (dnumber, dname, employee_count), PK: dnumber.…

A: Create a trigger on the relational schema, to count the number of employees in the department table…

Q: (Consider table employees with the following colunms (EMPLOYEE_ID, FIRST NAME, LAST NAME, EMAIL…

A: the answer is...

Q: A simple database composed Tollowing tables: PATIENT, TOR, DRUG, PRESCRIPTION, is now loaded with…

A: As per the guidelines we have given answer for the first three queries. You can find the solution in…

Q: Given the following table TABLE EMPLOYEE Column Null? Туре EMP_ID NOT NULL NUMBER EMP_LNAME VARCHAR2…

A: Answer: d

Q: QUESTION 26 There are two datasets on online auctions. D1 has the number of the bids for an auction…

A: Given that, there are two data sets D1 and D2. D1 contains number of the bids for an auction item D2…

Q: #3 At a given organization, the COVERAGE_MEMBER_LIST table has 500 rows of data. Exactly 200 of…

A: If count Function can be used as count(*)  will return the number of rows in a specified table or…

Q: My anserwer has erro in line 1, how to fix? Add a column named Base_salary with a datatype of…

A: ALTER COMMAND: The alter command for any database is used to perform any kind of modification in…

Q: 1- What will be the result of the following query? Give explanation? CREATE TABLE Employee(Emp.jd…

A: By given instruction, a table will be created by using the given SQL query and some records will be…

Q: Hello, I need help on this sql query statement. Write a SELECT statement to create a lesson…

A: Solution:   The queries that should perform is Provided the Creation, Insertion and Selection…

Q: Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set…

A: insert into CUSTOMER(CUST_LNAME, CUST_FNAME, CUST_BALANCE)values('Powers', 'Ruth', 500);

Q: Kindly use the hospital relational schema provided below to solve these questions.   2. List…

A: Find the required query given as below :

Q: Given the following table TABLE EMPLOYEE Column Null? Туре EMP_ID NOT NULL NUMBER EMP_LNAME…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: 2. List Registration numbers of all patients in H02, ward W18 who have been diagnosed with "Flu"…

A: List Registration numbers of all patients in H02, ward W18 who have been diagnosed with "Flu" but…

Q: Suppose you have a table called D with the schema/header (c1 TEXT, c2 TEXT, dist REAL). c1 and c2…

A: The query that will work are given below:

Q: 4. Consider the follwing Customers table CREATE TABLE Customers ( Customer_ID INT NOT NULL PRIMARY…

A: DELETE Syntax DELETE FROM table_name WHERE condition;

Q: Database name: Ch03_VendingCo Table name: BOOTH Table name: MACHINE BOOTH PRODUCT Chips BOOTH PRICE…

A: Operators in Relational Databases: The UNION operator is applied when all the rows of results of…

Q: sing this table Create table book (title INT, year INT, num INT, subect Varchar); Create table…

A: 1-   The relational schema is the blueprint of a database, metadata describes and is organized into…

Q: re this salary range per customer. The query should display the attributes as problem 1 but also…

A: Solution:-

Q: Prompt: You work in the Procurement Department, and you need a list of select items carried for sale…

A: I have solve the SQL query below see it ... SQL statement::  SELECT Product.ProdName,…

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: Joins 1. Which books were written by an author with the last name Adams? Perform the search using…

A: Short Summary: Provided the Create, Insert and Select queries performed on tables Customers, Orders,…

Q: i. Get all employees who have salary less than ‘Ward’ salary. ii. Get all employees data who belong…

A: Fetch the Ward salary Use this result for comparison as subquery and the query looks as follows…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: As per Bartleby's answering guidelines if there are multiple questions then only the first three…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: NOTE: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: Consider the below Student table and write the appropriate relational algebra query: City SNAME…

A: Relational algebra query : It is a step by step process to obtain the result of the query. It uses…

Q: Examine the table structure as given. SOL» DESC employees Name Null? Type - EMPLOYEE_ID NOT NULL…

A: The answer is

Q: ЕMP EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO Dept DEPTNO DNAME LOC - MGR field is foreign key…

A: Table creation: create table Dept (DEPTNO varchar(10) primary key, DNAME varchar(20), LOC…

Q: For each of the following statements, circle T (True) or F (False)

A: Defined the given statement true or false

Q: Hello, I received the following assignment questions and I am not sure how to answer them. Can you…

A: The answer is given below:-

Q: Suppose a query shrkByStoreByWeek that determined the dollar amounts and counts of shrinkage by…

A: Answer to the given question: To create a new query show shrinkage by the store we need to open the…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.