Reference the database design from the 3rd Normal step (last step) of the document named 'Normalization Example 1'.
A) Create an ERD using a tool within MS Access, defining Entities, Relationships between Entities, and Identifiers for each Entity only for the 3NF step of 'Normalization Example 1'.
B) Specify the database design using the Relational Notation method only for the 3NF step of 'Normalization Example 1' - use Word or Excel.
C) Tell me what we call the 3rd design method which is depicted in the starting point 'Normalization Example 1' file - hint: initials of this method start with D.P.
52 THIRD NORMAL FORM (3NF)
53 Apply Rules to the 2NF data to arrive at Third Normal Form
54 - Remove all columns which depend on non-key column, put in new table, use keys to link tables (also remove calculated columns)
55
56 TABLE: STUDENT COURSE
TABLE: STUDENT
57 Primary Key PK Student Course ID|Grade Student First Last Phone
58 ID ID Name Name 1234|CIS111 4 1234|Mike Jones 440.55
59 5.1234 1234|CIS222 3 4321|Anne Davis 440.55
60 5.4321
61 1234|ACT101 4
62 1234|PHY101 3
63 4321|CIS111 4
64 4321|CIS344 4
65 TABLE: COURSE
66 PK Course Title Hours Teacher
67 ID ID
68 TABLE: TEACHER
CIS111 Intro to SQL 4 333
CIS222 Data 4 444
69 PK Structures Teacher Teacher ACT101 Cost 4 123
70 ID Name Accounting
71 333|Smith PHY101 Racquetball 4 999
72 444|Burton CIS344 Web 4 455
73 Developme
74 123|Davis
75 999|Miller
76 455|Potter