15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by the first name. For example, your result set might look like this: I fÅKstname | Married? | Biff | George | Jennifer | Lorraine | Marty | no | yes | no | yes | no
Q: 10. When we find out that there are some miss spellings in the query?
A: Given: Where did we discover certain misspellings in the SQL query?
Q: Consider the query:select *from r, swhere upper(r.A) = upper(s.A);where “upper” is a function that…
A: Consider the given query with upper function. It has been assumed that the before finding a plan…
Q: Complete the following table. Customer Arrival Time 0 3 8 10 15 28 1 2 3 4 5 6 Service Time 10 3 7…
A: Waiting time is the length of time processes must wait in the ready queue before being given access…
Q: Write a SQL statement to get the list of all the law firms from the database in alphabetical order…
A: as per Bartleby guidelines we are supposed to answer?️ only one question. Kindly repost other…
Q: Normalize the following table to 3NF. 4 PK StudentNo CourseID StudName | GradeReceived StudCity…
A: Dear Student, In 3NF form the table must not have any transitive dependency , all dependency must be…
Q: Q1: Write a query to find the students working in a company having more ratings than their seniors
A: select student_name from EMPLOYEES RATING TABLE where designation != senior and rating >= 9
Q: How can you change "Hansen" into "Hilsen" in the "LastName" column in the "Persons" table? a)…
A: The syntax for UPDATE statement, when updating a table is: UPDATE table_name SET column1_name =…
Q: Print all the computer sciences courses, these courses with code start with ‘CS’ sorted…
A: As per our company guidelines, we are supposed to answer only three subparts of question and kindly…
Q: Find the first names and last names of employees if they got a salary increase more
A: create table commands and inserting sample data into the table for query create table employees…
Q: Three columns and 20 rows make up 'game1' and 15 rows make up 'game2' in this example. Both tables…
A: Degree and Cardinality: The number of characteristics or columns in a connection is referred to as…
Q: Assume that the above diagram is a partial EER model representing the seat booking system of Virgin…
A: Find the required SQL queries given as below :
Q: A) The total number of bookings on each of the Class IDs that the user has reserved, if the given…
A: Find the required query given as below :
Q: The following is a list of entries with level numbers in a file of employee records: 1 Employee(200)…
A:
Q: ite a PL/SQL program with an IMPLICIT cursor that goes through the table KUCERA and measures the…
A: Please use below to meet the above req
Q: The following Data Base shows some sample data values for an extended form of the Zoo and Visitors.…
A:
Q: Draw an ERD for the Problem Student (Stud_name, Age, Stud_no, Adress (state, city, street), hobby)…
A: Here the Student and Course relationship is N:M where student can enroll for one or many course…
Q: Students Table : • List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to…
A: ANSWER: Student Table: Syntax of SQL Table Statement
Q: Consider the following database: Students name rim sara milad tarek lastname age 19 18 21 18 Select…
A:
Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…
A: In this problem, we need to design a SQL query for the Resort Management System. SQL queries are…
Q: Consider the following sales relational database schema for sales. Item (ItemNo: integer,…
A: SELECT i.itemName, i.type FROM item i INNER JOIN Sales s ON…
Q: Xn+1 = X + 0.25 Based on the relation above, write a code that calculates the values of Xn+1 for…
A: Program approach:- Import a package to standard I/O. Define a class. Define the main function.
Q: 11. In a Database Company, there are two tables given below : Table : SALES Table : LOCATION…
A:
Q: Suppose a school wants to store the data of teachers and the subjects they teach. They create a…
A: Normalization is the process of reducing duplicity from a relation or set of relations. Redundancy…
Q: Question 3 refers to two data tables giving the details of a company's employees and company's job…
A: Please find the detailed query in the below solution.
Q: Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600…
A: Like_a% : this will select then name with its second letter "a"
Q: Write SQLSQL statements for following: Student( Enrno, name, courseId, emailId, cellno)…
A: We need to create tables for Student and Course And we need to insert values into these tables.…
Q: Define users, giving the three groups of users there are.
A: Users A user is a person who utilizes a computer or network service. It includes expert programmer…
Q: Student( Enrno, name, courseId, emailId, cellno) Course(courseId, course_nm, duration) i) Add a…
A: Q: As per bartleby policy, we can only answer 3 subparts per question. Please post rest of sub parts…
Q: What are the differences between main key, candidate key, and superkey?
A: This question expanse abut main key, candidate key, and super key
Q: ASSUME 6.2 IS DONE Write a SQL statement to get the list of all the tasks that started after…
A: Let's understand step by step : 1. Here given that 6.2 is already done so 6.2.1 : Task table is…
Q: Table Valued Function: ufn_FetchAllAppointments This function fetches all the appointment details…
A: As Given, Function is: ufn_FetchAllAppointments We have to fetch all the appointment details from…
Q: Consider the following database: Students Roster name lastname age ID ID major absence rim ismail 19…
A:
Q: convert to tree query? 1. A ← σ b_status = ‘ACCEPTED’ (BILLING) ∏ CID,PRICE(A) 2.…
A:
Q: The table below contains training data from an employee database. The data have been generalized.…
A: The answer is given below:-
Q: Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from…
A: According to the Question below the Solution:
Q: Apply Normalization A table with the students and their grades in different topics. UnitID StudentID…
A: DataBase is a way to manage data.
Q: Write the SQL query that will produce a list of customers who have an unpaid balance.
A: Given, In a table, the last name, first name, initial, and an unpaid balance of each customer is…
Q: A table called "game1" contains three columns and twenty rows, but "game2 has the same column as…
A: Tip It is a list of data linked together and stored in a database in the form of a table.As in…
Q: Use the table below to find the output PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER ID CATEGORY…
A: Required:
Q: Emp ld First name Anil Last name Salary Overtime Manager_ld 320 10 Ramon 500 18 |16 18 17 18 16 11…
A: 1.) SELECT * FROM Employee WHERE salary > 500ORDER BY Country Manager_id;
Q: Write SQL code which declares two variables for name and address. Store your name and address in…
A: DECLARE is use to declare variables in SQL. SET is use to set the value of the variables.
Q: Given SQL statement and data in employees table, what will be the output after the execution? SELECT…
A: SELECT last_name,12*salary*commision_pct "Commission" from employees POINTS TO OBSERVERE: There…
Q: Customer ID 1 2 3 4 5 6 7 8 9 10 Items of transaction {A,B,E,D} {A,C,D,E} {D,E,A} {E,B,A,C}…
A: please do upvote for my efforts ! answer:
Q: Question 3 refers to two data tables giving the details of a company's employees and company's job…
A: Required:
Q: A table called "game1" contains three columns and twenty rows, but "game2" has the same column as…
A: A table is a collection of related data recorded in a table format in a database. In relational and…
Q: q5) Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001…
A: I have answered the question in step 2.
Q: (2) Consider the following Orders table. Write one SQL query that will compute the following from…
A: 2) we can use aggregate functions to write the above query aggregate functions are: sum which gives…
Q: 15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by…
A: Assume that the table name as "Person". SQL code to create the given table is as follows, create…
Q: Using an implicit cursor, write an anonymous block that will display all employees who've been hired…
A: Answer: Since no data or table is provided so I will be unable to provide you the output. Also I…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…You have the following tables: APARTMENTS (ADDRESS, CITY, STATE, RENTER_ID, RENTER_LAST_NAME) RENTERS (RENTER_ID, FIRST_NAME, LAST_NAME) What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more fields) What are the foreign keys, if any? What is the primary key for the RENTERS table? What are the foreign keys, if any? What field in RENTERS can be eliminated so that the RENTERS table is normalized?Update table product to set the value of column productType equal to the corresponding id value in the table productType. This requires a SELECT * FROM productType: to see what the id value is for each type. For example, in my database a. 1|meat b. 2| seafood c. 3| vegetable d. 4 grain and rice e. 5 bakery
- List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a movie (RENTAL table) between '2011-06-01' and '2012-01-01’ (rental_date). Sort by last_name. The common key is CUSTOMER_ID.Some rows of the STUDENT table are shown below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which best describes the result of the query below? SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR a. The average maximum GPA of all the students in each year. b. The year of the student with the maximum GPA. c. The average GPA of students with a GPA higher than 2.0 each year. d. The average GPA of the students with a GPA higher than 2.0.How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and have a total of 3 or more diagnoses? (diagnosis table; COUNT(*), WHERE, GROUP BY, & HAVING clauses) / Result = 20
- DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( ); 0 INSERT ); WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST NAME TEXT, LAST NAME TEXT, SALARY INTEGER (15), JOINING DATE DATETIME, DEPARTMENT CHAR (25) INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (001, 'Monika', (002, 'Niharika', 'Verma' 80000, '14-06-11 09.00.00', 'Admin'), 'HR'), 'Admin'), Admin'), 'Account'), 'Kumar', 75000, '14-01-20 09.00.00', 'Account') DROP TABLE IF EXISTS Bonus; CREATE TABLE Bonus ( ); (003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00', (004, 'Amitabh 'Singh', 500000, '14-02-20 09.00.00', (005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'. (006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00', (007, 'Satish' (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin'); WORKER_REF_ID INTEGER, BONUS AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker (WORKER_ID) ON DELETE…The following table stores details of tutors, students and dates of lectures. The Primary Key is (TutorID, StudentID). TutorID TutorName StudentID StudentName Lecture_date T01 Kong S1052 Salim 10-May-19 T01 Kong S1051 Vikram 5-Jul-19 T02 Smith S1052 Salim 10-May-19 Explain why the above table is not in 2nd Normal Form. Normalize the table to 3rd Normal Form.Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day
- on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and datein pl/sql ,use Cursor to get all the records from table job_history for employee_id 121SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…