draw Entity$-$Relationship $($ER$)$ Diagram for "Oman Emergency Assistance" App

Below is the ER diagram for the "Oman Emergency Assistance" app, illustrating the main entities, their attributes, and the relationships between them.

Entities and Relationships

User

Attributes: User$\_$ID $($Primary Key$),$ Username, Password, Full$\_$Name, Phone$\_$Number, Email, Address

Relationships:

A User can have multiple Emergency Calls.

A User can view multiple Emergency Contacts.

A User can share multiple GPS Locations.

A User can view multiple Blood Donation Centers.

A User can access multiple Educational Resources.

Emergency Call

Attributes: Call$\_$ID $($Primary Key$),$ User$\_$ID $($Foreign Key$),$ Contact$\_$ID $($Foreign Key$),$ Call$\_$Time, Call$\_$Type

Relationships:

An Emergency Call is made by one User.

An Emergency Call is related to one Emergency Contact.

Emergency Contact

Attributes: Contact$\_$ID $($Primary Key$),$ Contact$\_$Type, Contact$\_$Name, Phone$\_$Number

Relationships:

An Emergency Contact can receive multiple Emergency Calls from different Users.

GPS Location

Attributes: Location$\_$ID $($Primary Key$),$ User$\_$ID $($Foreign Key$),$ Latitude, Longitude, Timestamp

Relationships:

A GPS Location is shared by one User.

Blood Donation Center

Attributes: Center$\_$ID $($Primary Key$),$ Center$\_$Name, Address, Phone$\_$Number, Operating$\_$Hours, Blood$\_$Type$\_$Needed

Relationships:

A Blood Donation Center can be viewed by multiple Users.

Educational Resource

Attributes: Resource$\_$ID $($Primary Key$),$ Resource$\_$Type, Title, Description, Content, Last$\_$Updated

Relationships:

An Educational Resource can be accessed by multiple Users.

Detailed Entity Descriptions

User

User$\_$ID: Unique identifier for each user.

Username: User's login name.

Password: User's login password.

Full$\_$Name: User's full name.

Phone$\_$Number: User's contact number.

Email: User's email address.

Address: User's physical address.

Emergency Call

Call$\_$ID: Unique identifier for each emergency call.

User$\_$ID: Identifier of the user making the call.

Contact$\_$ID: Identifier of the emergency contact being called.

Call$\_$Time: Time the call was made.

Call$\_$Type: Type of emergency call $($e$.$g$.,$ police, fire, medical$).$

Emergency Contact

Contact$\_$ID: Unique identifier for each emergency contact.

Contact$\_$Type: Type of emergency contact $($e$.$g$.,$ police, ambulance$).$

Contact$\_$Name: Name of the contact person or service.

Phone$\_$Number: Phone number of the contact.

GPS Location

Location$\_$ID: Unique identifier for each GPS location shared.

User$\_$ID: Identifier of the user sharing the location.

Latitude: Latitude coordinate of the location.

Longitude: Longitude coordinate of the location.

Timestamp: Time when the location was shared.

Blood Donation Center

Center$\_$ID: Unique identifier for each blood donation center.

Center$\_$Name: Name of the blood donation center.

Address: Address of the center.

Phone$\_$Number: Contact number of the center.

Operating$\_$Hours: Operating hours of the center.

Blood$\_$Type$\_$Needed: Blood types currently needed by the center.

Educational Resource

Resource$\_$ID: Unique identifier for each educational resource.

Resource$\_$Type: Resource type $($e$.$g$.,$ first aid, safety tips$).$

Title: Title of the resource.

Description: Description of the resource.

Content: Actual content of the resource.

Last$\_$Updated: Date when the resource was last updated.