Write a to display user name and password. Password should be generated by concatenating first three characters of user name and first three numbers in phone number and give an alias name as PASSWORD. Sort the result based on user name. SQL Code Required BUSES P BUS _NO number(11) SCHEDULE BUS NAME varchar2(20) t SCHEDULE_ID varchar2(3) TRAVEL DATE SOURCE DESTINATION varchar2(20) t P BUS_NO DURATION varchar2(20) t date d varchar2(20) t TYPE TOTAL SEATS number(11) # AVAIL SEATS number(11) number(11) NO number(11) PAYMENTS DISCOUNTS TICKET ID P PAYMENT_ID varchar2(3)t DISCOUNT_ID varchar2(3) TICKET ID dO O BD ID varchar2(3) number(11) DISCOUNT_ID BO 10O O DISCOUNT AMOUNT number(11) TICKETS O DISCOUNT_ID varchar2(3) TICKET ID varchar2(3) O SCHEDULE ID OSCHEDULE ID varchar2(3) number(11) # number(11) O number(11) # FARE PUSER ID NO SEATS USER ID USERS PUSER ID number(11) P primary key - not null NAME varchar2(20) t O foreign key | data type - number ADDRESS varchar2(100)t PHNO number(11) # EMAILID varchar2(30)t d data type - date It| data type - varchar2 CANCELLATION TICKET ID oO TICKET ID PCANCELLATION_ID varchar2(3) t varchar2(3) o BOOKINGDETAILS BD ID BD ID number(11) ACC_NO number(11) NAME varchar2(10) t PUSER_ID number(11) O BD_ID number(11) USER ID

Q: Write a to display user name and password. Password should be generated by concatenating first three…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: ber(11) ID P DISCOUNT JO na veDISCOUNT_ID Write a to display user name and password. Password should…

A: The Answer is in below Steps

Q: har2(3)DISCOUNT_ID Write a to display user name and password. Password should be generated by…

A: Here I have used the table USERS. Now we need to select the name and password from the table USERS.…

Q: Draw the ERD, _that is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER…

A: ER diagram: The ER diagram for the given SQL code:

Q: Write SQL code that will retrieve patients whose appointment months are the same as with a patient…

A: Let the Table name be Hospital, to get the data from the table here we use LIKE and Not like…

Q: (3) BD ID Write a to display user name and password. Password should be generated by concatenating…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: Draw the ERD _that is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER…

A: ER diagram: The ER diagram for the given SQL code:

Q: First of all whole question is given I just need out of given queries ASAP!!       Write the SQL…

A: create table User (User_id integer PRIMARY KEY, Name varchar(100), City varchar(100), Order_date…

Q: In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and…

A: COMMANDS USED: Select command is used for the purpose of selecting the data from the database. The…

Q: O DISCOUNT_ID v lal DISCOUNT_ID Write a to display user name and password. Password should be…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: O DISCOUNT_ID var COUNT ID Write a to display user name and password. Password should be generated…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: a BD ID Write a to display user name and password. Password should be generated by concatenating…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: Write SQL queries for the following statements. 1) Write a stored procedure which takes an integer…

A: Create proc using create command  Create a variable as input parameter Declare incrementation…

Q: ) Write a SAS SQL statement to retrieve all columns from PG1.STORM_FINAL. (b) Modify the query to…

A: SAS SQL statements are given below :

Q: p SCHEDULE_ID e HEDULE ID Write a to display user name and password. Password should be generated by…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: Run these program in sql and description errors and print number of errors and correct to error…

A: Given that Run these program in sql and description errors and print number of errors and correct to…

Q: Orders Columns: order_id (int), order_no (char(30)), customer_name (char(100)) Order_Line Columns:…

A: Given that two tables data . Orders tabel contains : order_id(int), order_no(char(30)),…

