Ask a question to Desklib · AI bot


Purpose of Developing Database of Company

2 Pages540 Words297 Views

Added on  2019-09-18

BookmarkShareRelated Documents
The main purpose of developing database of a company is to keep the record of the company’s employee and their respective activities. The structure of database that I choose to create is that there will be table of employee in which all the personal detail of the employee kept, there will beanother table named as department in which there is a list of all the department exist in the company along with its department ID and the reference of department ID passes into the table employee to know that which employee works in which department. There should be another tablenamed as employee leaves which will kept the record of employee leaves, in this we place data as leave date and the ID of employee to track that which employee was on leave along with date this will help the HR department to track the details of leaves for each employee. There should be another table named as project in that table we will keep the record of the project handled by company and there will be reference of employee IDin this table to see which employee are doing this project.There are multiple factors that will judge my database system, I will mention some of the points and discuss weather my database is up to the mark on this point or not. First factor will be the performance of the database and as you know that database system is always fast if compare to the manual recording of data, as well fetching data is much more faster than manual fetching and fetching the complex data is only possible in computer database system. In terms of scalability of database the database of a company always not too big because there will be limited number of activities that in a company done and this database can be altered according to the requirement. We can divide the whole database system development into 2 phase that are development and maintenance so there will be two phases in which owner have to pay, while developing costs much higher than the maintenance but it spend only one time. Security of the database handled by the developer so for me I will develop a module by which only authorized person can access the database with entering the valid credentials, so by this it will be very much secured. The whole system is to help the user and being developed by the database administrator and the developer, to handle the whole system there are many tools are available to ease the function of developer as well as the user because by the help of these tool sets development of the database
Purpose of Developing Database of Company_1

Found this document preview useful?

Related Documents
The Business Analytics Programming

System software Assignment

employee personal information PDF

ITS 631 – Operational Excellence

Student Name Student ID.

Database Design for Beauty and Nails Company