Databases are probably the most important aspect to this project because with multiple persons linked to multiple accounts and multiple places it is only necessary to have multiple "levels" or organization in order to maintain the proper systems and coding for everything.
I have noticed that many banks have extensive amounts of organization just within a branch. I am sure that the cel phone companies and internet providers have something similar in their databases.
When creating a database I will need to make sure that I do not overlap or rename things too many times because then the database will run into a system error when searching for something or trying to file something away.
This will cause the system to stop completely and then interrupt business.
In order to avoid problems and such, one will need to really create a database schema that will list and categorize each bank a person has, each account a person has in that bank, and whether it's a checking or savings account, then which card is used in what places.
This can be done by first creating a well organized schema, because my idea is very similar to google waller, I would bet that using their schema as an initial base would really be beneficial, then we can create a database with such tables as mentioned above that would then be categorized into attributes which will then be broken down to primary keys and then for foreign keys which will not only protect the users but keep everything organized as well.
No comments:
Post a Comment