Question: We want to design a relational database schema to represent information about an internal training program of a large company Design an E-R diagram based

We want to design a relational database schema to represent information about an internal training program of a large company Design an E-R diagram based on the description given below: The database keeps information about every employee in the company -Each employee has a name and a unique employee number Each course of the training program has a unique course number and a name The courses are taught and taken by employees of the company A course can be offered many times. Each offering has an offering number, which is unique within each course, a day and time An offering is taught by exactly one employee The database stores the grades of employees who took courses Convert the E-R diagram to tables and identify the primary keys
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
