Consider the following structure of an 'inventory' Oracle database.cutomerUMERIC ($)VARCHAN 30VARCHAR (18DECIMALSALESMANDCUSTOMER DNUMERIC (6)NAMECUBT NAME WOR(30WCHAR (15)CITYaITYCOMMISSIONGRADENUMERIC (3)SALESMAN D NUMERIC($)ordersORD NONUMERIC (5)PURCH AMTDECIMAL (8,2)ORD DATEDATECUSTOMER ID NUMERIC (5)SALESMAN ID NUMERIC (5)Display all information of those salesmen whose names contain four characters or more, in which the 1st character is always N, while the4th one is always T. The rest of characters can be anything. For example: 'Nail Knite' is a valid name.Use the editor to format your answer

Connider the following structure of an 'inventory' Oracle database. s nan eulomer ... BALEMAND NAME CITY COMMSSION MUMERIC ($) VARCHAR) VARCHAR (1 DECMALD uSTOMER D HUMERC () URCHAR( UNCHAR 1S MUMERIC (3) CUBT NAME cTY GRADE SALESMANDMUMERIC (S) orders ORD NO NUMERIC (5) DECIMAL (82) PURCH AMT ORD DATE DATE CUSTOMER ID NUMERIC (S) SALESMAN D NUMERIC (S) Display all information of those salesmen whose names contain four characters or more, in which the 1 character is always N', while the 4th one is always T The rest of characters can be anything. For example: 'Nail Knite' is a valid name.

Connider the following structure of an 'inventory' Oracle database. s nan eulomer ... BALEMAND NAME CITY COMMSSION MUMERIC ($) VARCHAR) VARCHAR (1 DECMALD uSTOMER D HUMERC () URCHAR( UNCHAR 1S MUMERIC (3) CUBT NAME cTY GRADE SALESMANDMUMERIC (S) orders ORD NO NUMERIC (5) DECIMAL (82) PURCH AMT ORD DATE DATE CUSTOMER ID NUMERIC (S) SALESMAN D NUMERIC (S) Display all information of those salesmen whose names contain four characters or more, in which the 1 character is always N', while the 4th one is always T The rest of characters can be anything. For example: 'Nail Knite' is a valid name.

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

A database that is used to store your family names, emails, photos and their phone numbers is considered as: [Select all correct answers] O None O Multimedia Database O Traditional Database O GIS system Consider the database schema below for hotels countries. A country have many hotels, and the same hotel chain (name) are available in different countries. Country (ID: integer, Name: String (unique) Hotel (CountrylD: Integer, HotelName: String, ManagerID: Integer) The same hotel can have two different managers? O No, violates key constraint. O No, violates referential integrity constraint. O No, violates entity Integrity constraint O No, violates domain constraints. O Yes.
The CVT Company is a leader in the manufacture of work clothes. You are hired as database administrator for the company and your IT supervisor asked you to solve a retrieval speed problem they used to have with a large file for item records. Your supervisor mentioned that they have sorted the file but the problem didn’t improve, so they need to create a B+ tree index to solve the problem. Your supervisor outlined the way to do it: “The best way to accomplish this task is to scan the file, record by record, inserting each one using the B+ tree insertion procedure.” Being a fresh graduate, you noticed that since the file is already sorted there is a better way to do it. What performance and storage utilization problems are there with your supervisor’s approach? Explain how the bulk-loading algorithm provides a better alternative than the proposed scheme.
Suppose in one of the database-application, the data of employees is arranged in the order small to big based on the primary key Employee ID. Now you as developer must develop a search program using the Binary Search method. Develop a Binary Search Algorithm for the above requirements with your knowledge in the data structures and algorithms. Please answer fast i have only 20 minutes( data structures and algorithms).
Lesson 9: Database - Java programming 1. Create a database of salesman: a. Table Description: o Salesman Number – Integer – Primary Key – Not Null o Salesman Name – VarChar Quarterly Sales – Real (Float) * Note: input of sales per quarter (1st, 2nd, 3rd, 4th) o Total Sales - Double o Commission – Real (Float) b. Compute the Total Sales c. Compute the Commission based on the following: Total Sales Commission <= 5000 10% of Total Sales <= 10000 15% of Total Sales <= 15000 20% of Total Sales <= 20000 25% of Total Sales > 20000 35% of Total Sales or 15000 whichever is higher…
JoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover…
Consider a basic database that stores information about students' grades. Create a database and offer a SQL query that returns a list of honour roll students (top 10%), ordered by grade point average.
Styles Consider the following database instance. Table name: Students Primary key: sid Sid udej6 sname Ricky Ellen 2. 6. 4 MaryLou Ellen Table name: Courses Primary key: cid cid C1 cname ICS Finance 2. Table name: Register Primary key: sid.cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 2 2. 1 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, Ellen'); b. INSERT INTO Students VALUES (6, Ellen'); DFocL 727
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)…
10 The resulting list for each object consists of ordered pairs , which define all domains with a nonempty set of access rights for that object. This statement is TRUE with respect to which of the following methods of access matrix implementation. Global Table Access list for objects Capability list for domains lock-key scheme
Chapter 6, Exercise 8 From Murach's mysql 3rd edition I'm running a MySQL Database and trying to run the solution script for this exercise and continually run into this error: Error 1305 Function ap.GROUPING does not exist Here is the code -- taken straight from the solution code for that example: SELECT IF(GROUPING(terms_id) = 1, 'Grand Totals', terms_id) AS terms_id,IF(GROUPING(vendor_id) = 1, 'Terms ID Totals', vendor_id) AS vendor_id,MAX(payment_date) AS max_payment_date,SUM(invoice_total - credit_total - payment_total) AS balance_dueFROM invoicesGROUP BY terms_id, vendor_id WITH rollup;