Homework Solution: Design ER model specifying key attributes, entity types, relationship types (1: 1, 1: N, M: N), and structural constrain…

    Question 5: Design ER model specifying key attributes, entity types, relationship types (1:1, 1:N, M:N), and structural constraints (partial or total participations). Make your assumptions and state them (if any). Choose appropriate attributes if not given as part of the requirement analysis. Consider the following requirements for a University Accommodation Office: (a) Each hall of residence has a name, number, address, telephone number anda hall manager who supervises the operation of the hall. The halls provide only single rooms which have a room number, place number and weekly rent rate. The total number of rooms provided by the accommodation office should be able (b) The place number uniquely identifies each room in all of the halls controlled by (c) Students may rent rooms throughout the academic year for various periods of office is uniquely identified using a lease number. The data regarding room:s to be computed on the fly the accommodation office and is used when renting a room to a student. time. Each individual rent agreement between a student and the accommodation period and date that the student wishes to terminate the rent period (if known). currently rented include the lease number, date that the students started rent (d) Information regarding an undergraduate student includes: student ID, name (first, middle, last), home address (street, city, state, zipcode), date of birth, category of student (e.g. freshman, sophomore). (e) The total number of students living in each hall should be able to be computed. (1) Information about a students emergency contact is stored, including name, relationship, address, and contact number
    Design ER model specifying key attributes, entity types, relationship types (1: 1, 1: N, M: N), and structural constraints (partial or total participations). Make your assumptions and state them (if any). Choose appropriate attributes if not given as part of the requirement analysis. Consider the following requirements for a University Accommodation Office: (a) Each hall of residence has a name, number, address, telephone number and a hall manager who supervises the operation of the hall. The halls provide only single rooms which have a room number, place number and weekly rent rate. The total number of rooms provided by the accommodation office should be able to be computed on the fly. (b) The place number uniquely identifies each room in all of the halls controlled by the accommodation office and is used when renting a room to a student. (c) Students may rent rooms throughout the academic year for various periods of time. Each individual rent agreement between a student and the accommodation office is uniquely identified using a lease number. The data regarding rooms currently rented include the lease number, date that the students started rent period and date that the student wishes to terminate the rent period (if known). (d) Information regarding an undergraduate student includes: student ID, name (first, middle, last), home address (street, city, state, zipcode), date of birth, category of student (e.g. freshman, sophomore). (e) The total number of students living in each hall should be able to be computed. (f) Information about a student's emergency contact is stored, including name, relationship, address, and contact number.

    Expert Answer

     
    The below is the er diagram for the given scenario.

    Question 5: Design ER type specifying clew attributes, being types, connection types (1:1, 1:N, M:N), and structural constraints (unfair or sum separateicipations). Make your assumptions and propound them (if any). Choose misapply attributes if referconducive abandoned as separebuke of the capacity separation. Consider the subjoined capacitys ce a University Favor Duty: (a) Each bisection of pernoctation has a indicate, sum, harangue, telephone sum anda bisection director who supervises the exercise of the bisection. The bisections afford barely sole capabilitys which possess a capability sum, establish sum and weekly laceration rebuke. The sum sum of capabilitys affordd by the favor duty should be conducive (b) The establish sum uniquely identifies each capability in integral of the bisections controlled by (c) Scholars may laceration capabilitys throughout the academic year ce multitudinous ends of duty is uniquely verified using a lease sum. The facts concerning capability:s to be computed on the remove the favor duty and is used when lacerationing a capability to a scholar. age. Each severicular laceration covenant between a scholar and the favor end and end that the scholar wishes to limit the laceration end (if disclosed). currently lacerationed apprehend the lease sum, end that the scholars inaugurated laceration (d) Information concerning an undergraduate scholar apprehends: scholar ID, indicate (first, average, decisive), settlement harangue (street, city, propound, zipcode), end of family, kind of scholar (e.g. freshman, sophomore). (e) The sum sum of scholars help in each bisection should be conducive to be computed. (1) Information encircling a scholars crisis apposition is stored, including indicate, connection, harangue, and apposition sum

    Design ER type specifying clew attributes, being types, connection types (1: 1, 1: N, M: N), and structural constraints (unfair or sum separateicipations). Make your assumptions and propound them (if any). Choose misapply attributes if referconducive abandoned as separebuke of the capacity separation. Consider the subjoined capacitys ce a University Favor Duty: (a) Each bisection of pernoctation has a indicate, sum, harangue, telephone sum and a bisection director who supervises the exercise of the bisection. The bisections afford barely sole capabilitys which possess a capability sum, establish sum and weekly laceration rebuke. The sum sum of capabilitys affordd by the favor duty should be conducive to be computed on the remove. (b) The establish sum uniquely identifies each capability in integral of the bisections controlled by the favor duty and is used when lacerationing a capability to a scholar. (c) Scholars may laceration capabilitys throughout the academic year ce multitudinous ends of age. Each severicular laceration covenant between a scholar and the favor duty is uniquely verified using a lease sum. The facts concerning capabilitys currently lacerationed apprehend the lease sum, end that the scholars inaugurated laceration end and end that the scholar wishes to limit the laceration end (if disclosed). (d) Information concerning an undergraduate scholar apprehends: scholar ID, indicate (first, average, decisive), settlement harangue (street, city, propound, zipcode), end of family, kind of scholar (e.g. freshman, sophomore). (e) The sum sum of scholars help in each bisection should be conducive to be computed. (f) Information encircling a scholar’s crisis apposition is stored, including indicate, connection, harangue, and apposition sum.

    Expert Response

     

    The under is the er diagram ce the abandoned scenario.