nt database. The primary keys are highlighted in bold. Student (studNo, studName, address, mobileNo) Registration (studNo, courseNo, regDate, semester, session) Course (courseNo, courseNam
Q: Please explore the database and then write the appropriate SQL command. 1.List all drugs whose…
A: The given is the requirement to be solved in SQL where three tables are already created with some…
Q: Write the sql commands to obtain the following information from the system catalog
A: a) The table SYSTABLES is the table of system catalog that contains information about the tables…
Q: Based on the above tables, write the SQL statements for each of the following operation: 1. Create…
A: According to the asked question, the solution is given below with a proper explanation. Keeping a…
Q: Display names of all those students who have “A”
A: Note: There are multiple questions are given in one question. According to the rule, you will get…
Q: Given the following relational schema (Hint: the bold text represents a primary key), Department…
A: From the above question, we have the condition as ,dept_code and stu_num are primary keys that means…
Q: Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL…
A: {"generalGuidance"::"sections":[{"sectionId":"50c4cd6a-2383-4c53-b65d-4c2b1304a00d","title":"","text…
Q: Write the code steps to perform the following within SQL Create a database pearing the name of the…
A: we can perform this database designing in RDBMS software for example Oracle RDBMS. Below are the…
Q: The relational schema shown below is part of a hospital database. The primary and foreign keys are…
A: Here we will use to_char() function which converts date format into string and then we will apply…
Q: DataBase Use EMP and DEPT tables, in the Live SQL, to perform the following operations. Upload your…
A: Hey there, I am writing the required solution(query) based on the above given question. Please do…
Q: Create a database that contains four tables department, employee, address and contact info, then…
A: SQL (Structured Query Language) is a standardized programming language that's used to manage…
Q: The following figure is part of a university database. LNAME and FNAME stands for last name and…
A: Project operation (denoted by pi (∏) symbol) is used to select desired columns (or attributes) from…
Q: The relational schema shown below is part of a hospital database. The primary and foreign keys are…
A: A database is a collection and assembly of information that is organized in a way that can easily be…
Q: Student(StudentID, age) School(SchoolID, city) Write an SQL statement for the following query: For…
A: The above question is solved in step 2:-
Q: what sql statements could be use to find the following: A simple database composed of the following…
A: 1. SELECT DRUG_CODE , ROUND(DRUG_PRICE, 1) AS PRICE_ROUNDED FROM DRUG; OUTPUT : Selects the column…
Q: Computer Science Table student with the attribute’s student_Id, Fname, Lnameme, Date of Birth,…
A: According to bartleby guidelines we need to answer only first 3 subparts, please repost remaining…
Q: artists: artist_id, first_name, last_name, contact_no, Profession ,birth_date ,address awards:…
A: The SQL query is written based on the given details to get the output as mentioned.
Q: Hi I hope you can help me. I will rate the answer. Use MYSQL do it in a .sql format. Also please…
A: Given :- Hi I hope you can help me. I will rate the answer. Use MYSQL do it in a .sql format. Also…
Q: Find and display sales men that must not be living in the city similar to their customers also got a…
A: According to out guidelines, we are allowed to solve only the first three subparts of the question.…
Q: 1- Give an example of the following below in PL/SQL, and briefly describe the purpose of each. a)…
A: ( A ). Procedure :- A Procedure in PL/SQL is a subprogram unit that comprises of a gathering of…
Q: are underlined. Give an expression in SQL for each of the following queries. Student(studentID,…
A: 1) SELECT full_name, school_name FROM Student NATURAL JOIN School WHERE age>=10 AND age<=15
Q: Consider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName,…
A: note: we are only allowed to solve maximum of three sub-part in one question. Please post other part…
Q: use sql to Display customer Id, customer name and total number of orders for customers
A: As the table name is not mentioned in the question, assume the name of the table is Customer_info.…
Q: Given the structure and contents of the SaleCo database shown in Figure below, use SQL commands to…
A: Request Organized Linguistic: SQL (Resource Description Framework) is a statistical terminology for…
Q: List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List…
A: The given requirement is to be solved in database SQL where the DOCTOR table is already created with…
Q: Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo,…
A: The below sql statements are to calculate the amount to be paid for a student for all courses he/she…
Q: Create in PL/SQL a stored procedure called 'StudentsActivities' to display the list of students and…
A: The PL/SQL stored procedure is a PL/SQL block which performs one or more specific tasks. The…
Q: Please help with the following: Using oracle sql live or sql developer what sql statements could be…
A: 1.List all the rows in which the prescription dates occur on or after November 14. SELECT * FROM…
Q: Write SQL retrieval commands for each of the following queries:a. Display the course ID and course…
A: You didn't provide any tables for query, So I am assume the name of tables and its attributes…
Q: Write queries in SQL to answer each of the following questions:…
A: Below are the required queries: As per our company guidelines we are supposed to answer only first 3…
Q: Given the following table: Student ( id, first_name, last_name, address, program, phone), which of…
A: Here there are multiple questions asked so I have given answer of first 3 question so post remaining…
Q: Create a SQL statement to Display the number of clients for each CType with having less than 2…
A: We will display the count of number of clients where there are less than 2 clients based on ctype.…
Q: Please answer all the question from the SQL: Create table with the name AcademicDetails with…
A: Sql is the structured query languages. It is called as the domain specific languages where we use to…
Q: The relational schema shown below is part of a hospital database. The primary and foreign keys are…
A: Oracle:- Oracle database is developed by Oracle corporations and is used as a system to collect data…
Q: The aim of assignment 1 is to implement a database schema and execute different types of SQL queries…
A: CREATE table Student (studid char(9) primary key, FirstName varchar(50) NOT NULL, LastName…
Q: Answer these question by using these tables. Please. Create in PL/SQL a stored procedure called…
A: I have answered this question in step 2.
Q: Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name,…
A: PL/SQL is a modern, block-structured programming language. It provides several features that make…
Q: SQL QUERIES Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_D…
A: As the database is not mentioned, I am using MYSQL. Create the table employee. Here sys is the…
Q: Create a procedure that takes instructor_ID as a parameter. Name it INSTR_SECTIONS. The procedure…
A: Hey there, I am writing the required solution based on the above given question. Please do find the…
Q: use national join plz Consider the education database with student and scho ,where the primary keys…
A: We have created student and school tables, where the primary keys are underlined. Using below Given…
Q: The InstantRide Finance team wants to collect the price and discount information with the driver…
A: ON is a clause used in SQL to combine the data on two tables on particular condition Here, we are…
Q: The following figure is part of a university database. LNAME and FNAME stands for last name and…
A: Since you have posted a question with multiple sub-parts, according to the company's policy we will…
Q: _ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT,…
A: Employees(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,JOB_ID, SALARY,…
Q: Display details of jobs where the minimum salary is greater than 10000. Display details of employee…
A: Assuming the following two tables in the HR database: JOBS(job_id, job_title, min_salary,…
Q: Please help with the following: Using oracle sql live or sql developer what sql statements could be…
A: The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
Q: use sql to answer the following question To perform below tasks, refer to tables in the JustLee…
A: Question 1. Create a list that display the title of each book and the name and phone number of the…
Q: Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of…
A: According to the question below the solution:
Q: Instructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id)…
A: Given: Instructor(Instructor_Id, Instructor_Name, specialization,…
Q: Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", ,…
A: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger…
Below is part of a Student
Student (studNo, studName, address, mobileNo)
Registration (studNo, courseNo, regDate, semester, session)
Course (courseNo, courseName, creditHour, level)
Project (projNo, projName, courseNo)
QUESTION :
1. Write a PL/SQL PROCEDURE that will list the project names given the course ID.
2. Call the procedure from an anonymous block. Allow the user to enter the course ID (courseno)
Step by step
Solved in 3 steps
- SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet to research these functions. Are the functions available in Oracle, SQLServer, and Access? Write a paragraph that discusses what the functions do and anydifferences and/or similarities between the functions in Oracle, SQL Server, and Access.Then perform the following tasks: a. Solmaris Condominium Group would like to know the impact of discounting its condofees by 3 percent. Write an SQL statement in Oracle that displays the condo ID, unitnumber, discounted condo fee, discounted condo fee with the CEIL function, anddiscounted condo fee with the FLOOR function. b. Based on your research, will the values in the three columns vary? If so, how? Usethe condo with the ID of 1 to explain your answer. Be sure to cite your references.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.student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) Write the following SQL query for the schema above: Print the name(s) and sid(s) of the student(s) enrolled in the most classes.
- One of the junior database developers has encountered some errors in a query they are working on. The junior developer has requested some assistance from you to solve their errors. Consider the following PL/SQL query: turn serveroutput ondeclaring cust customer.first_name%Type;prod product.product%Type;cursor info isselect cust.first_name || ', ' || cust.surname CUSTOMER, p.productfrom customer cust, billing b, product_billing pb, product pwhere cust.customer_id = b.customer_idwhere b.bill_id = pb.bill_idand p.product_id = pb.product_idand p.price > 10000ordering by p.price;beginsfor rec in infoloopingcust:= rec.CUSTOMER;prod:= rec.product; dbms_output.put_line('CUSTOMER: ' || cust || chr(13) || 'PRODUCT: ' || prod);dbms_output.put_line('------------------------------------');end loop;end; Q.2.1 The code above has errors. Identify the errors and rewrite the code so that it would produce a valid output for the junior database developer.student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) Write the following SQL queries for the schema above: Print the course names, course numbers and section numbers of all classes with less than six students enrolled in them. Print the name(s) and sid(s) of the student(s) enrolled in the most classes. Print the names of departments that have one or more majors who are under 18 years old. Print the names and majors of students who are taking one of the College Geometry courses. For those departments that have no majors taking a College Geometry course, print the department name and the number of PhD students in the department. Print the names of students who are taking both a Computer Sciences course and a Mathematics course. For each department that has one or more majors with a GPA under 1.0, print the name of the…Adjust the following information so that1) all users on the system are able to run the SQL Executable and 2) multiple users (such as a team of software engineers) have the power to modify the SQL Executable Introduce any new groups that are needed and assign them group IDs USERS SQL Manager UID: 3 GROUPS SQL Users GID: 5 FILESDatabase File Owner 3 Group NA owner: rw group: - world: - setUID: 0 setGID: 0 sticky: 0 SQL Executable Owner 3 Group 5 owner: rwx group: r-x world: - setUID: 1 setGID: 0 sticky: 0
- draw ERD for these tabels The system must contain tables such as category(catNo,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo),Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity)Given the following relational schema (Hint: the bold text represents a primary key), Department (dept_code, dept_name, emp_num, dept_address, dept_ext)Student(stu_num, stu_fname, stu_lname, stu_dob, stu_class, stu_gpa, emp_num, dept_code) Write the SQL statement to list all department names their highest GPA of the student in the department. The result must have two columns: dept_name and "max GPA" and is ranked from the highest GPA value to the lowest oneThis assignment is aimed at building an understanding of how to improve performance within databases by taking advantage the computers hardware by modifying MS SQL settings Prerequisites: Completion of Assignment 1B, reading of Module Readings and Slides. Run the following query to understand how much Memory is currently in use in the database: SELECT physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB, large_page_allocations_kb/1024 AS sql_large_page_allocations_MB, locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB, virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB, virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB, virtual_address_space_available_kb/1024 AS sql_VAS_available_MB, page_fault_count AS sql_page_fault_count, memory_utilization_percentage AS sql_memory_utilization_percentage, process_physical_memory_low AS sql_process_physical_memory_low, process_virtual_memory_low AS…
- Write SQL or PL/SQL scripts for the following: 1) write an anonymous block program unit that show the vendors ( VENDOR_NAME, VENDOR_ID, VENDOR_STATE) for those vendors who live in a user-input state. (submit the code & screenshot of : input prompt, and result set) Try two test cases: vendor_State : AZ vendor_State : PA1.9) Order of execution is critical since some operations are only meaningful after some order (i.e. having)True False 1.10) As being a sub language of SQL, DML has select, insert, update, and delete operationsTrue False 1.11) SQL does not support creating or deleting database object and granting or revoking access rightsTrue False 1.12) Common Table Expression (CTE) is only used to develop recursive SQL queriesTrue False Create an SQLite Database as follows: A table called “Product” with the fields: _id, Name, StockOnHand, StockInTransit, Price, ReorderQuantity, ReorderAmount. StockOnHand – this represents how many of a Product is currently in the Warehouse/Store. StockInTransit – this represents how many of a Product has been ordered and is on its way, not yet received. Price – this is the cost of a Product. ReorderQuantity – this is the number at which stock levels must reach before a purchase order must be made. If StockOnHand is less than ReorderQuantity + StockInTransit, then a purchase order is necessary. ReorderAmount – this is the amount to be purchased when a reorder is made.