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...