Q2) consider you have the teams database with the following relations, where the primay keys are underlined: Player(name, age, length, weight, nationality, team-name, position) Team(team-name, sport-type, no-of-players, country, team-city) Sport(sport-type, no-of-trams, country) Answer the following SQL commands: 1- Add three years more to the age of Italian players 2- Remove the players that have weights more than 90 KG or their age between 40 and 50. 3- Add new sport called vollyball which includes 12 spanish teams.

Q2) consider you have the teams database with the following relations, where the primay keys are underlined: Player(name, age, length, weight, nationality, team-name, position) Team(team-name, sport-type, no-of-players, country, team-city) Sport(sport-type, no-of-trams, country) Answer the following SQL commands: 1- Add three years more to the age of Italian players 2- Remove the players that have weights more than 90 KG or their age between 40 and 50. 3- Add new sport called vollyball which includes 12 spanish teams.

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

Assignment III (5%): Design of the conceptual model (ERD) from the given relational database. (Note: students has to give appropriate labels on relationships and type of relationships between the entities) Use the same Assignment- I schema to perform the PL/SQL programs Q1. The management of the organization has decided to increase the salaries of all employees to 15% for this, write a PL/SQL block to accept the employee number and to update the salary of that employee. Display the output based on the existing records of the employees. (2 marks) Q2. having the employee age above 40 years. (2 marks) Create a PL/SQL a cursor program that will increase the employee salary to 25% who are Q3. where place belongs to Ibri, dunk or Yanul (hint: Project (projectID. projectName, place, start Year, end Year, #DepartmentID) (2 marks) Write a PL/SQL procedure to change the name of the project to "AL Dahariyah Projects"
Q2) consider you have the teams database with the following relations, where the primay keys are underlined: Player(name, age, length, weight, nationality, team-name, position) Team(team-name, sport-type, no-of-players, country, team-city) Sport(sport-type, no-of-trams, country) Answer the following SQL commands: 1- Add three years more to the age of Italian players 2- Remove the players that have weights more than 90 KG or their age between 40 and 50. 3- Add ne sport called vollyball which includes 12 spanish teams. 4- Decrease the number of players of the teams in new york by 12%. 5- Add new attribute to the sport table called category.
All parts of this question use the following database schema: Flights(flno, from, to, distance) Aircraft(aid, aname, cruisingrange) Certified(eid, aid) Employees(eid, ename, salary) c) For each cruisingrange held by at least 3 aircraft, give the lowest salary of employees certified to fly one of those aircraft. Express in SQL only:
Write a Structured Query Language (SQL) statement for each of the following questions:a) Create the AppointmentDetails table with the following requirements:  Appropriate data types. All keys can store between 6 to 10 characters. All the columns must have values (cannot be empty). Add on charges is set to 0.00 by default. Enforce entity and referential integrities. b) Diplay the therapists’ particulars (include TheraName, TheraContact) as first two columns, then calculate the Total_Count_Of_Appointment for each therapist within the year 2020 as third columns. Lastly, arrange the outcome to show the list by the higher popularity of therapists first.
Q2) consider you have the teams database with the following relations, where the primay keys are underlined: Player(name, age, length, weight, nationality, team-name, position) Team(team-name, sport-type, no-of-players, country, team-city) Sport(sport-type, no-of-trams, country) Answer the following SQL commands: 4- Decrease the number of players of the teams in new york by 12%. 5- Add new attribute to the sport table called category.
Quèstion 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: i. Read a movie id provided by user at run time and store it in a variable. ii. Fetch the Genre and title of the movie having the entered id and store them inside two variables ii. Display the fetched movie Genre and title. T TTArial 3 (12pt)
Write SQL queries DDL Queries to implement the following Relational Model i.e. create the Nurse and Care_Center relations (including primary key and foreign key). Intelligently write data types.
a) from university database , Write the following queries in SQL Find the titles of courses in the Comp. Sci. department that have 3 credits Find all instructors earning the highest salary (there may be more than one with the same salary) Find all courses that have never been offered (i.e., do not occur in the section relation). b) given the following tables( instructor, teaches) what is the output of the following query select i.name from instructor as i, teaches as t where i.ID=t.ID and semester=’ Fall’ and year=2017;
Consider the following database tables: Employee (empNo, empName, street, city) Works (empNo. companyName, joiningDate, salary, deptNo) Employee salary (empNo, basic, total deduction, net salary, gross salary) Write a PL/SQL code to display employee number, name and basic salary of the 5 highest paid employees.
Question 13 Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables iii. Display the fetched book author and title.
Please help with the following: Write following SQL Queries:A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION, List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. How many drugs with price < 40$? How many prescriptions are generated for each patient, limit the listing to patients who have more than 2 prescriptions? List the drug codes and prices (rounded to one decimal place). How many doctors prescribe the drug code KO15? List all drugs with their expiration date (one year from the date of manufacturer)…
Q2) Consider you have the airport database with the following relations, where the primary keys are underlined: Airplane(plane-code, model, manufacturer, airlines, capacity) Flight(flight-No., plane-code, flight-date, flight-duration, distination-city, airport) Answer the following SQL commands: 1- Increase the capacity of airplanes that manufactured by Boeing by 4. 2- Delete the flights of Heathrow airport to Moscow. 3- Add new two records to airport table. 4- Remove the airplanes that has code between 456 and 987 and has capacity more than 150. 5- Remove the attribute model from the airplane table.