Question

our company is creating the database for the sales system. These are the major components: Database design User entry form design Report design Access and authentication Maintenance You are assigned as an IT manager. For this Discussion, gather information from the library and research other web resources. Write a plan describing your role in designing, developing, managing, and supporting the database.

Answer 1

Database for sales system:

Role in Designing:

->First, Understand which type of system is required.

->List all entity, attribute and relation like customer, SalesPerson, Area etc.

-> Prepare E-R diagram

-> select which type of database is suitable according requirement sql or nosql

->According to development plateform(PHP,JAVA,Python) select database PostgreSQL, MySQL, MariaDB etc.

->Select where to store database cloud, local server etc. if cloud which cloud is suitable as per requirement.

Role in developing:

->Create Database according to E-R Diagram

->define attribute and its datatype

->select appropriate Primary key, Foreign Key and Constraint as per requirement.

->Create two node means copy or mirror of database so, If one node fail second run smoothly

Role in Managing:

-> Check Database is always up

->Changing Database structure as and when needed

-> Set Automatic and Manual backup daily or weekly or set PITR(Point in Time Recovery)

-> Checking continuously   for  security issue

->collect feedback from user and change as per feedback received.

Role in Supporting :

->Resolve Database issue as fast as we do

->Resolve error if occur

->Create manual , so Team can resolve issue as soon as possible