Question

Using draw.io diagram tool, design a database schema for an application that tracks and manages students’ applications for a university. You have complete freedom in how you want to design your database, but you need to justify your decisions. Make sure to create proper primary/foreign key relationships between your tables. All entities and attributes must be named using the underscore convention.

Answer 1

Explanation for the relationship between the tables :-

There are five tables named Student(Student_ID as primary key & College_ID and Course_ID as Foreign keys ) , Admission_form(Adission_ID as primary key and College_ID, Student_ID,Course_ID as the foreign keys) , Course(Course_ID as primary key) , College(College_ID as the primary key) , College_course (College_ID and Course_ID as the primary key and both as the foreign keys as well) .

Points for relationship between the tables :-

- Only one student can fill only one admission form therefore it is One-to-One relation between them.

- One college can have many students therefore there is One-to-Many relation between them.

- One college can have many courses therefore there is One-to-Many relation between them .

- One course can have many admission forms therefore there is One-to-Many relation between them .

- entries in the college_course table can have a combination of One-to-one or One-to-many .

Below is the design for the student's applications :-