Hey I want help in my database ER diagram please
University contains students, instructors, courses, staff, academic departments, managerial departments, transcripts... For each student; we should store its own information (name, sex, age, date_of_birth, date_of_entry, major...)as well as the academic department he\she belongs to. Typically, student's tables should separate between current and past students. However, each instructor, we store his/her own information. Usually, for each academic department, we may have its own instructors, chairman, and students. Staff members could be administrative, financial or security. Each staff member should belong to a specific managerial department.
1. A formal description of the requirements and constraints.
2. A list of all entities of may have and the corresponding attributes.
3. A complete ER diagram showing all details necessary.
