Explain clearly and concisely (you can give examples)of how the use of a query-p

Question

Explain clearly and concisely (you can give examples)of how the use of a query-plan-flash could be implemented to compare and store query execution plans over time with the "University" database ?
Note: using this database scheme

Paragraph Schema Diagram for University Database takes student ID aTte - dept-name fof crad ID sec id ester ear grade section course id course course id title credits department advisor dept namedept name building budget time slot building time slot id room no start time end time instructor ID narrie dept name salary prereg classroom building capacity prereg id teaches ear

Explanation / Answer

From given diagram , you can handlled complete functions of University including all teachers, students, courses details, class room, building and others details also.

Here I am going to explain Each table and there basic uses:

1.) advisor [Table]

s_id(pk), i_id(fk)

In this table user can capture all advisor records for both

advisor to student or advisor to instructor

2). instructor[Table]

Column: ID(pk), name, dept_name, salary

User can capture instuctor ID name , deptName, salary.

3). department [Table]

:User can captured dept_name(pk), building and budget details.

4). student [Table]

Column: ID(pk), name dept_name(fk), tot_cred

here user can captured multiple record if any student taken multiple detp courses.

5). prereq[Table]

to take addmission in University, usually student /others used to send pre request with course details(ID).

6). course[Table].

User can captured courses details like course_id(pk), title, dept_name and credits.

7). section[Table]

Here one section holds multple courses, so user can captured details like course_id, sec_id, semester, year, building, room_no, time_slot_id.

8). time_slot[Table],

This independent table where user can captured time_slot_id, day, start_time, end_time

9). classroom[Table]:

In this table user can captured normal details like building, room_no, capacity

10). takes [Table]

In case if one student registerd one or more courses at a time ,then user can easily captured data without data redundency like ID, course_id, sec_id, semester, year, grade.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.