A training providing institute is offering training courses to their clients. A database system is needed to register the trainees in these courses. The data requirements for the system are given as follows:
• The company has many teachers. Each teacher has a unique id, name, date of birth, address (house number, street name, city, state), and may have several phone numbers.
o A teacher may teach many courses.
o We keep track of the number that a teacher has taught a course.
• The institute offers many courses to their clients. Each course has unique id, course name, start date, end date, and course language.
o The course language is either English or Arabic.
o We keep track of the fee of each offered course.
o One or more courses is offered to a client.
• There are many clients. Each client is identified by unique id, client name, address, contact person, and contact person name.
• Trainees works for a client. Each trainee has a trainee id, first name, last name, and a phone number.
o Trainees may take several courses. o We keep track of the fee of the taken course by a trainee.
Design a database starting from the conceptual design to the implementation of database schemas.
Create EntityRelationship model, Relational model, and write SQL queries.
