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

q8- Choose ALL that apply.
92. In relational database schemas, the transition constraints are also known as a. static constraints b. dynamic constraints c. implicit constraints d. explicit constraints
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.
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…
So i have an ER digram( picture below) that needs to Schema Implementation and SQL DDL statements to create database, primary key and foreign keys must be defined
A database has been designed to display a list of popular movies and also a list of actors acting in these movies. The relationship that would exist between the related tables would be: O many to many one to many O many to one O one to one
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
Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…
ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents can choose either one of the programming languages C++, C#, Java, and Python as their main development platform. They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in…