1. Organization Project Dormitory Police is a fictional organization responsible for maintaining security and order in a university dormitory complex.
2. The organization's main purpose is to enforce rules and regulations, prevent crime, and ensure the safety of the dormitory residents.
3. Entities and their attributes:
- Dormitory: Attributes may include dormitory ID, name, capacity, address, and contact information.
- Police Officer: Attributes may include officer ID, name, age, rank, contact information, and assigned dormitory.
- Resident: Attributes may include resident ID, name, age, contact information, room number, and assigned dormitory.
- Incident Report: Attributes may include report ID, date of incident, description, status, dormitory ID, and officer ID.
4. Degree of relationship:
- Dormitory has a many-to-many relationship with Police Officer, as multiple officers can be assigned to different dormitories, and a dormitory can have multiple officers responsible for its security.
- Dormitory has a one-to-many relationship with Resident, as one dormitory can have multiple residents, but each resident can only be assigned to one dormitory.
- Police Officer has a one-to-many relationship with Incident Report, as one officer can handle multiple incident reports, but each incident report is assigned to only one officer.
5. Cardinalities:
- Dormitory to Police Officer: Many-to-Many
- Dormitory to Resident: One-to-Many
- Police Officer to Incident Report: One-to-Many
1.organization project dormitory police.
2. define the organization.
3.Identify the entities and their attributes
4.Identify the degree of their relationship
5.Identify their cardinalities
1 answer
5 answers