DATABASE / EXCEL / ACCESS

-

 Blogpost #3

A. Engage

(a) What is a database?

- A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system.

(b) What type of software is Microsoft Office Excel?

- Microsoft Excel is a spreadsheet program that features calculation, graphic tools, pivot tables, and macro programming language support for Windows and Mac operating systems.

(c) What type of software is Microsoft Office Access?

- Microsoft Access is a database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

(d) Think of at least two differences between Access and Excel

Excel - Compared to Access the storage capacity is less since Excel is not build to store data.

Excel - flat and non-relational.

Access - Compared to Excel, the storage capacity is more since Access is mainly created for storing, sorting, and manipulating databases.

Access - Capable of building multiple relational models.


B. EXPLORE & EXPLAIN

1. What is information management?

- The collection and management of information from one or more sources, as well as the distribution of that information to one or more audiences, is referred to as information management.

2. What is a database?

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

3. What is a database management system?

- A database management system is a software package used to store, retrieve, query, and manage data. Authorized entities can create, read, update, and delete data using user interfaces.

4. What are the difference between RDBMS and NON-RDBMS?

- Relational databases store data in rows and columns like a spreadsheet while non-relational databases store data don't, using a storage model that is best suited for the type of data it's storing.

5. What is object-oriented database?

- object-oriented databases are databases that represent data in the form of objects and classes.


C. ELABORATE & EVALUATION

Microsoft Access 1. A Microsoft software product that is primarily a data management tool (database software). 

DBMS 2. Software package for defining and managing a database.

Entity-Relationship Model 3. Logical arrangement, independent table, 

relationship.

Microsoft Excel 4. Is a spreadsheet software program that is traditionally used to manage numerical information.

Database 5. A collection of information organized and presented to serve a specific purpose.



Comments

Post a Comment

Popular posts from this blog

XML | JSON | AJAX

-
Image
 Blogpost #6 A. Engage Instruction: Based on your own understanding, kindly define the following terminologies:  A.XML  XML is a language used for storing and moving data. It is based on tags that define different elements within a document, and these tags can be customized to suit specific requirements. XML enables developers to structure and organize data in a way that is suitable for their particular use case. B.JSON  JSON is an acronym for JavaScript Object Notation, which is a simple and lightweight data format that can be easily read and written by humans and machines. It is not tied to any specific programming language and is supported by many popular programming languages. The data in JSON is organized as key-value pairs, with the key being a string and the value being one of several data types. JSON objects are enclosed in curly braces, while arrays are enclosed in square brackets. C.AJAX AJAX stands for Asynchronous JavaScript and XML. It is a web development technique that
Read more

Function, Advantages, Disadvantages of DBMS

-
Image
 Blogpost #2 A. Engage (a) Functions of DBMS Data Definition -  The DBMS must be able to accept data definitions in source form and convert to the appropriate object form.  Data Manipulation -  The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. Data Security and Integrity - The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. Data Recovery and Concurrency -  The DBMS must have the capability of recover from or minimize the effects of a system crash. Data Dictionary -  The DBMS must provide a system database called the database dictionary. The Main function of a DBMS it organizes your database files and provides end users more access and control over their data.  (b) Advantages of DBMS DATA INTEGRITY  - Since a single copy of a particular data is stored in the database, you ca
Read more