Posts

Introduction to SQL 💗

Image
 Introduction to SQL💗 A. ENGAGE A. DATA DEFINITION LANGUAGE  - A data definition or data description language in the context of SQL is a syntax for creating and changing database objects such as tables, indices, and users. B. INTERACTIVE DATA MANIPULATION LANGUAGE - Interactive Data Manipulation Language or DML  is a set of computer languages that are expressly used to change the database, such as CRUD operations to create, read, update, and remove data. INSERT, SELECT, UPDATE, and DELETE commands are used. C. EMBEDDED DATA MANIPULATION LANGUAGE - Embedded SQL is a means of merging a programming language's computing capability with SQL's database manipulation capabilities. Embedded SQL statements are SQL statements that are written inline with the host language's program source code. B. EXPLORE & EXPLAIN  1. What are the basic sql expression?  - SQL expression can be classified into following categories.  SQL Boolean Expression -  fetches data bas...

DATABASE MANAGEMENT SYSTEM

Image
  DATABASE MANAGEMENT SYSTEM A.    Engage  A. Functions of DBMS Data Storage Management.  Security Management. Backup and Recovery Management.  Database Access Language and Application Programming Interface. Data Dictionary Management. Data Transformation and Presentation.  Multi User Access Control. Data Integrity Management. B. Advantages of DBMS C. Disadvantages of DBMS B.   EXPLORE & EXPLAIN 1.         What are the different components of DBMS? -  Data, User, Hardware, Software, Database Access Language, Procedures . 2.     What is the difference between data and information? - Data is unorganized, while information is structured or organized. Data is a mass noun, whereas information is an uncountable noun. Data on its own is rarely useful, but  information is. The raw forms of numbers, statements, and characters are all examples of data. 3.        What is an overall ...

DATABASE MANAGEMENT SYSTEM

Image
DATABASE MANAGEMENT SYSTEM  A. What is a Database? - It is an organized collection of structure information, or data, typically stored electronically in computer system. B. What type of Software is Microsoft excel? - Microsoft Excel is a spreadsheet program included in Microsoft Office suite of application. C. What type of Software is Microsoft access? - Microsoft Access is a database management system DBMS that combines the relational Microsoft  Jet Database Engine with a graphical user interface and software development tools. D. think of at least two differences between access and excel. - Excel is made up of sheets with cells that can be used to perform calculations, create charts, and so on. Access, on the other hand, includes tables, queries, forms, and report modules. Overall, Excel is a spreadsheet, whereas Access is a database management system. B. Explore & Explain 1. What is Information Management? - It is the collection and management of informat...

introduce myself

Image
 Allow me to introduce myself I'm Virgilio Yabut, 19years old from Balic- Balic Sta- Rita. In my Pastime I like to do aqua scaping, fixing electronics, watch movies or spend some time gaming  I am easy to approach and friendly. I am sometimes talkative and at times silent depends on the mood of the day. I also like to learn and explore new things and information because its fascinates me, I also like discussing  information to people who share my same ideas to gain better understanding of the said topic. My experience from Gordon College Information Management has been a wonderful for me. Through the helped of my instructor Ms. Mayer Sanchez I am learning new things every time  we had classes every topic is an new and interesting one for me and it never fails to fascinate me every time a make a program runs after many errors. The new information I received through this experiences had been a great building block for my future as an ...

Functions Of DBMS and Its Advantage and Disadvantage

Image
  Functions Of DBMS and Its Advantage and Disadvantage A. Functions of DBMS    1. Data Dictionary Management    -    DBMS stores definitions of the data elements and their relationships       (metadata)     in a data dictionary. Example of   Data Dictionary Management: 2. Data Storage Management   -  creates and manage the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics. 3. Data transformation and presentation -  transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format. 4. Security Management -  creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and w...