Consider the following structure of an 'inventory' Oracle database.ALEMADMMERIO ($)WCHAR30)VARCHAR (15DECMALOTOMER D MERC(S)MAMECUST J ROWR(CITYCOMMISSIONcTYRCHAR(SORADEMMERIC(3)SALESMAD UMERC($)ordersORD NOPURCH AMTNUMERIC ($)DECIMAL (82)ORD DATEDATECUSTOMER ID NUMERIC (5)SALESMAN ID NUMERIC (5)List all customers who are either from New York or had a grade above 100.Use the editor to format your answer81

SELECT CUST_NAME FROM CUSTOMER WHERE CITY='NEW YORK' OR GRADE>100;

Answered: List all customers who are either from…

Engineering

Computer Science

List all customers who are either from New York or had a grade above 100.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 5TD

See similar textbooks

Similar questions

A new movie theater has opened in your town and the owner needs a system that facilitates theReservation of seats in the cinema’s auditorium. Design a windows application Form thatFacilitates the reservation of tickets for this Movie Theater.Design and connect the following database using LINQ or Entity Framework for the givenscenario.Database:Movie (id (PK), name, description )ScheduleMovie (id (PK), movieID (FK), time, price)Seat (id (PK), number, rownumber, columnnumber)Reservation (id (PK), scheduledMovie(FK), seatnum(FK), customerId(FK), haspaidTicket)Customer (id (PK), email, name)The user of this application is a cinema staff, for example the admin and the Cashier.The Admin Panel The admin registers the cashiers and also, add new movies when released. The panel has various menus named Add, Remove, and detail Add menu has sub menu named AddMovie, and AddCashier. Remove menu has sub menunamed removeMovie and removeCashier. Click event raised on the click of AddMovie which…
Take a look at the database structure for cities in nations below. There are numerous cities in a nation, and the same city name can be found in several countries. Country (integer ID, string (unique) name) (serialNo: integer (not null), CountryID: integer, CityName: string, Population: integer) Is it possible for a city to have an unknown CityName? No, it's against the rules of the domain. Yes. No, infringe.
You are given the following database schema:Sailors(sid, sname, rating, age)Boats(bid, bname, color)Reserves(sid, bid, day)Consider the join on Sailors ▷◁ Reserves and assume that you have the following statistics andlimitations: * You have available 9 pages in main memory.* Sailors: 100000 tuples, 1000 pages; Boats: 2000 tuples, 10 pages; Reserves: 110000 tuples,550 pages 1. Calculate the I/O cost of this join using the Block Nested Loop algorithm?
Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: Find the details of students who borrowed the book titled ‘Database Management Systems’
Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: List the details (bookNumber, bookTitle) of books whose author’s name is ‘Ramakrishnan’
Given the relational database shop defined in the script below; create database shop;use shop; create table users( id int null auto_increment, firstname varchar(255), lastname varchar(255) not null, primary key (id)); create table items( id int null auto_increment, name varchar(255), price float, primary key (id)); create table orders( id int null auto_increment, id_users int not null, id_items int not null, primary key (id), foreign key (id_users) references users(id), foreign key (id_items) references items(id)); write three SQL queries to answer the following questions 1.- All products(items) in the shop catalog; product code, name and price 2.- Products sold in the shop; product code, name and price and full name of buyer. 3.- Products in stock (not sold); product code, name and price
Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows: One Match belongs to One Tourney, and not none. One Tourney has Many Matches, at least one and a maximum of 128. One Match takes place on One Table, and not none. One Table is used in Many Matches, and possibly none. One Match belongs to one Category, and not none. One Category appears in Many Matches, and possibly none and a max of 32. One Match involves Many Players, minimum 2 and maximum 4. One Player plays Many Matches, and possibly none. You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below. Match Number Tourney Tourney Start Date Day Time Slot In Day Player Names(Team 1) Player Names(Team 2) Player IDs (Team 1) Player IDs(Team 2)…
The following is a relational schema for a database to document sharksightings for a research project. Primary keys are underlined. ForeignKeys are identified by FK, and their name indicates the attribute that theyreference.________________________________________________________________Sharks(shark_id:Integer, name:String, species_name:String,tagged_by_mission_id:Integer (FK))Sightings(shark_id:Integer (FK), sighting_num:Integer,sight_time:Timestamp, lat:Real, lng:Real, ocean:String, mission_id:Integer(FK))Missions(mission_id:Integer, start_date:Date, end_date:Date,vessel_id:Integer (FK))ResearchVessels(vessel_id:Integer, name:String)________________________________________________________________Sharks identified by a unique id, have a name which is not necessarilyunique, and a scientific species name.All Sharks are tagged and are sighted by Research Vessels, which areresearch ships that go on research Missions throughout the year. EachMission has a start and end date. Shark…
What are the four basic types of operations for a database application? a. Insert, Select, Update, and Delete b. Insert, Update, Delete, and Create c. Insert, Update, Delete, and Render d. Insert, Select, Update, and Render If stringa="Good Morning", what is the value of stringa[1:5]? a. "Good " b. "ood " c. "Good" d. "ood M" The instance that “a survey respondent in service occupation (x) is less likely to report income ” is an example of __________ . a. Missing completely at random. b. Missing at random. c. Missing not at random. d. None of the above.
A University database is described by the following relational schema. Student (StudentId, Name, MatrNr, Faculty)Lecturer (LecturerID, Name, Institute, Salary) Faculty (FacultyID, PAYENo, Name, PersonType, Department, Faculty, Institute, TeachingStatus, Salary, CarLotNo, ComputerNo) Write one SQL script to populate the faculty database with the three lecturers below given the following critical information for each lecturer. 1- John Doe is new and so does not have a computer.2- Jack Sprat does not drive a car.3- Win Ling is a visiting professor
We have the following functional dependency A -> B. The following is a well-formed database design. MYTABLE (TheKey, A, B, C) True False
You are given the following database schema:Sailors(sid, sname, rating, age)Boats(bid, bname, color)Reserves(sid, bid, day)Consider the join on Sailors ▷◁ Reserves and assume that you have the following statistics andlimitations: * You have available 9 pages in main memory.* Sailors: 100000 tuples, 1000 pages; Boats: 2000 tuples, 10 pages; Reserves: 110000 tuples,550 pages 1. Calculate the I/O cost of this join using the Block Nested Loop algorithm? 2. Calculate the I/O cost of sorting the Sailors relation?

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:

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:

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