Consider the business trip database that keeps track of the business trips of salesman in an office. Following are the tables: SALESMAN (SNO INTEGER, S_NAME CHAR (30), START YEAR YEAR) TRIP (TNO INTEGER, FROM_CITY CHAR (20), TO_CITY CHAR (20), DEPARTURE_DATE DATE, RETURN DATE) DEPT (DEPTNO VARCHAR (10), DEPT_NAME CHAR(20)) EXPENSE (EID INTEGER, AMOUNT MONEY) The relationship is as follows DEPT-SALESMAN I TO M SALESMAN TRIP 1 TO M TRIP EXPENSE 1 TO 1 a) Write a function to display names of salesman from 'Home appliances' department.

Consider the business trip database that keeps track of the business trips of salesman in an office. Following are the tables: SALESMAN (SNO INTEGER, S_NAME CHAR (30), START YEAR YEAR) TRIP (TNO INTEGER, FROM_CITY CHAR (20), TO_CITY CHAR (20), DEPARTURE_DATE DATE, RETURN DATE) DEPT (DEPTNO VARCHAR (10), DEPT_NAME CHAR(20)) EXPENSE (EID INTEGER, AMOUNT MONEY) The relationship is as follows DEPT-SALESMAN I TO M SALESMAN TRIP 1 TO M TRIP EXPENSE 1 TO 1 a) Write a function to display names of salesman from 'Home appliances' department.

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

When calling a sub procedure, parentheses are optional if there are no arguments. Select one: True False
Instruction: Identify if the following is UNIQUE IDENTIFIER or NOT. Plan ID Workout ID
Oracle Language Display employee first name and the position of the second ‘a’ character in the firstname if exist, otherwise display a message: Not contains two aNote: the comparing is not case sensitive
Instruction: Identify if the following is UNIQUE IDENTIFIER or NOT. User ID Complete Name Contact
Data _____&&_.refers to the format in which data is stored, processed, and transferred.
C# and viapplication the user will be able to choose whether to buy a car or not. if user chooses to buy a car the user should selects model and make, purchase price, total deposit, interest rate and estimated insurance premium. the software will calculate total monthly cost of buying the car assume that all the cars will be repaid over 5 years. the software shall notify the user when the total expenses exceed 75% of their income and the expenses will be displayed in descending order by values you must use a genetic collection to store the expenses you are required to use classes and inheritance you must use a delegate to notify the user when expenses exceed 75% of their income
"Programming style"—what comes to mind? Please comment. Is there a standard programming style?
When expressed in proper scientific notation the number 0.00364 is ___. Please use ^ to indicate a power of 10, if necessary.
please help
What makes a question distinct from a statement is the wording used in the question.
What makes a question distinct from a statement is the wording used in the question.
ASSEMBLY You can reuse the same local variable name within different procedures in your program. True False