Using draw.io diagram tool, design a database schema for an application that tracks and manages students applications for a university. Make sure to create proper primary key for each entity. Add relations and specify cardinalities.

• All entities and attributes must be named using the underscore convention. Highlight primary keys in red
• List any assumptions you have made.

• The university needs to keep track of students application. The application contains information about student: name, address, phone number, DOB, SSN, and generate a unique ID for each student.
• Education records has to be submitted as well. The education records contain information about previous degrees, GPA, name of school attended and dates ( from to dates)
• Test scores are also submitted along with applications. The student can submit more than one test score. The test score consist of test type, date and score.
• The student should also specify which major they are applying to, for what term
• The university assign one employee from the admission office to process the application. The employee will handle multiple application at the same time.
• Applications can be submitted to different departments.