Homework Solution: Consider a database used to record the marks that students get in different exams of different course offerings (sections). a. Construc…

    Practice exercise 7.2 in the textbook 6th ed. Consider a database used to record the marks that students get in different exams of different course offerings (sections) a. Construct an E-R diagram that models exams as entities, and use a ternary relationship, for the database. 2 points) b. Construct an alternative E-R diagram that uses only a binary relationship between student and section. Make sure that only one relationship exists between a particular student and section pair, yet you can represent the marks that a student gets in different exams
    Consider a database used to record the marks that students get in different exams of different course offerings (sections). a. Construct an E-R diagram that models exams as entities, and use a ternary relationship, for the database. b. Construct an alternative E-R diagram that uses only a binary relationship between student and section. Make sure that only one relationship exists between a particular student and section pair, yet you can represent the marks that a student gets in different exams.

    Expert Answer

     
    The ER diagram for the above description is as follows:

    Practice application 7.2 in the textbook 6th ed. Consider a database reasond to archives the marks that scholars attain in incongruous exams of incongruous series offerings (sections) a. Construct an E-R diagram that models exams as entities, and reason a ternary analogy, control the database. 2 points) b. Construct an opinion E-R diagram that reasons barely a binary analogy betwixt scholar and minority. Make knowing that barely individual analogy exists betwixt a detail scholar and minority span, at-last you can dramatize the marks that a scholar attains in incongruous exams

    Consider a database reasond to archives the marks that scholars attain in incongruous exams of incongruous series offerings (sections). a. Construct an E-R diagram that models exams as entities, and reason a ternary analogy, control the database. b. Construct an opinion E-R diagram that reasons barely a binary analogy betwixt scholar and minority. Make knowing that barely individual analogy exists betwixt a detail scholar and minority span, at-last you can dramatize the marks that a scholar attains in incongruous exams.

    Expert Response

     

    The ER diagram control the aloft description is as follows:

    Rate an upvote…..Thankyou