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.
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 |
+-------------------+
```
Step 1: Designing a database for the Register Office of Ambo University Woliso Campus.
Step 2: The current problem of the office is inefficient and error-prone manual record-keeping. The purpose of the database is to automate and streamline the registration process, ensuring accurate and easily accessible records.
Step 3: Identifying necessary entities and their attributes:
Entity: Student
- Attributes: Student ID (primary key), Name, Gender, Date of Birth, Contact Number, Email
Entity: Course
- Attributes: Course ID (primary key), Course Name, Credit Hours
Entity: Registration
- Attributes: Registration ID (primary key), Student ID (foreign key), Course ID (foreign key), Registration Date
Step 4: Identifying the relationships and cardinalities among the entities:
- Student and Course have a Many-to-Many relationship.
- Registration has a Many-to-One relationship with both Student and Course.
Step 5: Drawing the E-R diagram for the database:
```
+---------------+
| STUDENT |
+---------------+
| Student ID (PK)|
| Name |
| Gender |
| Date of Birth |
| Contact Number|
| Email |
+---------------+
^
|
| +---------------+
+------- | COURSE |
| +---------------+
| | Course ID |
+------- | Course Name |
| | Credit Hours |
| +---------------+
|
|
| +-----------------+
+------- | REGISTRATION |
+-----------------+
| Registration ID |
| Student ID (FK)|
| Course ID (FK) |
| Registration dt|
+-----------------+
```
Note: FK denotes foreign key.