Answer all three questions Please utilize following link for textbook (recommend downloading it): https://drive.google.com/file/d/16cV7PEVJbR6eqMqbd3Mm1DROHt4x-SYj/view?usp=sharing

Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this field that achieves the objectives outlined in this chapter for field coding.

Suppose you were designing a default value for the marriage status field in a student record at your university. What possible values would you consider and why? How would the default value change depend on other factors, such as type of student (undergraduate, graduate, professional)?

Transform the E-R diagram of Figure 7-20 (pg.254) from the textbook into a set of 3NF relations. Make up a primary key and one or more non-keys for each entity that does not already have them listed.