SmartPark is a web application for users to pay for their cars parking easily on mobile devices and computers. The system can be accessed on both mobile devices and personal computers via user-friendly responsive interfaces. SmartPark provides a better way to avoid parking fines, overpaying for parking and frustration users experience with coins or parking meters. The main features of SmartPark are described below:

• Register. A new user can create an account of SmartPark by clicking the register link on SmartPark website, and then filling in the registration form providing an email address, password, mobile phone number, bank or credit card number, and cars registration number.
• Login. An existing user can login the system using email or phone number, and password.
• Start Parking. After login, a user can start a parking session by simply clicking the StartParking button, then enter the parking time (e.g., 1 hour or 2 hours), and the area code of the car park (e.g., 30810), in a form provided by the system. After the user clicks the submit button of the form, a new record of parking history will be created including start time of parking, parking time, area code, and the record will be stored in the database of SmartPark.
• Stop Parking. After a parking session is started, a user can stop the parking anytime during the parking time when they exit the car park earlier to avoid overpaying parking fees. Stop parking is carried out by clicking the StopParking button, which is being displayed after a parking session is started. After stopping parking, the record of this parking session will be updated with a stop timestamp and the parking time, and is saved in the database.
• Send Receipt. Staff of SmartPark company will send receipts to users via emails monthly. A receipt contains details of a users parking history and payment in a month.

You are required to design a database to store the necessary information and support the implementation of the features.

Answer the following questions:

1. Identify the entities, or tables, in this scenario and for each entity identify the primary key and the foreign key(s) if there are any (4 marks)

2. Draw the Entity Relationship Diagram (ERD), giving connectivity and cardinality (8 marks)

3. Write the relational schema. (8 marks)