With reference to following relations personal …

With reference to following relations personal and job answer the questions that follow: Create following tables such that Empno and Sno are not null and unique, date of birth is after ’12-Jan-1960’ , name is never blank, Area and Native place is valid, hobby,dept is not empty, salary is between 4000 and 10000. 1. Show empno, name and salary of those who have Sports as hobby. 2. Show name of the eldest employee. 3. Show number of employee area wise. 4. Show youngest employees from each Native place. 5. Show Sno, name, hobby and salary in descending order of salary. 6. Show the hobbies of those whose name pronounces as ‘Abhay’. 7. Show the appointment date and native place of those whose name starts with ‘A’ or ends in ‘d’. 8. Show the salary expense with suitable column heading of those who shall retire after 20-jan-2006. 9. Show additional burden on the company in case salary of employees having hobby as sports, is increased by 10%. 10. Show the hobby of which there are 2 or more employees. 11. Show how many employee shall retire today if maximum length of service is 20 years. 12. Show those employee name and date of birth who have served more than 17 years as on date. 13. Show names of those who earn more than all of the employees of Sales dept. 14. Show names of those who earn more than at least one of the employees of Marketing dept. 15. Increase salary of the employees by 5 % of their present salary with hobby as Music or they have completed atleast 3 years of service.

Which book do you all follow for cs? How many chapters are there in the syllabus

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

Write a python program to count threwords in a given file

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

What is mean by buffering in file handling?

Differentiate between function and argument

What are called tokens

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

Write a python program to count three letter words in a given file