There are two csv files: visit.csv and patient.csv. Below is the description of the data in each File. The visit.csv contains data for 17,580 emergency room (ER) visits: Description ID for each unique visit. ID for each unique patient. Reason for each ER visit. The values include: °Pain back', 'Difficulty Breathing', etc. Urgency of the visit reason. The values include: “Lowest', 'Low', | 'Medium', 'High', 'Highest', 'Unknown'. How a patient is transported to the emergency room. The values include: Private Vehicle, EMS Ground, EMS Air, Walk, Public Trans, Police/Jail. Whether a patient is admitted to hospital after the emergency room visit. The values include: 'Yes' or 'No’. | Cost of emergency room visit. Date of arrival to emergency room. Date of discharge from emergency room. Column Name VisitID PatientID VisitReason Urgency ArrivalMode |HospAdmit Cost ArrivalDate |DischargeDate The visit.csv (described above) includes data for 13,390 patients. The information for all these patients is stored in patient.csy: Column Name |Description ID for each unique patient. Gender of a patient. The value is either 'Male' or 'Female'. | Age of a patient. PatientID Gender Age

There are two csv files: visit.csv and patient.csv. Below is the description of the data in each File. The visit.csv contains data for 17,580 emergency room (ER) visits: Description ID for each unique visit. ID for each unique patient. Reason for each ER visit. The values include: °Pain back', 'Difficulty Breathing', etc. Urgency of the visit reason. The values include: “Lowest', 'Low', | 'Medium', 'High', 'Highest', 'Unknown'. How a patient is transported to the emergency room. The values include: Private Vehicle, EMS Ground, EMS Air, Walk, Public Trans, Police/Jail. Whether a patient is admitted to hospital after the emergency room visit. The values include: 'Yes' or 'No’. | Cost of emergency room visit. Date of arrival to emergency room. Date of discharge from emergency room. Column Name VisitID PatientID VisitReason Urgency ArrivalMode |HospAdmit Cost ArrivalDate |DischargeDate The visit.csv (described above) includes data for 13,390 patients. The information for all these patients is stored in patient.csy: Column Name |Description ID for each unique patient. Gender of a patient. The value is either 'Male' or 'Female'. | Age of a patient. PatientID Gender Age

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 an SQL query to list the salesperson who has sold the most computer desks.
You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.
Consider the following table: Instructors ID 12121 15151 22222 32343 33456 name Alice Wu John Mozart Frank Einstein El Said Chelsea Dunn deptName Finances Music Physics History Physics salary 90000.00 40000.00 95000.00 60000.00 90000.00 Write a single SQL query to list in descending order the deptNames and names of all instructors. Note that every column of Instructors should be included in the result.
Write an SQL query to extract the answer directly.
How does the SQL ORDER BY clause work, and why might it be important when using database functions like MAX() or MIN()? Provide a query illustrating its usage.
Find a SQL query that computes a set difference and returns false positive(s) over a database with null values. You may show the correctness of your answer using an example.
Write an appropriate SQL query to determine which modules have the same number of credits.
write SQL queries to create procedures for a database called Saleco. The database contains the following tables: customer, invoice, line, product, and vendor. A procedure called get_customer_invoices that takes a customer ID as input and returns a list of all invoices for that customer, along with the total amount due for each invoice. A procedure called get_vendor_products that takes a vendor ID as input and returns a list of all products sold by that vendor, along with the number of units sold and the total revenue generated for each product. A procedure called get_invoice_details that takes an invoice ID as input and returns a list of all products purchased on that invoice, along with the quantity purchased, the unit price, and the total price for each product.
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.
Write any five PL/SQL programs.
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.
Write an equivalent SQL query using natural join for the following expression of relational algebra I14. .B, C, r.D, E (o r.8- r.B - s.B A r.D - s.D (r x s)))