Consider the Schema of the university database. Select SQL query to display a list of all students, displaying their ID, and name, dept_name, and tot_cred, along with the courses that they have taken. classroom(building, room_number, capacity) department(dept_name, building, budget) course(course_id, title, dept_name, credits) instructor(ID, name, dept_name, salary) section(course_id, sec_id, semester, year, building, room_number, time_slot_id) teaches(ID, course_id, sec_id, semester, year) student(ID, name, dept_name, tot_cred) takes(ID, course_id, sec_id, semester, year, grade) advisor(s_ID, i_ID) time_slot(time_slot_id, day, start_time, end_time) prereq(course_id, prereq_id) select from student natural join takes; select ID, name, dept_name, tot_cred from student; select from student natural left outer join takes; select from student and takes;

Consider the Schema of the university database. Select SQL query to display a list of all students, displaying their ID, and name, dept_name, and tot_cred, along with the courses that they have taken. classroom(building, room_number, capacity) department(dept_name, building, budget) course(course_id, title, dept_name, credits) instructor(ID, name, dept_name, salary) section(course_id, sec_id, semester, year, building, room_number, time_slot_id) teaches(ID, course_id, sec_id, semester, year) student(ID, name, dept_name, tot_cred) takes(ID, course_id, sec_id, semester, year, grade) advisor(s_ID, i_ID) time_slot(time_slot_id, day, start_time, end_time) prereq(course_id, prereq_id) select from student natural join takes; select ID, name, dept_name, tot_cred from student; select from student natural left outer join takes; select from student and takes;

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

Consider a database table named "EMPLOYEES" with the following columns: E_EMPLOYEEID, E_FIRSTNAME , E_LASTNAME , E_DEPARTMENT and E_SALARY .Write SQL query to retrieve the first name, last names and salary of employees whose salaries are below $3000 and are part of the "House Keeping" department. Sort the results by the salary in descending order.
This question is related to the Database:- Suppose you are creating a database for a library management system. Explain how you would make a table for the "books" entity and insert some sample data, and then alter the table to add a new column for the "authorID" attribute and update "authorID" with some data. Finally, make a SQL query to retrieve all the books that were published after the year 2000. Note that this book schema has several columns, including "book_id" as the primary key, "title", "authorN", "publisher", "publication_year", "isbn", "language", and "num_pages". It also includes "available" column that is set to "true" by default and can be used to track the availability of the book. Please don't use handwriting...
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 ?
Write SQL queries for the designed database which will return: - All people on the same flight - All planes on the same destination - If the sum of all cargo weight on the plane is under a threshold.
We have a relational database that contains the table ‘Staff’. The table ‘Staff’ consist of columns ‘Name’, ‘Department’ and ‘Date of Joining’. What query would you use to extract the Names and Department of all staff in the table? a. SELECT * FROM Staff b. a) SELECT Name, Department FROM Staff c. SELECT Name, Department IN Staff d. SELECT * IN Staff
QUESTION 2 Consider the database schema below for hotels in countries. A country have many hotels, and the same hotel chain (name) are available in different countries. Country (ID: integer, Name: String (unique)) Hotel (CountryID: Integer, HotelName: String, ManagerID: Integer) How many candidate Key(s) in the hotel relation?
Consider the following schema:instructor(ID, name, dept_name, salary)department(dept_name, building, college, budget)What is the correct SQL statement to perform a query to find the names and average salaries of departments in the college of ‘Science’ whose average salary is greater than 75000? (a) select dept_name, avg (salary)from instructor natual join departmenthaving college = ‘Science’group by dept_namewhere avg (salary) > 75000;(b) select dept_name, avg (salary)from instructor natual join departmentwhere college = ‘Science’group by dept_namewhere avg (salary) > 75000;(c) select dept_name, avg (salary)from instructor natual join departmentwhere college = ‘Science’group by dept_namehaving avg (salary) > 75000;(d) select dept_name, avg (salary)from instructor natual join departmenthaving college = ‘Science’group by dept_namehaving avg (salary) > 75000;(e) select dept_name, avg (salary)from instructor natual join departmentwhere college = ‘Science’and avg (salary) >…
Consider the following schema:instructor(ID, name, dept_name, salary)What is the correct SQL statement to perform a query to find the names of all instructors excluding duplicates?(a) select name from instructor;(b) select unique name from instructor;(c) select name from instructor no duplicates;(d) select distinct name from instructor;
Just return SQL code/query with proper functions for each of the following. No output needed. Database Schema: Beers(name, manf)Bars(name,addr,license)Drinkers(name,addr,phone)Likes(drinker, beer)Sells(bar,beer,price)Frequents(drinker, bar) 1. Find all distinct drinkers whose phone numbers come from area code 917 and who like Budweiser or Bud (synonim!) 2. What beers does Mike like? 3. Which town has the most drinkers? 4. What bars are frequented by drinkers from that town (3)? 5. Provide all bars which serve beers that Mike likes 6. Who likes at least one same beer that Joe or Mike like? 7. All bars which sell at least one beer which is liked by at least one drinker who frequents these bars 8. Drinkers who like some beers sold by Caravan bar 9. Bars which sell Budweiser and are frequented by some drinkers who like Budweiser 10. Bars which are frequented by Mike and Steve 11. Drinker who like at least two beers that Mike likes 12. Bars which sell at least 3 beers that Mike likes (do…
The physical database can be created using DDL (Data Definition Language) and manipulated using DML (Data Manipulation Language), which enable users to access or manipulate data as organized by the appropriate model.i) Using the CREATE TABLE in any dialect of SQL, show the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints etc. ii) Insert (at least) 10 sample rows for each identified table. Student must test their database using at least the following:- Restriction and Projection - Aliases - NULL value handling - Concatenation - Comparison Operator - Logical Operator - Sorting - Function ()Group function & Single Row Function - Joins - Subqueries
QUESTION 2 Consider the database schema below: Company (CompnayID: integer, CompnayName: String (unique), address) Department (DepartmentID: Integer, DepartmentName: String, CompanyID: Integer) Employee (ID:integer; name:String, DepartmentID:intger (not null)) How many candidate key(s) in the Employee relation?
Consider a database with the following schema: Person ( name, age, gender ) name is a keyFrequents ( name, pizzeria ) (name, pizzeria) is a keyEats ( name, pizza ) (name, pizza) is a keyServes ( pizzeria, pizza, price ) (pizzeria, pizza) is a key Write relational algebra/SQL expressions for the following:a. Find the names of all females who eat both mushroom and pepperoni pizza.b. For each person, find all pizzas the person eats that are not served by any pizzeria the personfrequents. Return all such person (name) / pizza pairs.c. Find all pizzerias that are frequented by only females or only males.