Database project 1- Create the following table in PL/SQL language and show the table; | ID | NAME | AGE | ADDRESS | SALARY | 1| Ramesh | 2 | Khilan | 32 | Ahmedabad | 2000.00 | | 1500.00 | 2000.00 | 6500.00 || 8500.00 | 4500.00 | | 25 | Delhi 3 | kaushik | 23 | Kota | 4 | Chaitali| 25 | Mumbai 5 | Hardik 6 | Komal | 27 | Bhopal | | | 22 | MP | 2- Make an exception to print the message "Age is not allowed " when inserting a new record and the entered age is less than 21 years old 3- Create a function that prints a message to the user "Do you want to add a new record?" is permitted for the user, just enter 'y' to denote yes or 'n' to denote no. 4- If the user chose Yes in the previous question, write a code that allows inputs from the user and save them in the previous table 5- Update the salary of the employee "Komal" in the table to become 5000, and show the table

Database project 1- Create the following table in PL/SQL language and show the table; | ID | NAME | AGE | ADDRESS | SALARY | 1| Ramesh | 2 | Khilan | 32 | Ahmedabad | 2000.00 | | 1500.00 | 2000.00 | 6500.00 || 8500.00 | 4500.00 | | 25 | Delhi 3 | kaushik | 23 | Kota | 4 | Chaitali| 25 | Mumbai 5 | Hardik 6 | Komal | 27 | Bhopal | | | 22 | MP | 2- Make an exception to print the message "Age is not allowed " when inserting a new record and the entered age is less than 21 years old 3- Create a function that prints a message to the user "Do you want to add a new record?" is permitted for the user, just enter 'y' to denote yes or 'n' to denote no. 4- If the user chose Yes in the previous question, write a code that allows inputs from the user and save them in the previous table 5- Update the salary of the employee "Komal" in the table to become 5000, and show the table

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter8: Sql Functions And Procedures

Section: Chapter Questions

Problem 9SCG: SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet...

See similar textbooks

Similar questions

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.
Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
Write SQL Query code .Database with MS SQL Server Airline Reservation System .Your database should include at least (but not limited to); 10 Tables, 5 Views, 15 Stored Procedures, 3 Triggers, 1 Function, 1 Login, and 5 Schema objects and create ENTITY RELATIONAL MODEL.
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.
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.
Which one is not correct about index in mysql? Indexes slow down inserts and updates but speed up WHERE clauses and ORDER BY. Failure to properly index data is the leading cause of SQL performance problems Indexes help a database retrieve data efficiently indexing can be neglected if the size of the database is too large
Show T-SQL coding, object explorer and query result, running on SQL Server Management Studio. 1.1 Create a Database named RDD412_SA_YourICASNo. (1) 1.2 Create Six Tables in the database created in question 1.1. As illustrated in the ERD Diagram below. (12) 1.3 The Tables should have the relevant Primary Keys and Foreign Keys. (10) 1.4 Each table should have 5 rows of dummy data per table. (12)
At the next level of detail, a SQL Server schema contains
realtional database SQL question 10) What type of connection is used in the following query select category_name, first_name from Child, Size_ group where Child. height between Size_group .smallest and .Size_group.tallest; a) vertical join b) outer join c) non-equi join d) left join
Question 11 mah.SQl format Each supplier has a unique name. More than one supplier can be located in the same city. Each part has a unique part number. Each part has a colour. A supplier can supply more than one part. A part can be supplied by only one supplier. A supplier can supply a fixed quantity of each part. Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Database Design – 2022WStudent ID :Student Name :Practical Activity 9 – SQL JOIN OperationsPerform the following operations using ORACLE and provide relevant screen shots in each caseUse appropriate syntax and datatypes1. Create the following table(s) and enter given data values for each table using a SQL Scriptsa. Customers_697(697 is last 3 digits of your student Number)** Customer ID 5 Enter your First Name and Last_Nameb. Orders_697Hint : TO_DATE('2020-11-21', 'YYYY/MM/DD') can be used to convert / insert date typeNote : OrderDate is a Date Typec. Refunds_697Now Perform the following JOIN Operations3. Find the details of the Customers orders and refunds irrespective of whether they placeorders or having refundsExplain the outputWhy we see NULL values in certain columns
Assuming a library database schema with the following tables and attributes: Book (BookID, Title, AuthorID, PublisherID, Rating, Price) Author (AuthorID, FirstName, LastName) Publisher (PublisherID, Name) Borrower (BorrowerID, FirstName, LastName) Write a SQL query to retrieve the names of all authors who have written a book published by "Penguin Books". Write a SQL query to retrieve the total number of books borrowed by each borrower. Write a SQL query to retrieve the names of all publishers who have published at least one book with a rating of 4 stars or higher. Write a SQL query to calculate the average price of books. Write a SOL query to find the maximum price of books. PLEASE ANSWER CORRECTLY OR I WILL PUT ?

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS