Experiencing Information Management 1

A .    DATA DEFINITION LANGUAGE Answer: Data specification, also known as data definition language, is a SQL syntax used to create and modify database constructs such as tables, indexes, and users. DDL statements, which are similar to computer programming languages, are used to describe data structures, especially database schemas.   B .      INTERACTIVE DATA MANIPULATION LANGUAGE Answer:  A data manipulation language (DML) is a computer programming language that helps you to insert (add), remove (delete), and modify (update) data in a database. A DML is often a sublanguage of a broader database language, such as SQL, which contains some of the language's operators . C. EMBEDDED DATA MANIPULATION LANGUAGE Answer :   SQL (Structured Query Language) is a data manipulation language that is commonly used for accessing and manipulating data in relational databases. DML is used in several ways by IMS/DLI, CODASYL databases such as IDMS, an...

 DataBase A. what is a database? Is an organized collection of data, generally stored and accessed electronically from a computer system.  databases are more complex they are often developed using formal design and modeling techniques. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most  databases  use structured query language (SQL) for writing and querying data. B. What type of software is Microsoft office excel Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. C. What type of software is Microsoft office excel. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications,...

  DBMS      Database Management Systems A . DBMS A database management system is a software tool that makes it possible to organize data in a database. It is often referred to by  its  acronym,  DBMS . The  functions  of a  DBMS  include concurrency, security, backup and recovery, integrity and data descriptions. B . Advantage of DBMS Improved data sharing: The  DBMS  helps create an environment in which end users have better access to more and better-managed data                                Wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture. It becomes much easier to see how actions in one segment of the company affect other segments C. Disadvantage of DBMS one of the disadvantages of dbms is Database systems require sophisticated hardware and ...