Computers and Technology

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.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 00:20, kathlynskare06
Ihave been given the number of guns per 100, and the total firearm-related deaths per 100,000. i have to find the actual number of guns per country and actual number of gun-related deaths. if somebody could show me how to do 1 question, i can finish the rest, i am just confused. tia
Answers: 3
image
Computers and Technology, 23.06.2019 11:30, magicalpenguin48
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
image
Computers and Technology, 23.06.2019 17:00, solizpaco7124
1. which of the following is not an example of an objective question? a. multiple choice. b. essay. c. true/false. d. matching 2. why is it important to recognize the key word in the essay question? a. it will provide the answer to the essay. b. it will show you a friend's answer. c. it will provide you time to look for the answer. d. it will guide you on which kind of answer is required.
Answers: 1
image
Computers and Technology, 24.06.2019 09:30, nialphonsa
Atype of researcher who uses computers to make sense of complex digital data
Answers: 1
Do you know the correct answer?
Design ER model specifying key attributes, entity types, relationship types (1: 1, 1: N, M: N), and...

Questions in other subjects:

Konu
Spanish, 05.11.2020 21:40
Konu
Mathematics, 05.11.2020 21:40
Konu
Mathematics, 05.11.2020 21:40
Konu
Mathematics, 05.11.2020 21:40