An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database. ERD often use symbols to represent three different types of information. Draw the ERD for the following scenario: (a) Each lecturer is identified by a uniqie number, name and phone. A lecturer teaches several courses and for each course there us a unique code and title. There might be several be several lecturers in a course. (b) A university where a student may take many courses employs lecturer. Each lecturer teach one or more course but no course is taught by more than one lecturer. Each student has to complete two or three assignments for each course. (c) A car rent company wishes to create a database about its activities. The company has a number of vehicles. Each vehicle is of certain model. A customer can rent only one vehicle at a time. Every vehicle must be checked by an employee to make sure it is in good condition.
Subject - Fundamentals to
Question 4
An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database. ERD often use symbols to represent three different types of information. Draw the ERD for the following scenario:
(a) Each lecturer is identified by a uniqie number, name and phone. A lecturer teaches several courses and for each course there us a unique code and title. There might be several be several lecturers in a course.
(b) A university where a student may take many courses employs lecturer. Each lecturer teach one or more course but no course is taught by more than one lecturer. Each student has to complete two or three assignments for each course.
(c) A car rent company wishes to create a database about its activities. The company has a number of vehicles. Each vehicle is of certain model. A customer can rent only one vehicle at a time. Every vehicle must be checked by an employee to make sure it is in good condition.
Step by step
Solved in 2 steps with 6 images
