Posts

All about DATA

Image
A. DATA DEFINITION LANGUAGE Data Definition Language (DDL) is a subset of SQL used to define and manage the structure of database objects, such as tables, indexes, and schemas, including creating, altering, and deleting these objects. B. INTERACTIVE DATA MANIPULATION LANGUAGE Interactive Data Manipulation Language (IDML) is a part of SQL that lets you interact with and manage the data in a database. It includes commands that allow you to retrieve data, add new data, change existing data, and remove data. The SELECT command is used to get data from the database, like asking the database a question and getting an answer back. The INSERT command adds new data into the database, similar to putting new information into a file. The UPDATE command changes existing data in the database, like editing a file to update some information. The DELETE command removes data from the database, similar to erasing information you no longer need. In essence, IDML is all about how you can work with the info...
Post a Comment
Read more

Introducing SQL

Image
What is SQL? SQL stands for Structured Query Language. It's a standard programming language used for managing and manipulating databases. With SQL, you can perform various tasks such as querying data, inserting new records, updating existing records, and deleting records from a table. Additionally, you can create and modify the structure of the database, including tables, indexes, and views. SQL is crucial for anyone who needs to interact with databases, like database administrators, developers, and data analysts.
Post a Comment
Read more

Introducing the Models

Image
  A. Information model The information model is a conceptual framework that represents how data is stored, processed, and communicated within a system or organization. It provides a structure for understanding how information is created, captured, stored, processed, and distributed. In simpler terms, think of it as a way to organize and describe how data flows and is managed in a particular context. The information model typically includes elements like data entities, relationships between them, and the rules governing the data. It helps in designing databases, information systems, and other structures that handle data. For example, in a university information model, you might have entities like "students," "courses," and "instructors," and relationships such as "enrollment" between students and courses. The information model would define how data about students, courses, and enrollments is structured and how it can be accessed and manipulated. B...
Post a Comment
Read more

Info details

Image
 C. ELABORATE & EVALUATION  Answer the following questions:  Identification Database Management System (DBMS) 1. An automated system for maintaining records.   File Manager (or Storage Manager within a DBMS) 2. Manages the allocation of disk storage space.   Data 3. Stored in a database is both integrated and share. End Users 4. Refers to the people whose jobs require access to the database system for querying, updating, and generating useful reports.   Query Processor 5. Translate statements in query language
Post a Comment
Read more

Components of database

Image
  1. What are the different components of dbms? A Database Management System (DBMS) typically consists of several components that work together to efficiently manage and organize data. The key components of a DBMS include: Database: Definition: The database is the collection of related data that is logically structured and stored in a specific format. It serves as the foundation for a DBMS. Data Dictionary: Definition: Also known as metadata, the data dictionary contains information about the database, including the structure of tables, relationships, constraints, and other details. It acts as a guide for the DBMS to understand and manage the data. Database Engine: Definition: The database engine is the core of the DBMS. It is responsible for processing queries, managing transactions, and ensuring data integrity. The engine interacts with the data stored in the database. Query Processor: Definition: The query processor interprets and executes queries written in a database query...
Post a Comment
Read more