Database Management ER Diagram and SQL workbench.

Following are the entities and attributes of the proposed system.

Entities	Attributes
Classroom	Year, section
Attendance	Date, student_ID,
course	Course_name,course_ID
student	Student_id,student_name ,fname,Lname,DOB,phone,address,date_of_joining
exam	Status, marks
teacher	Teacher_id, teacher_name, sub_teaching, salary
parent	Phone, address,Fname,Lname,student_name

Questions:

1. How many students are newcomers?

2. List the students who don’t have any contact number.

3. How many teachers are teaching English?

4. How many teachers are on leave?

5. How many students secured less than 50% in last examination?

6. List the students whose credentials are missing.

7. How many teachers teach math?

8. List the number of total staffs.

9. How many students have secured more than 80% in examination?

10. List the total numbers of courses.