Q: plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS ( donor_id INT…

A: Need to fix the given query :CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT…

Q: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family…

A: Since I don't have access to the database, I am writing the general syntax of deleting the rows from…

Q: Using an implicit cursor, write an anonymous block that will display all employees who've been hired…

A: Oracle is an RDBMS where as SQL is the language used to access mordern databases. Oracle was the…

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…

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: O DISCOUNT_ID Varo SCOUNT ID Write a to display user name and password. Password should be generated…

A: As per the given problem statement we have to develop SQL query to display user name and password.…

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: According to the above listed question we have to develop a SQL query to display all the resorts…

Q: There's a "friend_requests" table that has a column "action_taken" that displays if the friend…

A: Given Data :  Table name : friend_requests Table attributes : action_id requester_id requestee_id…

Q: Write a to display user name and password. Password should be generated by concatenating first three…

A: Get the substring from user name and phone number Then concatenate them to form a password and…

Q: Task3: Write SQL Queries • At least 2 queries involving GROUP BY, HAVING, and aggregate operators. •…

A: To write SQL queries.

Q: Write the SQL statements for the following User table. User_id Name City Order_date Purchase_amount…

A: To create a table in SQL, create table command is used. Ans 1. The required query is: CREATE TABLE…

Q: Given the following relation: Student (StudentID, studentName, StudentAddress, MobileNumber) Write a…

A: The %ROWTYPE attribute provides a record type,which can hold a list of the table(or view) of same…

Q: There's a "friend_requests" table that has a column "action_taken" that displays if the friend…

A: SELECT Count(action_id) FROM friend_requests where action_taken = "Accepted"; This query will return…

Q: b) Write code segment with SQL statements that will: -Insert these details into the table at the…

A: Assume you have successfully connected your application, developed in Visual Net using ADO to MySQL…

Q: Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define…

A: Below is the PLSQL block code:

Q: Appointments AppointmentID 1 P1 2 P2 PatientID AppointmentTime AppointmentDate TreatmentID DentistID…

A: As per out guidelines, we are supposed to answer only 1st 3 questions. Kindly repost the remaining…

Q: Your implementation must directly follow a comment with a specification of a subtask. (1) First,…

A: According to the company policy, we can answer up to 3 subparts only, Answers to these 3 subparts…

Q: 5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit…

A: Required:

Q: Write the SQL statements for the following User table. User_id   Name City   Order_date…

A: --query to create user tablecreate table user(User_id int primary key,Name varchar(50),City…

Q: grade varchar(30), salesman_id int, CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES…

A: The question is to write correct query with respect to the error.

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: According to the above listed question we have to develop a SQL query to display all the resorts…

Q: Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add…

A: SQL: SQL or Structured Query Language that is used to store, manipulate and store data in database.…

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: According to the above listed question we have to develop a SQL query to display all the resorts…

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: Given: Display all the resorts name whose star rating ranges between 4 and 5. Sort the results set…

Q: write necessary PHP code that reads data from the form and inserts into the Books table. Make use of…

A: PROGRAM CODE: <?php //change the username,password and db as per your mysql configuration…

Q: Minimum Travel Time Develop a simplified SQL query Display schedule_id, source, destination and…

A: Required:    Write  SQL query to display schedule_id, source, destination, and travel_time which has…

Q: Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an SQL…

A: Given:  Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an…

Q: Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an SQL…

A: select* from Worker where DEPARTMENT = 'Admin';

Q: Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an SQL…

A: SELECT  * FROM TABLE_NAME WHERE DEPARTMENT = 'Admin'; Dear Student, As you have not provided the…

Q: Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an SQL…

A: select* from Worker where DEPARTMENT = 'Admin';

Q: Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”. ii. Write an SQL…

A: like operator: The LIKE operator is used in a WHERE clause to search for a specified pattern in a…

Q: write Sql statements to write query for the given table .. the query statements are. Display first…

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

Q: use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings…

A: DECLAREStudent1 varchar2(32767);Student2 varchar2(32767);S1Marks number;S2Marks number;c…