Answered You can hire a professional tutor to get the answer.
i need to create 3 specific tables The first table named Faculty to store EMPLID, first name, last name, email, and year of birth and date of hire.
I need some help with My MySQL project. i need to create 3 specific tables
The first table named Faculty to store EMPLID, first name, last name, email, and year of birth and date of hire. I should set appropriate data types, sizes and constraints for the table.
the second table named Courses will store CourseID, the discipline name, course name, number of credits, date first offered and course title. i should select the appropriate data types, sizes and constraints for the table.
the third table named FacultyCourses will store the Faculty and the Courses they have taught. I should design this table based on the Faculty and Courses tables that were previously made. I should use Primary and Foreign Key relationships properly.
i have tried to make the third table but always get an error saying the ERROR 1215 (HY000): Cannot add foreign key constraint. I would appreciate any help
