The following information is provided for the ABCeLearn training organization that hires instructors to provide training on various topics for clients in different regions. ABCeLearn wants to create a database schema based on the following information.
1.ABCeLearn is a training organization with many clients for whom they provide training courses.
2.ABCeLearn contracts may require more than one instructor and several different topics.
3.Each client is in one region of the country and a region can have many clients.
4.ABCeLearn also hires instructors to teach the courses.
5.The instructors are also in one region and each region can have many instructors.
6.ABCeLearn provides training on many different topics and instructors may have expertise in many different topics as well.
Initial Spreadsheet Table
(ClientNum, ClientName, ClientRegion, ContractNum, ContractDate, ContractAmt, Topic1, Topic2, Topic3, Topic4, InstructorNum1, InstructorName1, InstructorRegion1, InstructorTopic1, InstructorNum2, InstructorName2, InstructorRegion2, InstructorTopic2)
Convert the above table to 3NF relations and complete the functional dependency analysis. Indicate the PKs and FKs. Include the following sections in your document:
1.Analysis (includes a description of your work and any changes)
2.1NF and Functional Dependency Analysis
3.2NF and Functional Dependency Analysis
4.3NF and Functional Dependency Analysis
5.DBDL for the 3NF relations
6.High level ER diagram (just the entity types, relationships, and cardinality constraints)