DBMS Assignment
LAB ASSIGNMENT -1 DBMS FYBCA (SEM 2)
Database : College_Management_System
Tables: University (u_id, u_name, u_addr,u_city)
College (c_id, c_name, c_addr,c_city, c_state)
Department (d_id, d_name)
Student (s_id,s_name, s_addr,s_city, s_phno)
Course (course_id, course_name)
Professor (p_id, p_name, p_addr, p_city,p_phno, p_designation)