Home /
Expert Answers /
Computer Science /
draw-the-erd-design-an-erd-for-training-center-considering-the-following-business-rules-each-cou-pa576
(Solved): draw the ERD Design an ERD for Training center considering the following business rules: - Each cou ...
draw the ERD
Design an ERD for Training center considering the following business rules: - Each course can be taken by zero or many trainees, and the trainee can take more than one training courses. - The system must keep track of course (CourseID CourseName CorseDese), Trainee (TDa TAlame Email, MobileNl DOB, Age). - and for those trainee whose take courses must keep track of (Duration, Price, SDate). - Email in trainee is unique attribute. - Age value depends on DOB value. - The Course must belong to at least one category, and the category may or may not have courses belong to it. - The System must keep track of trainers (TrID, TrName, Skills, Mobile, Certificates), skills and certificates are multi-valued attributes. - Each trainer can train zero or many courses, and the course can be trained by one or more trainers. After Designing the ERD, draw the schema, and give samples of resulted tables (Not more than 4 records for each table).