Differences And Disadvantages Of The Evolution Of Database Management Systems

The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal

Storing information is essential for many reasons; these include easy access and changing readability for all reading levels, the level of detail you are able to store, the choice to have various copies of the information in case of loss and ease of transfer.

like an address book can also be considered as relevant filing system, because its not on a database

Q1: How is a file processing system or spreadsheet different to a database system? What disadvantages does the database approach address.

The main purpose of storing any information is for easy retrieval in the future when it is required. It is also part of a company’s business practice. Storing documents have to be done in proper procedure so that it is easier to find. Depending on the type of information, information can be stored in either fireproof cabinets for hard copies or hard disks or other electronic storage devices for soft copies.

Some of the benefits of electronically storing are that you can store vast amounts of information in a very small space, you can reproduce and disseminate this information at great speed, documents are easy to modify. Documents can also be searched for easily, and it is hard for the documents to go missing.

The electronic database is a collection of information that is organised so this can be easily accessed, managed and updated. It is a collection of reports, tables, queries and reviews. This can be in the form of titles or subject for instance personal or involvements. Category or reference number and you can store a wide range of information by collating information alphabetically, numerical and chronological.

The system must be easily understood to others who may need access; creating only the records that are necessary, using a sensible and logical naming system, keeping the files and records up to date by sorting them regularly are ways to keep the system productive, simple and efficient. Faster filing and retrieval,

Dramatically reduce cost, effort and accuracy associated with entering, gathering and disseminating information by storing everything electronically in a central database.

This is inefficient as the forms are sorted, scanned and manually placed in the paper file. This is not only inefficient, it is time consuming. Additionally, due to limitations of the software, all electronically received forms are printed, scanned into the electronic file and placed into the paper copy file. Again, causing redundancy and creating additional work.

Hard Copies – hard copies are paper copies of documents. These can be stored in filing cabinets or for larger companies, in their storage facilities. Paper copies may be archived in folders and sorted into an order using dividers. This may be simple when storing a small amount of information or when keeping important documents (e.g. with a wet signature), however this may be impractical if you have a vast amount of documents as a lot of storage space would be needed. It may also be difficult to locate certain documents if you have most of your files stored as hard copies as you will have to spend time going through folders to find the correct file. This is a common way of storing some company data, however

2. Computerised System: The benefits of a computerised filing system are numerous, and include reduced costs to the company, benefits to the environment, increased ease of sorting, finding, and moving documents. Another benefit is that it allows the office to operate in a smaller area.

Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.

“A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able to store all the records necessary for the business to function as well as be able to get all of this information back in case of a system failure or a crash. If all the information is loss a business could go bankrupt so the database is a fail

Before 1950s data was stored in paper records and there were lot of disadvantages in it such as lot of man power was needed lot of time was wasted also data would be destroyed easily cause of natural causes such as floods animal etc. Also lot of maintenance was needed on these paper works. Later computers were used for data storage stil the file system continued. Next came the age of DBMS.