Entity Relationship Diagram and Database Design for Vehicles Service Management
Added on 2019-09-26
14 Pages3171 Words178 Views
|
|
|
Running Head : Car WorkshopCAR WORKSHOP[Document subtitle][DATE][COMPANY NAME][Company address]
1Car WorkshopTable of ContentsINTRODUCTION.....................................................................................................................................2FILE BASED APPROACH......................................................................................................................2COMPUTER BASED OR DATABASE APPROACH..................................................................................4EFFECTIVENESS OF DATABASE APPROACH............................................................................................5WEAKNESS OF FILE BASED APPROACH..................................................................................................7DATABASE TABLES.................................................................................................................................8ENTITY RELATION DIAGRAM................................................................................................................12REFERENCES........................................................................................................................................13
2Car WorkshopINTRODUCTIONThe car workshop is a viable business that is operated with the help of the employees that areworking there and the tools that are required by the employees. All the things in the workshop are managed with the help of the traditional file management system. This system alsoprovides the workshop a considerable growth. But nowadays computers are taking the placeof the file for storage mechanism and provide the considerable amount of security. In theworkshop, the number of employees and the workload is increasing day by day. To cope upwith the need for managing the data in the proper manner computer-based approach is chosenover the traditional approach. As computer-based approach is much better than filemanagement system. The computer-based approach is also known as database approach.FILE BASED APPROACHThe file-based system is also known as the traditional approach. In this approach, the flat filesare used as the storage medium for the data. These flat files are managed by the file systemwhich is controlled by the operating system’s control.To access the flat file, the application program must go through the file system. Followingdiagram shows the mechanism in flat files.
3Car WorkshopNow the question arises that how the data is stored in the flat files.The record is the term that is used for the data which is stored in the flat files. Records are thecombination of various fields such as pipe, comma, space, and special characters which areknown as delimiters. The special character is used to mark the end of the file or the end of therecords. By the use of the special character, it will be easy for someone to identify the end ofrecordsFor example: The records of employee are store in the file are represented as:Data are sequentially stored in the flat files. There are a lot of flat file files containing data inthe directory. Flat files are the unstructured files that are manipulated by the computersystem. The data that is stored in the file is also known as flat data. The files containing datacan be the text file, plain file, and binary file. To get the data from the file, the file must becompletely read by the memory to give the desired result. The file system is useful for smalland the simple database. Nowadays more sophisticated database is built which are notsuitable for the file management system. The sophisticated database is not meant for theflat files. As the increase in the demand of the data storage and its maintenance moresophisticated approach is required that provide the consistency among the data stored in
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents