Suppose you are given a data set of a college. This data set includes mainly four tables:
Student: This table contains information about the students, such as student id, name, range of marks scored in the exam, year of graduation and branch id.
Branch: This table includes the different branches present in the college, such as Electrical, Mechanical, Civil, Computer Science, Chemical, etc., along with the branch ids.
HoD: This table contains information about the HoDs of the different branches. The information includes HoD name, duration of service as HoD, branch id of the branch in which a particular person is/was HoD and their contact information.
Marks: This table contains the mapping of range of marks with the grades assigned.
You can consider the following entries as examples of each of the table formats above.
Comments