BScIT in Nepal: DBMS Lab report 1(Theoritical Part)

Theoretical part:

Entity Sets And Their Corresponding Attributes:

Teachers_detail:

Tid, Tname, Address, Contactno, Qualification, Major, Minor, Type

Student_detail :

Roll, Name, Address, Contactno, Email, DOB, faculty, yearsem, batch, level

Subject_detail:

Subid, Tid, Faculty, Yearsem, Level, Title, Hours, Fm, Pm, Type

Exam_detail :

ExamYear, Term, Start_date, End_date

Marks_detail:

Examyear, term, Roll, Subid, Fm, Marks

Relationship Set:

Let R be the relationship set. Then,

R={ teachers_detail, subject_detail}

Let another relationship set R such that R={student_detail , marks_detail }

Let another relationship set R. such that R={ marks_detail, exam_detail }

Let relationship set R such that R= { subject_detail, marks_detail}

Strong Entity Sets:

Teachers_detail

Student_detail

Subject_detail

Exam_detail

Weak Entity Sets:

Marks_detail

Multi-valued Attributes:

Telephone

Phno

Email

Derived Attributes:

          There is a derived attribute in the relation exam_detail. The derived attribute is result_day.

 E-R diagram :

Schema diagram:

For Practical Part:

               CLick Here