Skip to main content

Posts

Showing posts with the label #database #sql #design #scripting

Database Design and development

Database Design For any business process where the data need to be stored for later analysis or just for maintaining inventory or record, one need to maintain the day to day transactional data management.  For small business any approach used will work, like maintaining sheets, or csv all will work, but for mid scale or large scale companies data management is important to be done in database, since data could be fetched from different sources sometime it could be any frontend website or it may be any mobile application or computer software etc. Management of these set of information in a structured or say tabular format is known as database management.  Basically it categories in two types relational database and nosql database. For relational database software used are like SQL server, oracledb, azureSQl, MySQL etc. For nosql database we have format files file json or XML etc. Generally relational database management system is something which is widely used because of its re...