of STUDENT in a college is identified by Student_id. They are described by Name, AdmissionDate, Date_of_birth, Contact_number, Address and Subject(A student can have many contact numbers and can study more than one course). Address consists of Houseno, Suburb and City. There are many departments. Attributes of DEPARTMENT are Department_code (key attribute), DepartmentName and Location. A student is admitted to only one department. A department must have at least one student admitted of STUDENT in a college is identified by Student_id. They are described by Name, AdmissionDate, Date_of_birth, Contact_number, Address and Subject(A student can have many contact numbers and can study more than one course). Address consists of Houseno, Suburb and City. There are many departments. Attributes of DEPARTMENT are Department_code (key attribute), DepartmentName and Location. A student is admitted to only one department. A department must have at least one student admitted