database design
Budget: ₹1,500 – ₹12,500 INR
create a database to store all static information of all available credit cards in India. Attachment has sample card details available for HDFC Regalia card.
From the card details, I want to fetch how many domestic lounges I can visit this year, how many I have already availed (user input), or how many reward points I will get for shopping on a particular website on a particular day. (more reward points on shopping on partner website, or on Birthday etc.)
DB should be designed in such a way that I must be able to fetch the details by API Call/DB query and do calculations based on those inputs. For instance, I must be able to calculate that if I book ticket in bookmyshow (partner brand), I will get 10x reward, i.e., 20 points per Rs.150, and check if I shop for Rs.10,000, if my maximum reward capping will be exceeded.
From the card details, I want to fetch how many domestic lounges I can visit this year, how many I have already availed (user input), or how many reward points I will get for shopping on a particular website on a particular day. (more reward points on shopping on partner website, or on Birthday etc.)
DB should be designed in such a way that I must be able to fetch the details by API Call/DB query and do calculations based on those inputs. For instance, I must be able to calculate that if I book ticket in bookmyshow (partner brand), I will get 10x reward, i.e., 20 points per Rs.150, and check if I shop for Rs.10,000, if my maximum reward capping will be exceeded.