Posts

Showing posts from April, 2023

MODULE 1 ACTIVITY 1

Image
A. A database is an organized collection of structured data that is stored and managed in a computer system. It allows users to easily store, retrieve, manipulate and analyze large amounts of data. B. Microsoft Office Excel is spreadsheet software used for data analysis and management. It allows users to create and manipulate spreadsheets, perform calculations, create charts and graphs, and more. It is primarily used for numerical data analysis. C. Microsoft Office Access is a relational database management system (RDBMS) used to store and manage data. It allows users to create and manage databases, tables, queries, forms, reports, and more. It is primarily used for storing and managing large amounts of data. D. Two differences between Access and Excel are: Purpose: Excel is primarily used for numerical data analysis, while Access is used for storing and managing large amounts of data. Excel is ideal for performing calculations, creating charts, and analyzing data, while Access is idea

ACTIVITY TASK MODULE #3

Image
 Activity task module no.3 A Data Definition Language (DDL) is a language used to define and manipulate the structure of a database. DDL statements are used to create, modify, and delete database objects such as tables, indexes, views, and stored procedures. DDL commands typically include statements like CREATE, ALTER, and DROP, which are used to create, modify, and delete database objects, respectively. These statements allow users to define the characteristics of each object, such as its name, data type, length, and other attributes. An Interactive Data Manipulation Language (IDML) is a type of programming language that allows users to interactively manipulate data stored in a database. IDML provides a set of commands and syntax that can be used to query and modify the data in a database. Unlike DDL, which is used to define and manage the structure of a database, IDML is used to manipulate the data within that structure. An Embedded Data Manipulation Language (EDML) is a type of prog