The first step involves interviewing the shop manager to find out the number of services offered. Questioning is necessary to provide the researcher with the correct information that will be used to make the database.
The second step is to obtain a general description of the operations of the business. This has to be done to have more detailed information about the company. The inability to understand the report will result in little or frail ides that cannot be useful for the project.
Drawing a data flow diagram and system flowcharts is the third step. These are graphical representations that can be used to show the relationship between the system processes and the operations carried out by the firm.
Then, I will come up with a description of the system processes. It should be brief and precise in explaining while explaining the relationships between them. The link has to be based on the information provided on the flow diagrams and system flow charts.
The fifth step involves creating an ER diagrams’ conceptual model. The model is built using the graphical representations used to connect the relationship between the database and the information data collected. The descriptions have to be included in the conceptual model for easy comprehension.
Normalizing the conceptual model is the next course of action. The model has to be designed in a manner that reduces data redundancy. Not being able to normalize the tables means that the final database will be slow, repetitive, and inaccurate.
Step seven will include creating application programs. The application programs are necessary because they need to be used by the database end users.
Then, I will load the database. The process will ensure atomicity, durability, and consistency.
The final step encompasses loading the data in the database. The testing should be done to determine the effectiveness of the system and areas that need improvement. If the system encounters any problems, debugging will be done to prevent more errors in the database thus maintaining its effectiveness, for example, being used for record keeping.
In my final project, I created five tables to represent the: Department, Member, Member Position, Training, and Certification. The tables would help carry out normalizations since this is the most crucial step in ensuring that data is well organised for proficient and better data access. It is essential to have a reasonable number of tables because it decreases the probability of having irregularities such as data duplication, and ensuring that data modifications are done correctly. For that reason, table normalizations are good because it enables me to arrange data according to the type of information needed for the project. For example, in the Department and Member table, I would keep a record of the phone numbers and addresses of the individuals to ensure easy access. Also, I would have a separate table (column) and fill in information on the Credit Hours stored in them. In the Training and Certification tables, I would put in data to show the training hours for a course or certification. Using the tables would eliminate the ambiguity of having the hour data in two tables. Besides, the normalizing the records would make possible the indexing of the tables to ensure that the database is safe for entry by the users.
What’s more, the process makes updating the database for phone numbers, training numbers, and member addresses easy.
Additionally, it will make finding the members an easy task given that their contacts and addresses are available in the database. For instance, the Human Resource personnel can call or check on a member who has not reported to work to know the reasons for the absence, or they can use the contacts to email them work schedules and other essential business requirements. To conclude, it is significant to use the tables since they will be useful in data and record updates.
Do you need high quality Custom Essay Writing Services?