Using the STUDENT un-normalized table structure in the attached PDF filePreview the document, do the following: Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions. Draw the Crows Foot ERD using the results (Dependency diagram in 3NF).

STU-NUM STU-LNAME | STU-FNAME | MAJOR-CODE MAJOR NAME DEPT CODE DEPT NAME Computer Information Science Computer Information Science Electrical Engineering Technology Computer Information Science Business Management DEPT_PHONE ADVISOR LNAME ADVISOR_PHONECOURSE NO COURSE NAME STU GRADE 211343Gonzalez 00128 199876 198648 223456McKulski 197456 Stephanos CIS EET CIS Cloud Computing 4356 2134 4356 5670 4359 2139 4359 S679 4359 5679 4359 2139 4359 2139 S679 CIS126 Astor ENG110 PSY10 ENG110 Physics I English I Intro to Psychology English I Martin Business Management Business Management CIS 205734 206502 211343 199876 223456Mckulski David Computer Information Science Electrical Engineering Technology Computer Information Science Electrical Engineering Technology Business Management PSY106 Intro to Psychology 2134 Astor Gonzalez CIS ENG110 ENG110 ENG110 English I English I English I EET 2134 Astor Martin Business Management 5670