MIDTERM - LABORATORY ACTIVITY TASK MODULE 1
A. Engage
A. What is a Database?
A database management system (DBMS) is a software-defined system that manages databases, in contrast to database administration, which refers to a set of best practices. Microsoft Access and FileMaker Pro are two common database management programs. Users in this system are in charge of the data in a database and have the ability to read, change, create, and remove data as necessary. A database management system functions as an interface, giving end users access to their databases and allowing them to arrange and access the data as needed.
It is in charge of looking after the data, the engine that enables users to access the data inside the database, and what is referred to as the database schema, or the database's organizational structure. A DBMS together provides security and guarantees data integrity, but some systems are also used to provide automated rollbacks and restart, log, and audit database activities.
Microsoft Excel is a spreadsheet program that was introduced by the Microsoft Corporation in 1985. In the widely used spreadsheet program Excel, data is arranged in columns and rows that may be changed using formulae, which let the computer execute mathematical operations on the data.
A grid of cells is used to organize data processes like arithmetic calculations, with numbered rows and letter-named columns. It has a variety of built-in functionalities to address financial, engineering, and statistical requirements. Also, it has a very limited three-dimensional graphical display and can present data as line graphs, histograms, and charts.
Microsoft Access is a database management system (DBMS) that combines a graphical user interface and software development tools with the relational Microsoft Jet Database Engine. The professional and higher editions of Microsoft Office include it as part of their suite of programs.
B. What Type of Software is Microsoft Office Excel?
Microsoft Excel is a spreadsheet program that was introduced by the Microsoft Corporation in 1985. In the widely used spreadsheet program Excel, data is arranged in columns and rows that may be changed using formulae, which let the computer execute mathematical operations on the data.
A grid of cells is used to organize data processes like arithmetic calculations, with numbered rows and letter-named columns. It has a variety of built-in functionalities to address financial, engineering, and statistical requirements. Also, it has a very limited three-dimensional graphical display and can present data as line graphs, histograms, and charts.
C. What Type of Software is Microsoft Office Access?
Microsoft Access is a database management system (DBMS) that combines a graphical user interface and software development tools with the relational Microsoft Jet Database Engine. The professional and higher editions of Microsoft Office include it as part of their suite of programs.
D. Think of At Least Two Differences Between Access and Excel
1. Microsoft Excel :
2. Microsoft Access :
Answer the following questions:
1. What is Information management?
Information management (IM) is the process of gathering, organizing, and distributing data
from a variety of sources to a variety of audiences. Sometimes, persons with an interest in or
a claim to the information are involved. Information management refers to the planning and
control of the information's structure, processing, and distribution.
2. What is a database?
In the form of a file or group of files, a database is kept. The data included in these files can
be divided up into records, each of which has one or more fields. The basic units of data
storage are fields, and each field typically contains data related to one feature or attribute of
the thing that the database is used to represent. Moreover, information on the connections
between the records' various fields is included in tables that organize the data. Even while the
term "database" is generally used to refer to any collection of data stored in computer files,
strict definition of a database includes cross-referencing capabilities. Users can quickly
search, rearrange, organize, and choose the fields in several records to access or create
reports on certain aggregates of data using keywords and a variety of sorting instructions.
3. What is database management system?
Software called a database management system (DBMS) is used to store and retrieve user
data while taking proper security precautions. It consists of a number of applications that
manipulate the database. The DBMS accepts the application's request for data and inform
the operating system to give the requested data. A DBMS aids users and other third-party
applications in storing and retrieving data in complex systems. Users of DBMSs can design
their own databases in accordance with their needs. The user of the database and other
application applications are included in the definition of "DBMS." It acts as an interface
between the data and the software program.
1. Microsoft Excel :
- You can even add any charts, graphics, etc. to make it more presentable.
- Excel locks the whole spreadsheet once it is accessed.
- Making other people unable to edit other entries or even to add new ones.
2. Microsoft Access :
- Access is designed to have multiple users working in the same DB files along with the various safety precautions items to help protect the data such as record level locking.
- The database created in Access is saved with a .mdb extension.
- Each field of a table can be associated with certain constraints like only allowing an alphanumeric value.
Answer the following questions:
1. What is Information management?
Information management (IM) is the process of gathering, organizing, and distributing data
from a variety of sources to a variety of audiences. Sometimes, persons with an interest in or
a claim to the information are involved. Information management refers to the planning and
control of the information's structure, processing, and distribution.
2. What is a database?
In the form of a file or group of files, a database is kept. The data included in these files can
be divided up into records, each of which has one or more fields. The basic units of data
storage are fields, and each field typically contains data related to one feature or attribute of
the thing that the database is used to represent. Moreover, information on the connections
between the records' various fields is included in tables that organize the data. Even while the
term "database" is generally used to refer to any collection of data stored in computer files,
strict definition of a database includes cross-referencing capabilities. Users can quickly
search, rearrange, organize, and choose the fields in several records to access or create
reports on certain aggregates of data using keywords and a variety of sorting instructions.
3. What is database management system?
Software called a database management system (DBMS) is used to store and retrieve user
data while taking proper security precautions. It consists of a number of applications that
manipulate the database. The DBMS accepts the application's request for data and inform
the operating system to give the requested data. A DBMS aids users and other third-party
applications in storing and retrieving data in complex systems. Users of DBMSs can design
their own databases in accordance with their needs. The user of the database and other
application applications are included in the definition of "DBMS." It acts as an interface
between the data and the software program.
4. What are the difference between RDBMS and NON-RDBMS?
The main difference between relational and non-relational databases is the way that data is
stored. Relational databases use tables to store data, while non-relational databases use a
hierarchical structure. This makes relational databases easier to use and understand, while
non-relational databases are better suited for managing complex data.
5. What is object-oriented database?
Object-oriented databases are a type of database management system. Different database
management systems provide additional functionalities. Object-oriented databases add the
database functionality to object programming languages, creating more manageable code
bases.
C. ELABORATE & EVALUATION
Answer the following questions: Identification
The main difference between relational and non-relational databases is the way that data is
stored. Relational databases use tables to store data, while non-relational databases use a
hierarchical structure. This makes relational databases easier to use and understand, while
non-relational databases are better suited for managing complex data.
5. What is object-oriented database?
Object-oriented databases are a type of database management system. Different database
management systems provide additional functionalities. Object-oriented databases add the
database functionality to object programming languages, creating more manageable code
bases.
C. ELABORATE & EVALUATION
Answer the following questions: Identification
_____Microsoft Access______1. A Microsoft software product that is primarily a
data management tool (database software).
__Database management system (DBMS)___2. Software package for defining and managing a database.
______Relational Data Mode______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