Break the Code

SQL Components          SQL is a comprehensive language that has its own DDL and DML components:     DATA DEFINITION LANGUAGE Data Definition Language is used to create, design, define schemes, or set up your desired database structure.     INTERACTIVE DATA MANIPULATION LANGUAGE  Interactive Data Manipulating Language is used for interacting or manipulating your data in your database. It allows you to do certain operation and these are insert new data, delete existing data, or update your data.     EMBEDDED DATA MANIPULATION LANGUAGE Embedded Data Manipulation Language is like a helpful translator that translate our programming languages to an SQL command in order for our program to be executed.               

A. FUNCTIONS OF DBMS     The Database Management System has a lot of functions namely: DATA DEFINITION The DBMS handles how to organize and manage data, including defining the structure and format of a data. DATA MANIPULATION The DBMS handles users request and allows users to interact with the database. This includes retrieving and updating data DATA SECURITY AND INTEGRETY The DBMS enforces security measures to ensure that only the authorized users have the access to the data. DATA RECOVERY AND CONSISTENCY In case of technical problems or crashes the DBMS must be able to recover the lost data.  Concurrency management allows multiple users accessing and modifying  data simultaneously without any conflict.   DATA DICTIONARY Provides a list or description about your data, Which helps the users to easily define the data.   B. ADVANTAGES OF DBMS  REDUCED DATA REDUNDANCY  The DBMS avoids data redundancy by keeping a single copy of the data. Which eliminates the unnecessary duplication of dat

A.WHAT IS A DATABASE?       A database is essentially like a chest where you can store all your special things. It's similar to a digital filing system, collecting the information you've input, such as names, numbers, or even images. This data is well-organized, stored, and managed so that users can easily keep track of it and access it efficiently. B.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?      Microsoft Office Excel is a spreadsheet software that allows users to create, manage, and analyze data, making it easier for them to organize information. If you wish to calculate your data quickly, Excel can do the job for you. Not only can Excel perform calculations, but it can also create graphs, charts, and much more.  C.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?      Microsoft Office Access is a database management software.  Allowing the users to create and manage these database. It also allows them to store, retrieve and handle data by using tables, forms and etc.