e-STS : Search Here

Showing posts with label effective table maintenance. Show all posts
Showing posts with label effective table maintenance. Show all posts

Friday, May 12, 2023

Database Software Projects Development

Database Design in Software Development 

Database Management System 

The overall objective in the development of database technology has been to treat. Data as organizational resource and as an integrated whole database management system allow the data to be protected and organized separately from other resource. 

Centralized Access 

Database can be defined as “an integrated collection of data.” Database is a crucial factor in the performance of system both in term of system timings and in the case with which the system can be maintained or modified. If the data management software can provide centralized access to the data from the program, it is possible to treat the data as a separate recourse. 

Effective Table Maintenance 

All the information is properly normalized in separate table. The well-designed database is the need for the success of the project.  This is achieved during the manipulation and the placement of the fields in the particular table and handling them with constraint whenever needed. Care was taken that the table should not extend the optimum level for effective table maintenance. 

List of Database Software 

Database is a Place where a Data are stored in a Table. The following are the List of Database Software. 

  • MSSQL, 
  • SQL Plus, 
  • Oracle etc., 

Database Design in Software Development Projects

Example for Database Design in Software Project
 

Attendance Maintenance in a Company. 

In Company there are many Departments are Available. For Example Production Company. 

The following are the Departments are there, 

  • Human Resource Departments, 
  • Payroll Departments, 
  • Purchase Departments, 
  • Manufacturing Departments, 
  • Stock Maintenance Departments, 
  • Marketing Departments, 
  • Product Delivery Departments. 
  • Customer Support Departments. 

In all those Departments Employee Attendance Details have to Updated Frequently. 

  • Employee Details are, 
  • Employee Code or ID, 
  • Employee Name, 
  • Employee Department, 
  • Date and Time of Attendance. 

The attendance details are Stored in a Centralized Database with the Database Design. 

Centralized Database 

The Centralized Database is a Database Server where all Departments can update the data in the Centralized Database. The Data are updated in the Database and also Data are accessed in the Database. 

Database Design 

Database Table Design should have, 

  • Database Name, 
  • Table Name, 
  • Fieldname, 
  • Size of the Fieldname, 
  • Primary Key or Foreign Key Settings are given, 

The above shown Database Table Design for Employee Attendance are Created and used for every Department. So, Database Table Design are Created and Day to Day Employee Details are updated in the Software.

Database Data Maintenance 

Data which stored in the Centralized Database data are Maintained for further Usage for Day to Day Process, Monthly Process, Yearly Data Process etc.,

Most Recent