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, 23.06.2019 23:30
A. in packet tracer, only the server-pt device can act as a server. desktop or laptop pcs cannot act as a server. based on your studies so far, explain the client-server model.
Answers: 2
question
Computers and Technology, 24.06.2019 22:30
To include a watermark or page border on a word document, you will first need to navigate to the tab. file home insert design
Answers: 1
question
Computers and Technology, 25.06.2019 00:00
When pasting an existing chart into a word document, you can choose to using the paste options button. a. paste the chart as a picture b. embed the chart c. add the chart while keeping the destination formatting intact d. insert the chart while keeping the source formatting intact
Answers: 1
question
Computers and Technology, 25.06.2019 19:30
Denise is creating a web page about rainforest animals. her friend has many photos of animals from a trip to brazil. denise wants to use some of those photos for her web page. which input device is best for transferring photos to her multimedia project? a. digitizing tablet b. keyboard c. graphic pad d. digital camera reset next
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
Mathematics, 29.05.2020 22:00
question
Mathematics, 29.05.2020 22:00
question
Mathematics, 29.05.2020 22:01
question
Mathematics, 29.05.2020 22:01
question
Mathematics, 29.05.2020 22:01
question
Mathematics, 29.05.2020 22:01
question
Mathematics, 29.05.2020 22:01
Questions on the website: 13722367