Andrian Christian Paul 

BSEMC 2B

A. ENGAGE Activity 

1: Blogging 

A.WHAT IS A DATABASE? A database is an organized collection of structured information, or data, typically stored electronically in a computer system.

B.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? Spreadsheet Program

C.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Database Management System (DBMS)

D.THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL? MS Excel is a calculation program, access a programming program. Excel has many calculation ready built in a flexible sheet for naiv computer users, access needs programming experience. Excel is a spreadsheet that are used alot to financial data. Access is a database system.

 

B. EXPLORE & EXPLAIN Answer the following questions: 

1. What are the different components of dbms?

  • Storage engine.
  • Query language.
  • Query processor.
  • Optimization engine.
  • Metadata catalog.
  • Log manager.
  • Reporting and monitoring tools.
  • Data utilities.

2. What is the difference between data and information?  

Data is a collection of facts, while information puts those facts into context. While data is raw and unorganized, information is organized. Data points are individual and sometimes unrelated. Information maps out that data to provide a big-picture view of how it all fits together.

3. What is an overall system structure of a dbms? Query Processor, Storage Manager, and Disk Storage.

4. What are the different functions of dbms? concurrency, security, backup and recovery, integrity and data descriptions.

5. Who are the different users of dbms? DBMS users generally access the database; it just specifies the different accounts associated with the user. This may require access for the user, and they are the ones who can take advantage of accessing the database and its data.

Comments

Popular posts from this blog

Title: From Plan to Global: Building a Business That Works

ONLINE PORTFOLIO

GADIN - CASE ANALYSIS