Course Hero Logo

Acc 114 week 5 (2).pptx - File Management and Data...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 11 out of 49 pages.

File Management andData Communication.Module Three(Data, Information and Communication)ACC 114 Lecture Note week FiveDepartment of Accounting, Covenant University.
IntroductionFor any system or organization to functioneffectively, there is need foreach part to beable to communicate with every other partEvery organization should have a structureand it is expedient for information to flowsmoothly across the sub-systems.
Information SystemsInformation systems are viewed as means ofprocessing datathe routine fact and figures of organization areprocessed into information which is then usedfor decision making.
DatabaseDatabase is a collection of related data organized in a way that data can beeasily accessed, managed and updated. Any piece of information can be adata, for example name of your school.Database is actually a place where related piece of information is stored andvarious operations can be performed on it.Database is a collection of related data stored in several tables, and linkedthrough foreign keys.You can create and have several databases in a Database-product forinstance.
Database ManagementSystem (DBMS)A DBMS is a software that allows creation, definition andmanipulation of database.DBMS is actually a tool used to perform any kind ofoperation on data in database.DBMS also provides protection and security to database. Itmaintains data consistency in case of multiple users.ExamplesofpopularDBMSincludee.g.MySQL,PostgreSQL,MicrosoftAccess,SQLServer,FileMaker,Oracle, RDBMS, dBASE, Clipper, and FoxProetc.
Components of DBMSDBMS EngineData Definition LanguageData manipulation languageData Administration
How it worksApplication programs access the DBMS, while the DBMSaccess database for actual data.The access between the application programs and the DBMSis called the Logical Access Path (LAP), which shows thelogical view of data as perceived by application program.The access between the DBMS and database is called thePhysical Access Path (PAP), it shows the physical view ofdata as contained in the database.The Video Below Explains (PAP AND LAP)https://
DBMS EngineThe primary function of the engine is to provide a bridgebetweentheothercomponentsofDBMSandthedatabase.It offers a bridge for both the logical and physical data.Therefore the engine responds to specific commandsfrom users to create, read, update and generate reportfrom the database.
Data Definition LanguageThis is the formal language to define thestructure of each data element within thedatabase.Itdefinestherecordtypes,fieldsandrelationships within the database.
Data Manipulation LanguageThis is used by specialists to query the database forspecific data.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 49 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
NoProfessor
Tags
Relational model, Database management system, Information and Communication

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture