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

Question

Assume that you want to 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. Office: Registrar Office

2. Current Problem: The office is currently using manual methods for managing student records, registration, and other administrative tasks. This process is time-consuming, error-prone, and inefficient. The purpose of the database is to streamline and automate these processes, making them more efficient, accurate, and easily accessible.

3. Entities and Attributes:
- Student:
- ID (Primary Key)
- First Name
- Last Name
- Date of Birth
- Gender
- Address
- Phone Number
- Email

- Course:
- Code (Primary Key)
- Name
- Department
- Credits

- Faculty:
- ID (Primary Key)
- First Name
- Last Name
- Department

- Registration:
- Registration ID (Primary Key)
- Student ID (Foreign Key)
- Course Code (Foreign Key)
- Year
- Semester

- Grade:
- Grade ID (Primary Key)
- Registration ID (Foreign Key)
- Grade

4. Relationships and Cardinalities:
- One student can have multiple registrations (One-to-Many)
- One course can have multiple registrations (One-to-Many)
- One faculty can have multiple registrations (One-to-Many)
- One registration can have one student (Many-to-One)
- One registration can have one course (Many-to-One)
- One registration can have one faculty (Many-to-One)
- One registration can have one grade (One-to-One)

5. E-R Diagram:
- The E-R diagram is best represented visually. Please refer to the following link to view the diagram:

[Ambo University Woliso Campus Database Diagram](https://drive.google.com/file/d/1bA1_xi1lFLcVopGkTqMq_Tspq3EfrV_p/view?usp=sharing)