1. Consider the E-R diagram below a. Transform this E-R diagram into a set of 3NF relations. b. State and justify all referential integrity rules for the 3NF relations you created in Problem and Exercise (a). c. In Problem and Exercise above, you developed integrated normalized relations. Choose primary keys for the files that would hold the data for these relations. Did you use attributes from the relations for primary keys or did you design new fields? Why or why not? 2. Review the guidelines for attaining usability of forms and reports in Table below. Consider an online form you might use to register a guest at a hotel. For each usability factor, list two examples of how this form could be designed to achieve that dimension of usability. Use examples other than those mentioned in Table below. Table: General Design Guidelines for Usability of Forms and Reports Usability Factor Guidelines for Achievement of Usability Consistent use of terminology, abbreviations, formatting, titles, and naviga Consistenc within and across outputs. Consistent response time each time a function y performed. Efficiency Ease Formatting should be designed with an understanding of the task being performed and the intended user. Text and data should be aligned and sor for efficient navigation and entry. Entry of data should be avoided where possible (e.g., computing rather than entering totals). Usability Factor Format Flexibility Guidelines for Achievement of Usability Outputs should be self-explanatory and not require users to remember information from prior outputs in order to complete tasks. Labels should b extensively used, and all scales and units of measure should be clearly indicated. Information format should be consistent between entry and display. Forma should distinguish each piece of data and highlight, not bury, important da Special symbols, such as decimal places, dollar signs, and signs, should b used as appropriate. Information should be viewed and retrieved in a manner most convenient the user. For example, users should be given options for the sequence in w to enter or view data and for use of shortcut keystrokes, and the system sh remember where the user stopped during the last use of the system. Running Head: 1 My personal tutor Name: Course: Tutor: Date: Hello, I have seen how the tutors are disappointing you and would want to be helping you directly in all your academic assignments, projects, proposals and thesis. Kindly send the work to me directly to tunyahelp@gmail.com and get quality work. Regards tunyahelp@gmail.com Prof. Antonio Klin