Hello, if you could help point me in the right direction for this table I would appreciate it.

- The rent amount for a lease depends on the length of the lease (6-month or 12 -month) and the apartment type being leased. - Rent amounts for apartment types/lease durations are updated periodically during the year, typically in March and/or September, although they can be updated at any time. It is important to keep a history of rent amounts for each apartment type/lease duration combination. - The last time rent amounts were updated was 3/1/2019. - Deposit amounts are determined by another system and stored in the Lease table. - The "Current?" field indicates if a particular lease is current on its rent. A lease is "current" if there is no rent money owed on the apartment as of the current date. Considering the notes, table design and sample data, address the following questions (be VERY specific in each answer): (a) In what normal form is the Lease table in? (worth 1pts ) (b) What violation(s), if any, is there of 1NF? (worth 2pts ) (c) What violation(s), if any, is there of 2NF? (worth 2pts ) (d) What violation(s), if any, is there of 3NF? (worth 2 pts) (e) On a separate page, show the results of normalizing the Lease table to 3NF. Use ONLY the columns depicted in the above table. Do a complete logical design including 3NF tables, all primary and foreign keys, referential integrity constraints, table names and sample data. Use Word, Excel, or Access to design the tables and document the rest of your logical design. Only tables in 3NF should be shown. (worth 33 pts)