subject

After getting admission in a college/university, if a student is not a local student then he/she can apply for hostel residence. At the time of registration , an admission form is filled by students. While filling a form, students need to provide visitors detail so that only registered visitors can visit a student after getting authentication by hostel admin. Admin can allocate room and hostel mess to a student. After getting admission confirmation notification from hostel authorization, a student can view available facilities and hostel allocation details. Hostel admin is responsible to provide basic facilities like library, newspaper ,electricity, internet and meal facilities to all the students. In a students fee voucher, calculation of hostel mess charges depends on students presence/stay and utilization of this facility. Students can view and download hostel fee voucher, after paying fee students should upload paid fee voucher. Students can post complaints and view notification/ alerts generated by hostel warden.
Hostel staff(hostel warden, employees, mess staff etc) can login to mark attendance. Hostel warden should be able to view students and staffs attendance records, view students complaints and can send alerts or notification to students. Hostel admin can view hostel records(students, staff, rooms, visitors, attendance, payment etc details). He/she Add/update hostel records(students, staff, rooms, visitors, attendance, payment etc details). Admin should also be able to generate students, staff and dues reports.

You are required to perform the following tasks according to above scenario:
Task 1: Draw the Entity Relationship diagram.
Task 2: Draw relationship cardinalities in alphabetical notation.
Task 3: Map the ER diagram to Relation data model and link the relations through primary key and foreign key.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 00:00
Visualizing a game of β€œtag” to remember the meaning of contagious
Answers: 3
question
Computers and Technology, 24.06.2019 11:00
Each row in a database is a set of unique information called a(n) ? a.) table. b.) record. c.) object. d.) field.
Answers: 2
question
Computers and Technology, 24.06.2019 15:30
What is the function of compilers and interpreters? how does a compiler differ from an interpreter?
Answers: 2
question
Computers and Technology, 24.06.2019 17:30
List at least one thing to check for when you're checking the clarity and professionalism of a document.
Answers: 1
You know the right answer?
After getting admission in a college/university, if a student is not a local student then he/she can...
Questions
question
Spanish, 18.02.2021 01:00
question
Mathematics, 18.02.2021 01:00
question
Mathematics, 18.02.2021 01:00
question
Mathematics, 18.02.2021 01:00