Use the following precision for each row: Attribute Name Attribute Precision CHAR_WAIT_CHG 6,2 CHAR_FLT_CHG_HR 6,2 CHAR_FLT_CHG 10,2 CHAR_TAX_CHG 6,2 CHAR_TOT_CHG 10,2 CHAR_PYMT 10,2 CHAR_BALANCE 10,2 TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric Flight charge (calculated by CHAR_HOURS_FLOWN × CHAR_FLT_CHG_HR) CHAR_FLT_CHG Numeric CHAR_TAX_CHG CHAR_FLT_CHG × tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numeric

Use the following precision for each row: Attribute Name Attribute Precision CHAR_WAIT_CHG 6,2 CHAR_FLT_CHG_HR 6,2 CHAR_FLT_CHG 10,2 CHAR_TAX_CHG 6,2 CHAR_TOT_CHG 10,2 CHAR_PYMT 10,2 CHAR_BALANCE 10,2 TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric Flight charge (calculated by CHAR_HOURS_FLOWN × CHAR_FLT_CHG_HR) CHAR_FLT_CHG Numeric CHAR_TAX_CHG CHAR_FLT_CHG × tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numeric

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.13CP

See similar textbooks

Similar questions

Please help me to transcribe SQL codes to python codes create table ab asselect *from aliWHERE itemprice IS NOT NULL; SELECT COUNT(MerchandiseCode), UserIDFROM abGROUP BY useridORDER BY COUNT(MerchandiseCode) DESC; select sum(totalsales), useridfrom abgroup by useridorder by sum(totalsales) desc; SELECT COUNT(transactiondate), UserIDFROM abGROUP BY useridORDER BY COUNT(transactiondate) DESC;
Create an ADD TRIGGER. Explain what the trigger does. Test and show the related results of this trigger. Table 1: CREATE TABLE BSR_PASSENGER (PASSENGER_ID INT NOT NULL UNIQUE, FULL_NAME VARCHAR(30), COUNTRY VARCHAR(40), CITY VARCHAR (40), PRIMARY KEY (PASSENGER_ID)); Table 2: CREATE TABLE BSR_FLIGHT (FLIGHT_ID INT NOT NULL UNIQUE, AIRLINE_NAME VARCHAR(50), CREW_MEMBERS INT, PRIMARY KEY (FLIGHT_ID)); Table 3: CREATE TABLE BSR_BOOKING (BOOKING_ID INT NOT NULL UNIQUE AUTO_INCREMENT, PASSENGER_ID INT NOT NULL, FLIGHT_ID INT NOT NULL, COST DEC(6,3), PRIMARY KEY (BOOKING_ID), FOREIGN KEY (PASSENGER_ID) REFERENCES BSR_PASSENGER(PASSENGER_ID), FOREIGN KEY (FLIGHT_ID) REFERENCES BSR_FLIGHT(FLIGHT_ID));
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
Write an appropriate SQL query to display all the STUDENT_SURNAMES and STUDENT_NAMES, as well as the MODULE_NAMES that the student is registered for. Sort results according to student surname in ascending order.Sample results:STUDENT MODULEMoore, Derek Database IntermediateNtaba, Pedro Database IntermediateNtaba, Pedro Desktop PublishingNtaba, Pedro Web Development (Intermediate)Petlele, Neo Programming 2APetlele, Neo Programming 2BSmith, Dominique Programming 2ASmith, Dominique Programming 2BSmith, Dominique Web Development (Intermediate)
Below are some rows of the table INVOICE COD PROV_COD DATE TYPE LOC TOTAL 2910 192 2022-03-11 90 TX 1928 9301 384 2022-05-03 90 NY 2800 Overdue invoices are those whose date plus TYPE days have passed. Which of the following shows all invoices with overdue dates? a. SELECT * FROM INVOICE WHERE CURDATE() - DATE > TYPE b. SELECT * FROM INVOICE WHERE CURDATE()-TYPE >DATE c. SELECT * FROM INVOICE WHERE DATE+TYPE < CURDATE() d. SELECT * FROM INVOICE WHERE DATE+TYPE > CURDATE()
The head of hospital auditing wants to know which patients were charged the most for a treatment. The result table should list three columns from the treatment table appropriately labeled: pat_id, actual_charge, and service _id .Only list rows where the patient was charged the most for a treatment. This may result in some rows where patients were charged identical amounts to other patients. Sort the rows by service_id. Use a correlated subquery. Format the output appropriately.
SQL Table: CREATE TABLE employees ( employee_id INT PRIMARY KEY, first_name VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255) UNIQUE, phone_number VARCHAR(255), hire_date DATE, job_id VARCHAR(255), salary DECIMAL(10,2), commission_pct DECIMAL(5,2), manager_id INT, department_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id), FOREIGN KEY (department_id) REFERENCES departments(department_id)); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_name VARCHAR(255), manager_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id)); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id)VALUES (1, 'John', 'Doe', 'john.doe@example.com', '555-555-5555', '2022-01-01', 'IT_PROG', 8000, 0.2, 3, 10), (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-555-5556', '2022-02-01', 'IT_PROG', 9000,…
SQL CREATE TABLE `zoo`.`Habitats`( `id` INT(50) NOT NULL AUTO_INCREMENT, `habitatName` VARCHAR(50), `habitatLocation` VARCHAR(50), PRIMARY KEY (`id`) ); CREATE TABLE `zoo`.`Animal`( `animalId` INT(50) NOT NULL AUTO_INCREMENT, `animalName` VARCHAR(50), `animalBirthdate` DATE, `species` VARCHAR(50), `habiat` INT(50), PRIMARY KEY (`animalId`), FOREIGN KEY (`habiat`) REFERENCES `zoo`.`habitats`(`id`) ); Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.
(MySQL) The files are in the images attached. Q2. Use Employee.sql and Office.sql and write queries to extract the following information: Get IDs of employees whose first name starts with “pa”, followed by three characters and then ends with “a”. Show the first name along with the employee ID. How many employees at non-regional offices were hired after 2000? Get the Employee ID of the newest Account Rep who is working in a location with audit code=100.
PLz help with the following Please implement the following using Oracle live/SQL Developer: 1- Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id). 2- Populate every relation with three rows. 3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task? 4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
Kindly use the hospital relational schema provided below to solve these questions. 2. List Registration numbers of all patients in H02, ward W18 who have been diagnosed with "Flu" but for whom "Chest X-ray" test has not been ordered.a) First get a table with only one column RegistrationNumber, which lists all patients from W18 of H02 who have been diagnosed with flu.b) Second, get a table with only one column RegistrationNumber, which lists all patients from W18 of H02 who have had a test with Tname="Chest X-ray".c) Finally, take the set difference.
Assume you have these tables.. Q) Write in SQL queries to populate the above tables by inserting minimum 4 tuples in each one. CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID)…