Need help with question 4 part a,b, and c

4. Using the STUDENT table structure shown in Table P6.4, do the following: a. Write the relational schermat and draw irs dependency diagrami ldentify all dependencjes, including all eransitlve dependencies. a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. b. Write the relational schema and draw the dependency diagram to meer the 3NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate using a 2NT structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify atuributes to create appropriate determinants and to adhere to the naming conventions. c. Using the results of Problem. 4. draw the Crows Foot ERD. Note Although the completed student hours (STL HOURS do determine the student classification (STU_CLASS), this dependency is nos as obvious as you might initially assume it to be. For example, astudent is considered a junior if the student has completed between 61 and ge credit hour: decision to retain 2 NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions. c. Using the results of Problem 4, draw the Crow's Foot ERD. Note Although the completed student hours (STU_HOURS) do determine the student classification (STU_CLASS), this dependency is not as obvious as : you might initially assume it to be. For example, a student is considered a junior if the student has completed between 61 and 90 credit hours. 5. To keep track of otfice furniture, computers, printers, and other office equipment. the FOUNDIT Company uses the table structure shown in Table P6.5