User:Saurav1612/sandbox

PS: Develop an user interface for Winner higher Secondary School, to calculate the grades for students of the school. Note:-The maximum marks for each subject is 100. Grades template: A+  Between 90 and 100 A   Between 80 and 90 B   Between 70 and 80 C   Between 60 and 70 D   Between 40 and 60 E - Below 40 (Failed) Develop a UI which will calculate the percentage and grade of a student, given the scores of the student in the subjects English,Maths,Science,History and Geography. Display student details along with his/her percentage and grade for a given roll number. OS:

Fruit Basket is a fruit shop selling fruits in the city. In Fruit Basket, they sell a variety of fruits to customers. Create a file purchase_details.txt containing the details of purchase on 22.03.2016.

The details of purchase on 22.03.2016 is as below:

A. Answer the following by using head,tail,filters and pipes(as the case may be).

Print every 2nd purchase detail starting from 4th purchase. Swap the fruit names 'Green_Grapes' and 'Black_Grapes'. Delete 3rd   and 5th lines in the file purchase_details.txt and redirect the output to output.txt. Print the number of records available in the file output.txt. Sort the file purchase_details.txt based on Quantity(in kg) and display the records with line number.

B. Given below is the table of price of fruits in Fruit Basket.

Calculate and print the bill for Sam and Paul using the details in purchase_details.txt and the above Fruits table using shell scripting.

IM:

A General Hospital consists of a number of specialized wards (such as Maternity, Paediatrics, Oncology, Orthopaedics,etc.). Each ward hosts a number of patients, who were admitted on the recommendation of their own GP and confirmed by a consultant employed by the Hospital. On admission, the personal details of every patient are recorded. A separate register is to be held to store the information of the tests undertaken and the results of a prescribed treatment. A number of tests may be conducted for each patient. Each patient is assigned to one leading consultant but may be examined by another doctor, if required. Doctors are specialists in some branch of medicine and may be leading consultants for a number of patients, not necessarily from the same ward.

Implement the above case study by using normalisation and constraints concepts. [Note:Create the necessary tables and answer the below SQL queries.]

1. Write a query using joins and/or sub-quer to display the test names which are suggested by the doctors who are treating PAEDIATRICS patients.