Question

1.one office of Ambo University Woliso Campus such as:- Register Office. design a database for the office that you selected .
2.State clearly the current problem of the office and the purpose of your database to the office.
3.Identify the necessary entities and their attributes for your database. Set appropriate. primary key for each entity accordingly.
4.Identify the relationships and the cardinalities among those entities.
5.Draw the E-R diagram for your database.

Answer 1

1. The office selected is the Register Office of Ambo University Woliso Campus.

2. The current problem of the office is the inefficient management and organization of student records and registration processes. The purpose of the database is to streamline and automate these processes, making them more efficient and accessible for both the office and the students.

3. The necessary entities and their attributes for the database are:
- Student: student_id (Primary Key), first_name, last_name, date_of_birth, gender, address, phone_number, email
- Course: course_id (Primary Key), course_name, credit_hours, instructor
- Registration: registration_id (Primary Key), student_id (foreign key), course_id (foreign key), semester, year

4. The relationships and cardinalities among the entities are as follows:
- One student can have multiple registration records (1 to Many)
- One course can have multiple registration records (1 to Many)

5. E-R diagram for the database:
```
+---------------------+ +-------------------+
| Student | | Course |
+---------------------+ +-------------------+
| student_id (PK) | | course_id (PK) |
| first_name | | course_name |
| last_name | +---------+ | credit_hours |
| date_of_birth +----<| | | instructor |
| gender | | | +-------------------+
| address | | Registration
| phone_number | | | +-------------------+
| email +----<| | | registration_id(PK)|
+---------------------+ +---------+ | student_id (FK) |
| course_id (FK) |
| semester |
| year |
+-------------------+
```