Fordley Car Park is open between 7am and 9pm every day. They charge £2.30 per hour with a minimum fee of one hour and a £2 overnight charge for stays between 9pm and 7.30am.

Payments are made at the end of a visit. The car park is also used by resident and business permit holders on the basis of annually renewable membership.

All new memberships are registered via the Fordley Car Park website or by completing a form which can be picked up from the car park attendant. Recently Fordley has invested in a paperless attended smart parking system that scans car registration numbers as cars drive through the entrance gate.

To ensure that a reading has been captured, the gates only open when a valid registration is read. Exit gates also have a camera which scans the car registration number and will open automatically unless payments are outstanding in which case the payment can be made at the attendant kiosk without leaving the car.

Members whose membership has expired can also pay for the visit or the full renewal fee at this point. Each member has a 7-character Membership Code used as a unique identifier and can register up to three cars.

Only one of these cars is permitted to use the car park at a time. The registration form includes the following details for each car: Car Registration Number + Make + Model + Date and Time Registered Car Park Usage Data recorded by the smart system is as follows: Car Registration + Arrival and Departure Date and Time + [Payment Made]

At each visit, Member details are automatically assigned based on the Car Registration Number with non-member visits assigned to member code ZZZ999. Attendant details are based on linking the Exit Date and Time to the attendant shift clock in. In addition to Car Details, Member details captured by the Registration Form are as follows: Member Code + Member Name + Member Address + Membership Start Date + [Member Email] + [Member Phone 1] + [Member Phone 2] + Membership Payment

The records also keep track of Membership Renewal Dates and Times which also include any updates (removal or addition) to registered cars. Attendant details include: Company Email Address used as a unique identifier for the attendant + Attendant Home Address + [Attendant Home Phone Number] + [Attendant Cellphone/Mobile Number] Attendant Shift records include a Date and a Time.

Attendant Shift records include a Date and a Time.

End user development. It has been suggested that an internal Microsoft Access database may be created to handle membership, dynamically interact with the parking system, and generate management reports.

The Senior Administrator who is in charge of creating and maintaining the suggested system has invited you to serve in that capacity. The administrator is knowledgeable about Microsoft Office suites.

Need help for these questions. I am lacking points to include in these questions, can someone help.

a) Make at least FIVE (5) recommendations as to how you would ensure success of this end-user development including support and measures required from Fordley throughout the different stages of the development life cycle.

b) Investigate the advantages and disadvantages of using Microsoft Access as a product. After your investigation, consider ONE (1) alternative solution that Fordley could use instead of using Microsoft Access. Having identified an alternative, compare it to Microsoft Access. The comparison must include costs.

c) Produce a conceptual diagram illustrating the different data tables you would create and showing key fields and relationships if you were to use Microsoft Access to capture the data described in the car park scenario. There is no need to provide detailed field properties descriptions at this stage