LSF Entry logs

Manipulating Data by Luke Satriani D. Felarca DATA DEFINITION LANGUAGE -  SQL's Data Definition Language (DDL) subset. It is a language used to describe data and the connections between it in a database. To: Maintain a copy of the database structure. You may create DDL for database objects in a script. By interacting with descriptions of the database schema, it is used to construct and alter the structure of objects in a database. DDL instructions, as opposed to data manipulation language (DML) commands, are used to change the database structure, such as by adding new tables or objects with all of their properties (data type, table name, etc.) INTERACTIVE DATA MANIPULATION LANGUAGE - A computer programming language called a data manipulation language (DML) is used to add (insert), remove (delete), and alter (update) data in a database. A DML is frequently a sublanguage of a more general database language like SQL, and it contains some of the language's operators. SELECT R...

In a bank database, the Bank entity manages multiple Branches, each Branch has multiple Accounts, each Account is owned by a Customer, and each Customer may have a relationship with one or more Employees of the bank.  Entity: An entity represents a real-world object or concept in the database, like "Customer" or "Account." Attributes: Attributes are the characteristics or properties of entities, such as "CustomerID" or "Address." Relationships: Relationships define how entities are connected or related to one another within the database. Degree of Relationships: The degree of a relationship refers to how many entities are involved in that relationship; most often, it involves two entities at a time. Connectivity of Relationships: Connectivity specifies how entities are directly linked in a relationship, like "one-to-one," "one-to-many," or "many-to-many." Cardinality of Relationships: Cardinality indicates the number...

Database Management Systems A. FUNCTIONS OF DBMS: DBMS manage the data, the database engine, and the database schema, allowing for data to be manipulated or extracted by users and other programs. This helps provide data security, data integrity, concurrency, and uniform data administration procedures. Database Management Systems (DBMS) are powerful tools in the realm of data management, and they bring forth a wide array of advantages that play pivotal roles in various industries and organizations. However, alongside these benefits, DBMS also carries certain drawbacks that should be carefully considered: Advantages: Improved Data Sharing: DBMS facilitates seamless data sharing among different users and applications, fostering collaboration and efficient information exchange. Data Integration: It enables the integration of disparate data sources, allowing organizations to derive valuable insights from a unified dataset. Data Security: DBMS implements robust security measures, including a...

All About Databases and Microsoft A. Database: A structured collection of data organized for efficient storage, retrieval, and analysis. It's used to manage information for various purposes. B. Microsoft Office Excel: Spreadsheet software used for creating, organizing, and analyzing data in tabular form. It's commonly used for tasks like financial analysis and data visualization. C. Microsoft Office Access: Relational database management system used to create and manage databases with structured data. Access is useful for tasks like managing inventory and creating small to medium-sized databases. D. Differences between Access and Excel: Data Structure and Purpose: Excel focuses on spreadsheet tasks and calculations, while Access is for managing relational databases with structured tables and relationships.Complexity and Functionality: Access offers more advanced features for creating queries, forms, and reports, and enforcing data integrity compared to Excel's simpler capab...