database design questions
Posted on 2014-09-13
I'm working on designing a new database for a web application that accepts online credit card applications from businesses. I have put together the following series of questions during the design phase:
•Do you have any Regulatory requirements for data access and storage (Sarbanes-Oxley and HIPAA come to mind)?
•Do you need to be able to audit record changes?
•What internal controls do you need reflected in the database?
•What business rules must be followed under what circumstances?
•How large to you expect the data to get?
•How flexible do you want the system to be (do you want to be able to add columns on the fly? OR add business rules)?
•Do you need a separate data warehouse for reporting?
•How do you need the data populated? Will it come from an application, multiple applications, data imports or a combination?
•What databases do you currently have license for? Already know this one...Sql Server 2012.
•Will different groups of users need different accesses?
•How is the process currently being handled? I believe the current process is handled manually.
•Do you need to migrate data from the old system? Also, I believe the answer is no for this one?
I was interested in any additional feedback on other questions I should consider?
Thanks in advance for any help!