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, 22.06.2019 20:00
Which type of file can be used to import data into a spreadsheet?
Answers: 1
question
Computers and Technology, 23.06.2019 01:30
How do you set up a slide show to play continuously, advancing through all the slides without requiring your interaction? a. click set up slide show, and then select the loop continuously until ‘esc' and show without narration options. b. click set up slide show, and then select the loop continuously until ‘esc' and use timings, if present options. c. click set up slide show, and then select the show presenter view and use timings, if present options. d. click set up slide show, and then select the show without animation and browsed at a kiosk (full screen) options.
Answers: 3
question
Computers and Technology, 23.06.2019 07:00
Why is investing in a mutual fund less risky than investing in a particular company's stock? a. mutual funds only invest in blue-chip stocks. b. investments in mutual funds are more liquid. c. mutual funds hold a diversified portfolio of stocks. d. investments in mutual funds offer a higher rate of return.
Answers: 2
question
Computers and Technology, 23.06.2019 13:30
Best laptops for college [$100-$500 range]?
Answers: 2
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
Questions on the website: 13722362