Please create a database for the following problem and please do it clearly and give me the mircosoft access database file.

Lab Exercises: 1. Create four tables for the VideoParlour database using Design view. The tables are Member to hold members details, Video to hold details of videos, VideoForRent to hold the details of copies of videos for rent, and Rental Agreement to hold the details of video rentals by members The Member table has the following fields (with the data type of each in brackets) memberNo (AutoNumber), Fname (Text), Lname (Text), gender (Text), DOB (Date/Time), address (Text), dateJoined (Date/Time), comments (Memo) The primary key is memberNo. (Also for this table, set the format property of the gender field to a field size of 1. Also, set this field with a Validation Rule -"M" or "F" and Validation Text Please enter M or F. If you do not understand the purpose of the properties associated with each field, Use the help facility using the F1 key) The Video table has the following fields (with the data type of each in brackets) catalogNo (Text), title (Text), category (Text), dailyRental (Currency), price (Currency), directorNo (Text) The primary key catalogNo The VideoForRent table has the following fields (with the data type of each in brackets): videoNo (Text), available (Yes/No), catalogNo (Text) The primary key is videoNo The RentalAgreement table has the following fields (with the data type of each in brackets): rentalNo (AutoNumber), dateOut (Date/Time), dateReturn (Date/Time), memberNo (Number), videoNo(Text) The primary key is rentalNo (Also for this table, set the format property for the dateOut and dateReturn fields to Medium Date format e.g. 10-Oct-00.) is catalogNo e following fields