Data management
Download as pptx, pdf0 likes268 views
This document discusses database management concepts. It defines key terms like bit, byte, field, record, and file. It describes different data types that can be stored in a database like text, images, audio. It explains different file organizations like sequential, indexed sequential and direct file. It provides examples of how data from different departments can be organized into master files and transaction files in a database using a DBMS. Records from employee and salesman tables are shown to illustrate how data is stored and accessed.
Data management
- 3. Database and Day-to-Day Life
- 4. Database and Day-to-Day Life
- 5. Database and Day-to-Day Life
- 6. Database and Day-to-Day Life
- 7. Concept
- 8. Bit binary digit 0 1 Byte bit bit 1 byte bit 8 bit 1 Field 1 Record Field File Record
- 9. Field Record File
- 10. Data Type Text Formatted data LSIT3502 Images Suttida.jpg Audio/ sound Suttida.mp4
- 11. Master File Transaction File
- 13. indexed or Direct file organizations Direct access Index) Indexed Sequential Access Method (ISAM) 1.
- 15. Emp001 Pichai Bangkok 12/03/2510 30000 Sales 083-2981904 Emp002 Somsri Chiangmai 20/02/2520 18500 Accounting 089-8881450 : Employees Emp001 Pichai Robinson, CM 083-2981904 Emp002 Somsri Big C, Hangdong 089-8881450 : Salesman
- 17. Database -Customers Personnel department - Product -Inventory DBMS - Sales - Employees Sales department -Agent Accounting department
- 18. DBMS Emp001 Pichai Bangkok 12/03/2510 Robinson, CM 30000 Sales 083-2981904 Emp002 Somsri Chiangmai 20/02/2520 Big C, Hangdong 18500 Accounting 089-8881450 1. 1. 2. 3. 4. 2. 5. 3. 6. 4. 5.
- 19. Assignment1 nwongyai@gmail.com DBAssignment1_5XXXXXXX PDF