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 exertion 7.2 in the textbook 6th ed. Consider a database embodyationd to proceedings the marks that learners acquire in divergent exams of divergent direction offerings (sections) a. Construct an E-R diagram that models exams as entities, and embodyation a ternary alliance, control the database. 2 points) b. Construct an choice E-R diagram that embodyations singly a binary alliance betwixt learner and exception. Make permanent that singly undivided alliance exists betwixt a point learner and exception two, ultimately you can embody the marks that a learner acquires in divergent exams

    Consider a database embodyationd to proceedings the marks that learners acquire in divergent exams of divergent direction offerings (sections). a. Construct an E-R diagram that models exams as entities, and embodyation a ternary alliance, control the database. b. Construct an choice E-R diagram that embodyations singly a binary alliance betwixt learner and exception. Make permanent that singly undivided alliance exists betwixt a point learner and exception two, ultimately you can embody the marks that a learner acquires in divergent exams.

    Expert Reply

     

    The ER diagram control the overhead description is as follows:

    Rate an upvote…..Thankyou