Build an Online Relational Database with Search and Download Functionality

Please view the attached project details and ensure you have the capability to complete this project before placing a bid. The attached project details contains additional project detail that are not listed below. Project Overview: We need a simple relational database developed that has search and download functionality. This database needs to be written in MySQL. This database needs to be built to accommodate a large number of user accounts. Searchable Relational Database Functionality: Our data is contained in 500+ CSV files totaling over 30 gigabytes in size. These files are updated monthly, so we need the ability to upload new files monthly into a folder that the database will automatically use for search queries. The format for all data is the same in every CSV file. There are over 50 columns (categories) of fixed-length data for each row. We need a search function that user accounts can use to search through all of the data at once. Admin accounts have the ability to select which search parameters each individual user account has access to, so one user account might only have access to two search parameters while another user account has access to every search parameter. At any time, admins accounts need to be able to update the parameters that any user account has access to. User’s accounts will have a limited number of download credits available per month, and this number will be different for all user accounts, so admin accounts need to be able to edit this number for any user account at any time (including when creating the user account). This number needs to reset every month, so if an account is created on the 5th of the month then the download credits will automatically reset on the 5th of the following month. Admin accounts need the ability to, at any time, modify which day of the month the download credits will reset for each individual user account. When a search is performed, the individual records (rows of data from the CSV files) won't be displayed. All that will be displayed is a count of how many records match the search query. Limit the amount of matching records to 1,000,000, so if a search is performed and there are more than 1,000,000 records then the database will automatically stop the search and display "1,000,000 Matching Records". Search results should display the number of matching records and the search parameters the user selected. After searching, users have the ability to download all of the records found, so if a user searches and finds 5,000 records then the user will be able to download all 5,000 records in a single CSV file. Each record counts towards the user's monthly download credit limit, so if a user has 5,000 download credits per month, and they download 4,000 records then they will have 1,000 remaining download credits until their download credit limit resets. The records that the user downloads will only contain the search parameters they have access to. For example, if a user only has access to 2 search parameters, then the records they download will only contain those 2 parameters (columns of data), and if a user has access to all search parameters then the records they download will contain all parameters (all columns of data). If a user doesn't have enough download credits to download all records found during their search, then they will only be able to download the amount of records that they have available. For example, if a user has 5,000 remaining download credits, and their search returned 10,000 records, then the user will only be able to download 5,000 records out of the 10,000 total records. When a user clicks the download button, they will be prompted to confirm that they want to download this data. This message should read, "Please confirm that you want to download this data. All downloads are final."