" you can draw the ER diagram in your hand and i will draw it in the tool " thank you Faculty management system In this

[answerhappygod]

" you can draw the ER diagram in your hand and i will draw it in the tool "
thank you
Faculty management system
In this system Many students can study on many courses,Many staff can teach on many courses and Each course contains many assignments.
The system contains theses entities
Students - This table holds information about the students attending a college. Each student is given a unique identifier.
Staff - Holds information about the staff, contains a unique identifier for each staff member
Assignments - Holds information about assignments, has unique identifier for each assignment, start date ,finish date, course ID
Courses - Holds information about courses, has unique identifier for each course.
Result - This holds information about each student's result of each assignment in each course
The requirements
Draw relationship between entities using Edraw Max , then Create tables using oracle,. After that write 10 SQL statements to perform these queries.
1-find out which course the student is studying.
2-display student names for a staff member for individual courses that that they study on, as well as all courses
3- Display new assignments for students (if any) that staff submit to day.
4-display the student names and his result of each assignments categorized by each course.
5- display the name of the student that have maximum degree in all assignments (الأول على الدفعة ).
6- display the details of the assignments showing assignment ID and its course name that currently unfinished.
7- display the number of courses for each student he is studying
8-display the number of students in each course.
9- display the courses that will be finished next week.
10- display the name of the stuff and the number of his courses that are finished last month