FYBCA SEM 2 DBMS ASSIGNMENT



DBMS Practical Assignment




 Assignment -10

Doctor_master(doctid,doctname,address,specialization)
Patient_master(patid,doctid,patname,DOB,address,phoneno)
Doctid and patid should be declared as primary key while creating table.
Create appropriate relationship between tables. “Specialization” field must not be null.

Queries:
1. Display patients treated under the doctor “Mr.Mehta”.
2. Remove the patient of doctor “Mr.X” with specialization “Surgeon”.
3. Find out patients whose age is greater than 15 years.
4. Display the doctors whose name contains “D” and last charcter is “A”.
5. Display total patients treated by each doctor.
6. Display patients who born before year 2001.
7. Removes patients whose phone number ends with digits 7 or 9.
8. Add new column “treatment_date” in table patients.
9. Display patients who have taken treatment in current month.
10. Display doctor who have treated maximum patients.

Assignment -11

Vehicle(vid,name,color,price,company)
Customer(cid,name,address,phoneno,email)
Sell(vid,cid,selldate,amount)
Constraints:
vid and cid must be declared as primary key while creating table.the colour value must be
“red”,”black” and “white”.
Create appropriate relationship between tables.

Queries:
1. Add new column tax in vehicle table.
2. Display the vehicles which are not sold in last one year.
3. Display vehicles with maximum profit.
4. Display vehicle having highest sell.
5. Display total amount of sale of each vehicle.
6. Display total number of vehicle of same company.
7. Display vehicle details purchased in current month.
8. Display vehicles with “red” colour.
9. Display vehicle details whose name starts with “H”.
10.Count total vehicle sale in current month whose company name contain minimum 10
charaters.

Assignment -12

Product(pid,pname,ptype,price,qty)
Salesman(sid,name,area,DOJ,target)
Sales(pid,sid,saledate,qty)
Constraints:
pid and sid must be declared as primary key while creating table.Create appropriate relationship
between tables.
Qty field must not null and default value should be 15.

Queries:
1. Display total qty sold of product “xyz”.
2. Count total products sale by each salesman.
3. Display salesman who sold more products than given target.
4. Display products which are not sold in last one year.
5. Display salesman who have joined in current month.
6. Count total products of each type.
7. Display salesman whose name contain more than 5 charcters and joined in current year.
8. Display average sale of each salesman.
9. Remove the column area from salesman table.
10. Incrase the target of employee by 50 who have more than five year of experience.

Comments

Post a Comment

Popular posts from this blog

PHP ASSIGNMENT

Image
PHP ASSIGNMENT    PHP Assignment -1 1. Write a script for finding out whether it is an odd number or even number and echo on  the screen. 2. Write a PHP Script to take 2 variables with specific numeric value of your choice and  Perform the following operations: Addition, Subtraction, Multiplication and Division using  switch case. Also echo out the Result on the screen. 3. Write a PHP Script to declare 2 variables with specific numeric value of your choice and  find out the greater number between the two(Use ternary operator). If the numbers are  equal, the respective message must appear on the screen. 4.Write a PHP Script to check if the string is palindrome 5. Write a PHP Script to Calculate the Sum of Odd & Even Numbers. 6. Write a PHP Script to Check if a given Integer is Positive or Negative. 7. Write a PHP Script to Read Two Integers M and N & Swap their Values. 8. Write a PHP Script to Accept two Integers and Check if they are Equal. 9. Write a PHP Script to check if the
Read more

FYBCA CPPM ASSIGNMENT SEM 1

Image
FYBCA-ASSIGNMENT-SEM-1 Assignment – 1                                                       Assignment Date: 21/8/2017 Subject: CPPM                                                      Submission Date: Questions: 1. Write a C program to interchange value of two numbers using third variable. 2. Write a C program to convert degree to radians. (Formula: degree=π/180) 3. Write a C program to input quantity and price of an item and display total Rs. on screen. Also input discount (%) and display final payment Rs on screen. 4. Write a C program to input a three digit number from user and calculate sum of first and last digit. 6. Write a C program to find largest of three numbers using ternary operator. 7. If cost price and selling price of an item are input through the keyboard, write a C program to determine whether the seller has made profit or loss and evaluate it. 8. Write a program to read two integer values m and n and to decide and print whether m is multiple of n. Download Cppm
Read more

FYBCA SEM 2 C ASSIGNMENT-I

Image
SHRI SHAMBHUBHAI V. PATEL COLLEGE OF C. S. & B. M. F.Y.B.C.A (SECOND SEMESTER) PRACTICAL ASSIGNMENT-I FYBCA SEM 2 C ASSIGNMENT-I  2018 1) Write a program to generate all possible combination of string for a given string. E.g. Input “surat” O/p: surat, urats, ratsu, atsur, tsura. 2) Write a program to read a sentence (containing blank spaces) and display it in toggle case. 3) Write a program to read a sentence. Count the number of capital letter, small letters , special characters and numbers. 4) Write a program to check whether given string is palindrome or not. 5) Write a program to do the following on a given string. I/p: patel shiv kumar O/p:  patel  shiv  kumar 6) Write a program which will read a string and rewrite it in the alphabetical order. For ex:- input=”string” output= “ginrst” Click Here to Download Fybca Assignment 2018
Read more