Posts

Showing posts from April, 2021

DDL, INTERACTIVE DATA MANIPULATION LANGUAGE, AND EMBEDDED DATA MANIPULATION LANGUAGE

Image
  A. DATA DEFINITION LANGUAGE      It is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others.  B. INTERACTIVE DATA MANIPULATION LANGUAGE It can be used to insert, delete, and update tuples in a relation.   C. EMBEDDED DATA MANIPULATION LANGUAGE  The embedded form of the DML is used to incorporate SQL statements into programs created using other programming languages.

MY CLASS EXPERIENCE

Image
  In our information management subject, I learned a lot about databases, different diagrams models and how to use Microsoft Access. However, I think I would have understood the topics better if it were in a traditional, face to face classroom setting because it is difficult for me to grasp information at a quick pace. It was quite challenging to learn in this type of class environment since this method of learning is still new to me but given the situation that we are in as of the moment, we are left with no choice but to study online instead for the safety of the students and the instructors. Dilemmas were faced during class as technical difficulties are unavoidable and it is understandable because everyone is still trying to get used to online classes. Just like everyone, I also experienced these as sometimes I had internet connectivity problems and it would be stressful on my part as it would hinder me from entering class and passing requirements on time. I look forward to atta...

DATABASE, EXCEL AND ACCESS

Image
  A. WHAT IS A DATABASE?   A database is a systematic collection of data. Examples of it are  Telephone directory, Log-in / log-out, Record book and etc.  B. WHAT TYPE OF SOFTWARE IS MICROSOFT EXCEL? Microsoft Excel is a spreadsheet software created by Microsoft. It also allows users to create their own diagrams, tables to input their data, charts, and databases as well.   C. WHAT TYPE OF SOFTWARE IS MICROSOFT  OFFICE ACCESS?   Microsoft Access  is a database management system (DBMS) from  Microsoft  that combines the relational  Microsoft  Jet Database Engine with a graphical user interface and  software -development tools.   D. THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL.  While both of these software can be used for database, Access is mainly for easier data storing as it's capacity for storing data is higher than excel. It can store large objects such as images and documents. Other than that, Ac...