Please create an Entity Relationship Diagram that meets the following requirements

Business Rules and User Requirements

Business Rules: 1. There are several parking lots on campus.

2. There are several types of lots free, permit, short term, 24-hour restricted, after hours, visitor.

3. Each lot is identified by a lot number and has a location name and address. Each lot has a space number (number of cars that can be parked).

4. The space utilization for each lot is monitored each weekday from 8 AM to 5 PM.

5. A lot can be a different type at different times: For example, lot number 4 (Student Rec Center) is a short term paid lot from 8 AM to 4 PM on weekdays (M, T, W, H, F) at an hourly rate of $1.25 with a space count of 225. After 4 PM and on weekends (Sa, Su), lot number 4 is free.

6. Each WVU employee is assigned a permit to park in a specific lot for a given year (from January 1 to December 31 of each year). These are the permit parking lots.

7. The yearly permit price varies depending on the type (Gravel, Paved, Parking Area) and location (Downtown, Health Sciences) of the parking lot.

8. Employee payment history on permits is maintained.

9. If an employee moves to a different department in another part of campus, that employee could be assigned a different parking lot.

10. Each permit parking lot could have several employees assigned to park in that lot.

11. For each WVU employee, his / her name, email, phone number, and department address have to be maintained.

12. In addition, university visitors can be provided visitor permits to park in permit lots. Visitors need to provide their names, email, phone number and the address of the department they are visiting.

13. Each employee is allowed to register a maximum of three vehicles to park in his / her permitted parking lot.

14. The same vehicle can be registered by two employees (for example, a married couple working in two different locations on campus who might share / exchange vehicles).

15. Vehicles are identified by VIN and need to include a license plate number, make, model and color.

16. Parking citations (each citation has a specific number) can occur for several reasons and the fees vary (the following are some examples): a. Parking in Areas Not Allowed by Permit: $20 per citation b. Improperly Displayed Permit: $3 per citation c. Parking in an ADA Space without a Valid Permit: $200 First Offense

17. Each parking citation is for one vehicle.

18. Each vehicle could receive several citations.

19. The payment history for citations for each vehicle needs to be maintained (amount of each citation and whether it was paid).

User Stories: There are three types of users: Parking employees, WVU employees, Visitors

Name: Determine Parking Utilization As a parking employee I want to know how many spaces are assigned to employees in a parking lot So that I can find if spaces are available for employees who need them (who work in a nearby office / department). Acceptance Criteria: 1. Need to be able to search by lot number, location. 2. Need to show lot number, location, number of spaces available

Name: Assign Parking Space to Employee As a parking employee I need to assign a parking space in a parking lot to an employee So that the employee has a space to park. Acceptance Criteria: 1. Parking lot should have available space. 2. Employee should not have any unpaid citations. 3. As soon as the assignment is made, the number of available spaces should be reduced by one.

Name: Find Citations As a WVU employee I want to know if I have any citations So that I can pay them. Acceptance Criteria: 1. Need to be able to search by vehicle, citation type and date range 2. Need to show citation date, type, location, amount and payment status (paid or unpaid) Name: Pay Citations As a WVU employee I need to be able to pay one or more of my citations So that I can renew my permit. Acceptance Criteria: 1. Need to be able to select unpaid citations. 2. Need to see the total amount to be paid. 3. Need to be able to provide a payment method for that amount. 4. Need to get a payment receipt listing date, the citation(s) and amount paid.

Name: Find Visitor Parking Location As a visitor I need to know which lot and location I have been given a permit to park So that I am not given a citation. Acceptance Criteria: 1. Need to be able to search using visitor permit number and visitor name. 2. Need to see the date, start and end times, lot number, location and address.