subject

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.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 00:30
These tools give presenters more freedom to move about the room and interact with their audience. laptop computer laser pointer lcd projector remote control
Answers: 2
question
Computers and Technology, 23.06.2019 00:10
Write a function so that the main0 code below can be replaced by the simpler code that calls function mphandminutes tomiles0. original main0 int main) l double milesperhour-70.0; double minutestraveled = 100.0; double hourstraveled; double milestraveled; hourstraveled = minutestraveled / 60.0; milestraveled = hourstraveled * milesperhour; cout < "miles" 2 using namespace std; 4 /* your solution goes here/ 6 int maino 1 test passed 7 double milesperhour 70.0 all tests passed 8 double minutestraveled 100.0; 10 cout < < "miles: " < < mphandminutestomiles(milesper-hour, minutestraveled) < < endl; 12 return 0; 13
Answers: 1
question
Computers and Technology, 24.06.2019 07:00
Into what form does the barcode reader convert individual bar patterns?
Answers: 1
question
Computers and Technology, 24.06.2019 13:00
George heard about the benefits of a data warehouse. he wants to try implementing one for his organization. however, he is afraid that transferring data to the data warehouse will affect transaction time. which element ensures that transactions are not affected when moving data to a warehouse? when data is transferred to a data warehouse, the a area frees the source system to continue transaction processing.
Answers: 2
You know the right answer?
Design ER model specifying key attributes, entity types, relationship types (1: 1, 1: N, M: N), and...
Questions
question
Mathematics, 10.07.2019 18:00
question
Mathematics, 10.07.2019 18:00
question
Mathematics, 10.07.2019 18:00
question
History, 10.07.2019 18:00
Questions on the website: 13722363