Admission to a professional course is subject to the following conditions : (a) Marks in mathematics>=60 (b) Marks in physics> =50 (c) Marks in chemistry> =40 (d) Total in all subjects> =200(OR) Total in mathematics and physics> =150 given the marks in the 3 subjects. write the programme to process the application to list the eligible candidates.

Admission to a professional course is subject to the following conditions : (a) Marks in mathematics>=60 (b) Marks in physics> =50 (c) Marks in chemistry> =40 (d) Total in all subjects> =200(OR) Total in mathematics and physics> =150 given the marks in the 3 subjects. write the programme to process the application to list the eligible candidates.

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

What does the group by clause accomplish?
DEPTNO | START DATE EMP NO | EMP NAME | EMP COMM DEPTNΟ DEPT ΝΑΜΕ MIN SAL | ΜAX SAL DEΡΤΝΟ EMP EMP SAL DEPT a) Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order according to salary and commissions. b) For each employee, display the employee's last name, and calculate the number of months between today and the date the employee was hired. Label the column MONTHS_WORKED. Order your results by the number of months employed. Round the number of months up to the closest whole number. c) Display the employee name and department name for all employees who have an a (lowercase) in their last names.
What’s the purpose of the WITH CHECK OPTION constraint?
False part shoul display "Invalid mark". If some other number is entered apart from 0 to 100. What is the spreadsheet formula?
( Please answer this question immediately I do not have time ) Use the following table to answer the questions below: Table name: Books Column Name Role Data Type Length Constraint bookID Stores the ID of a book Number 5 Primary key bookTitle Stores the title of a book Varchar2 50 - bookISBN Stores the ISBN of a book Number 13 Cannot be null and duplicated publicationDate Store the publication date of a book Date - Cannot be null bookPrice Stores the price of a book Number 2,2 Cannot be null a. Write in SQL a command that creates the table Books according to the above description b. Write in SQL a statement that adds a new column named publisherID of type Char(10). This column should be defined as a foreign key that relates the table Books to the table Publisher c. Write in SQL a command that deletes the books that are published before 20-Aug-2010 d. Write a SQL query that displays the number of books that are published in the year 2018 e. Write in SQL a…
2: Write a stored Procedure Which shows the Product having maximum Price.
Explain the two eay selection form.
A real Estate Company has in its poššession a long list of landlords and the rent cost of their two bedroom apartments, as shown on table 1. There is the need for an Application program that will allow a user at the company to load the said list into a computer program, i.e. the list of landlords and the cost of rent. The app must also allow users to search for apartments they can afford. Apart from the list in the table, the App should be able to take as input the maximum amount a tenant is willing to spend on a two-bedroom apartment and then display a list of landlords whose apartments can be rented with that amount. Table 1: Landlords and Cost of rent Landlord Ama Dua Ali Dulon John Togbe Abena Nyame Kofi Duku Cost of rent (GHC) 800.00 950.00 2,500.00 600.00 2,300.00
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
Description The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +--- | Id | Name | Salary | ManagerId | +---- | 1 | 2 | 3 | 4 +---- | Joe | 70000 | 3 | Henry | 80000 | 4 | Sam | Max Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager. + | Employee | + | Joe + | 60000 | NULL | 90000 | NULL I
17- Multi-Row subquery uses which operators? a. ANY, ALL, IN b. <, >, <=, >= c. AND, IN, OR d. SUM, MIN, MAX, AVG
If the select statement's optional clauses are used, they must be used in a particular order. In the order in which they appear, discuss the intent of the optional clauses.