Recent content by AS7

I tried hard to complete but I can't. Please help me out :(

Patient(pid, pname, p_dob, p_city) Doctor(did, dname, d_dob, d_city, d_salary) Nurse(nid, nurse_name, n_dob, n_city, n_salary) Diagnose(did, pid, description) Treatment( did, pid, nid, tdate) *this colour indicates primary key How will I find the diagnose description that the patients were...

Student(student_id, fname, lname, dob, city, cgpa, deptno) Course (ccode, cname, noofcredits, deptno) StudentCourse ( student_id, ccode, grade) Department (deptno, dname) *this colour indicates primary key Q1: Assume that Student, Course and Department tables are already created. Please...