Assessment Case Section 1

Green Gate Apartments has come to NTF Inc., the company you work for, and you have been assigned to their account. Green Gate has seen an abuse of an apartment policy stating that each apartment may have no more than two cars without permission. Because of this they want an application that will track which cars in the parking lot are assigned to which apartment unit so that they can reference this information quickly.

Each apartment may have zero or more cars. You must track apartment numbers, the first and last name of tenants (the main lease signer), and cars tied to each unit. You should not limit the number of cars each unit may have in your application because Green Gate does have some exceptions to their policy, but they would like to be able to see a list of the cars and the unit they are assigned to. Your program should allow you to query a specific license plate (the state and the number) to see what apartment that car belongs to and what other cars (if any) are tied to that unit. You may add other functionality if you see fit.

Deliverables: sql file including data and structure, classes, working application, sequence diagram