one office of Ambo University Woliso Campus such as:- Dormitory

Question

design a database for the office that you selected

Answer 1

To design a database for an office at Ambo University Woliso Campus, such as a Dormitory, we need to identify the entities and their attributes associated with the office. Here is an example database design for a Dormitory:

1. Entity: Dormitory
Attributes:
- DormitoryID (Primary Key)
- DormitoryName
- Capacity (maximum number of occupants)
- Gender (male/female/mixed)
- FloorCount
- ContactNumber

2. Entity: Room
Attributes:
- RoomID (Primary Key)
- DormitoryID (Foreign Key)
- RoomNumber
- Occupancy (current number of occupants)
- RoomType (e.g., Single, Double, Triple)
- MonthlyRent
- Availability (available/unavailable)
- DateAdded

3. Entity: Student
Attributes:
- StudentID (Primary Key)
- FirstName
- LastName
- Gender
- Phone
- Email
- DateJoined

4. Entity: DormitoryAllocation
Attributes:
- AllocationID (Primary Key)
- RoomID (Foreign Key)
- StudentID (Foreign Key)
- AllocationDate (date when the student was allocated to the room)
- CheckInDate
- CheckOutDate
- Status (occupied/vacant)

Note: Foreign keys (DormitoryID, RoomID, StudentID) establish relationships between entities by referring to primary keys from their respective tables.

This database design allows for tracking and managing the dormitory rooms, student information, and allocation details in a systematic manner. It can be expanded further based on specific requirements and additional attributes or tables necessary for the office's operations.