Question: Draw ERD and transform the ERD into relation schema for the following questions: Q 1 : A university needs to manage information about students and

Draw ERD and transform the ERD into relation schema for the following questions: Q1: A university needs to manage information about students and their course enrollments. The system requires tracking both course information (course ID, title, and credit hours) and student information. The student details are: Student ID, Name (first name, middle name, last name), Present address (including house number, street, thana, district, and postal code), permanent address (including house number, street, thana, district, and postal code), multiple email addresses and multiple mobile numbers, date of birth, Total Credits, CGPA and calculated age. You have to record semester, year, marks, grade_point, letter_grade for courses taken by students. A student can improve or repeat the courses taken by him. There are many projects undertaken by students under the guidance of teachers. Each teacher can supervise multiple projects, and each project can involve multiple students. However, a specific project-student pairing must be supervised by only one teacher. To track this information, we need to record the project ID, title, location, and budget for each project. For each teacher or supervisor, we need their ID, name, street address, thana, district, and salary Q.2: The library information system is described below: A book can be issued to only one borrower but a borrower can borrow multiple number of books. Borrower is a person who is authorized to borrow books from the library for a specific number of days. Each borrower must have a membership id, name, contact number and address. When a book is issued some information such as issue date, book id, borrower id, length of period for issue and return due date are needed to enter in to the database. At the same the borrowed book should be labeled as issued and will be cleared after return by the borrower. After return of the book, it can be issued to another borrower. So a book is borrowed by multiple borrowers in different times. Q.3: All people working in an organization are called employees identified by employee id. All employees must have name, address, mobile and email. An employee must be one of the following: technical or non-technical. Technical employees have the trade and year of experience. Non-technical employees have highest degree and year of experience. Q.4: A person is described by id, name as first name, middle name, last name, multiple qualifications and trainings, present address (street no, street name, city) and permanent address (street no, street name, city). Q.5: There are many teachers in the university. Teacher has Id, name, salary. Among the teachers, Head of the department is appointed for a certain period of time (start date and end date). A teacher may be appointed Head many times. In different times, different teachers are appointed as Head. Q6: A club can have many players and a player can join only one club for a period of time with a start date and end date. After completion of period, the player can join another club. A club has id, name and date of establishment. A Player has id, p-name and date of birth. Q.7: A teacher can teach many courses and a course is taught by exactly one teacher. A teacher has id, name and degree. A course has course-id, title and credit. Q.8: All people working in an organization are called employees identified by employee id. All employees must have name, address, mobile and email. An employee must be one of the following: technical or non-technical. Technical employees have the trade and year of experience. Non-technical employees have highest degree and year of experience. Q.9: A person is described by id, name as first name, middle name, last name, multiple qualifications and trainings, present address (street no, street name, city) and permanent address (street no, street name, city). Q.10: There are many football teams participated in world cup 2018. A team has id and country. A team plays with another team in a particular date and a title of the play e.g., round 1, semifinal etc.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!