DATABASE

What is a Database?

A collection of material that has been structured and presented to serve a certain purpose.

WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? 

    Microsoft Excel is a spreadsheet program for Windows and Mac that includes calculation, graphic tools, pivot tables, and macro programming language capabilities.

WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?

Microsoft Access is a well-known database management solution that is included in the Microsoft 365 Office suite. Microsoft Access is a database application that integrates Microsoft's relational Jet Database Engine with software development tools and a graphical user interface (GUI).

TWO DIFFERENCES BETWEEN ACCESS AND EXCEL

Information Management 1 Class Experience 

By: Jeffrey B. Castaneda of BSCS 1A

    

    
Information Management I is a very interesting unit. It began in the second semester last January 2023. It discusses databases, database management systems, and SQL. As computer science students, we must understand how to create databases. It is essential in the development of systems, web apps, mobile applications, and other applications. Writing SQL commands is enjoyable, and part of it is simple at first but becomes more sophisticated with code. 

Important topics covered in information management may include: 

• Information organization and retrieval: Using tools such as databases, search engines, and categorization systems to effectively organize and retrieve information.
• Information architecture is the process of designing and structuring information systems, such as websites and intranets, to meet the objectives and goals of users.
• Data management is the process of managing huge amounts of data, which includes data modeling, database design, and data mining techniques.
• Knowledge management is the process of capturing, storing, and sharing knowledge inside an organization, including approaches for developing knowledge repositories and encouraging knowledge sharing.
• How to manage sensitive or confidential material, including problems of privacy, security, and intellectual property.

    In general, an information management course provides students with a foundation of knowledge and abilities that can be applied in a wide range of industries and employment responsibilities, including IT project management, business analysis, and database administration.

 SQL (Structured Query Language)

SQL is a complete language with its own DDL and DML components:

A. Data Definition Language

    
    It is used to define relation schemes by providing instructions. Among other things, you can delete relations and create indexes.

B. Interactive Data Manipulation Language
    
    It is capable of inserting, deleting, and updating tuples in a relation.

C. Embedded Data Manipulation Data

    SQL is incorporated using the embedded form of the DML statements into programs written in different programming languages

 DBMS (Database Management Systems) 💻

    Database Management Systems (DBMS) are software systems that store, retrieve, and execute data queries. A database management system (DBMS) acts as a bridge between an end-user and a database, allowing users to create, read, edit, and remove data in the database.

A. Function of DBMS

• Data Definition - The database management system (DBMS) must be able to accept data definitions (external and internal) and mental schemas, as well as any associated mappings) in original form and transform to the proper object form.
• Data Manipulation - The DBMS must be capable of handling user requests to retrieve data and maybe updating existing data in the database or adding new data to the database.
• Data Security and Integrity - The DBMS must be able to monitor user requests and reject inappropriate efforts to circumvent the security and integrity tests outlined in the Administrator of a database.
• Data Recovery and Concurrency - The DBMS must be able to recover from or minimize the effects of a system crash.
  
• Data Dictionary - The DBMS must include a system database known as the database dictionary
  
  
 

B. Advantages of DBMS

• Reduced Data Redundancy - Data redundancy is minimized in database systems by preserving a single duplicate of each record.
• Data Integrity - Because the database only stores a single copy of a certain piece of data, you may be confident. Ensure that all future uses of the data will reflect the changes to the data
• Data Independence - The database system's structure requires that data be independent of other data in the database as well as the software used to access the database.
• Data Security - Additional security measures can be implemented as part of a database system. Product for database software.
• Data Consistency - Data consistency is maintained in the database environment.
• Easier use of data - Data is more easily accessible in a database system.
• Less Storage - Because data redundancy is reduced, if not eliminated, the database will take up less space.
  

C. Disadvantages of DBMS

• Complexity - Databases and their accompanying database management systems (DBMS) are exceedingly complicated.
• Expense - The DBMS and its databases are installed on the current system. Because of the likelihood of the need for more resources, cautious preparation is required.
• Vulnerability - Because data in a database is stored in a central area, it is subject to partial or complete loss. Total destruction occurs when hardware components fail or are in an Error in the software.
• Size - A typical mainframe database is very large
  
• Training Costs - When a corporation buys a database product, it must first train one or more employees. Individuals to serve as the new product's database administrator.
• Compatibility - One of the disadvantages of most database systems is their interoperability with other systems.
• Locking-in of Technology - What happens if the vendor announces a wish to discontinue the product? There is one. It is possible that they will have to completely rethink their system.