Question: Begin to create a database for MOOC High by following instructions a) through d) below. List all of the fields on the form. Group together

Begin to create a database for MOOC High by following instructions a) through d) below. List all of the fields on the form. Group together fields that seem to be related to a single entity, and identify a primary key for that entity. Make a note of leftover fields that you don't seem to belong with any of these entities. For the entities you are able to identify, consider whether there are relationships between the entities and whether those relationships are one-to-many or many-to-many. For one-to-many relationships, create a relationship between the files by adding the primary key of the 'one' file to the 'many file. For many-to-many relationships, create a new file that contains the primary keys of both 'many' files. Put any leftover fields into one of the files you have identified in b:, Prepare a set of normalized data files to store the recommended schedule data. Show your solution using a diagram similar to the one found below
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
