Information Management - John Iverson Javier

JAVIER JOHN IVERSON S. BSCS 1D SQL , or Structured Query Language , is like the language used to talk to databases. It helps us manage and get information from big sets of data stored in databases. With SQL , we can do things like find specific information, add new data, change existing stuff, or even get rid of things we don't need anymore. It's like having a special key to unlock a treasure chest full of useful information. Think of it this way: Imagine you have a giant library with books all over the place. SQL is like the librarian who helps you find the book you want. You can ask SQL questions like "Show me all the books by this author" or "Tell me how many books were published this year." SQL understands these questions and finds the answers for you in the database. It's like having a super-smart assistant who can find what you need quickly. And it's not just about finding stuff – SQL also helps organize data. Just like we put things in di...

JAVIER, JOHN IVERSON S. BSSCS 1D  DATA DEFINITION LANGUAGE (DDL): The Data Definition Language ( DDL ) is a group of commands in SQL (Structured Query Language) that helps create, change, or remove database objects like tables, indexes, views, and rules. It's like the plans for building a house. It tells us how to make rooms (tables), what each room is for (columns and their types), and the rules for organizing things (constraints).  INTERACTIVE DATA MANIPULATION LANGUAGE (IDML): The Interactive Data Manipulation Language (IDML) is a set of SQL commands that lets us handle and change data in a database. It's like the tools we use to move, arrange, or clean furniture in a house. We can add new stuff (insert data), rearrange what's there (update data), remove things (delete data), or just look around (retrieve data).  EMBEDDED DATA MANIPULATION LANGUAGE (EDML): The Embedded Data Manipulation Language (EDML) means using SQL commands inside a programming language like C, ...

INFORMATION MODEL An information model is like a plan for organizing data, making it easier to understand and use. It helps us see how different pieces of information are connected. For instance, in a database, it shows how tables relate to each other. By using an information model, we can design better systems for storing and finding data. It's sort of like creating a map for how information should be organized and accessed. In short, information models help us manage data more effectively. DATA MODEL A data model is like a plan for organizing information so it will be easy to use. It puts data into groups called entities and shows how they're connected through diagrams. Entities are like collections of things, and attributes describe those things.  The model makes sure the data stays correct by checking that it's all linked properly. Plus, it lets us ask questions and get answers using queries, which are like requests for specific information from the data. There are 3 ma...

  Data Structure : Access is made for handling databases that have different tables connected to each other. This helps keep data organized and easy to find. Excel, though, is more like a big table where you can put information in rows and columns. While Excel can do math and look at data, it's not as good at connecting different tables like Access can do. Functionality : Access is really good at helping with complicated stuff like organizing data, checking if it's correct, making forms to type in information easily, and creating special reports. It's great for jobs that need a lot of work with data, like keeping track of things in a store, remembering customer details, or following projects. Excel, though, is better at doing math, making charts, and looking at numbers. People use it a lot for things like making budgets, figuring out finances, or just making lists without needing to connect different tables of data.

  Microsoft Office Access is a special computer program created by Microsoft for handling information in databases. It's a type of software that helps people make, manage, and change databases. Access lets you store lots of organized data in one place, which makes it easy to find what you're looking for. With its easy-to-use tools and menus, Access helps you make your own database that fits what you need, whether it's for school or work. You can make tables to put your data in, connect those tables together, and create forms and reports to work with your information in different ways. Overall, Microsoft Office Access helps people keep their information neat and organized so they can use it better. Microsoft Office Access is a very helpful computer program that lots of different people use in many jobs. It has special things like checking if the data is correct, forms to type in information easily, and making reports that you can change how you want. With Access, you can man...

  Microsoft Office Excel is a computer program that helps you organize and work with numbers and information. It's part of a package of programs called Microsoft Office, which lots of people use for school or work. With Excel, you can make tables to put your data in and do calculations automatically. You can also make charts and graphs to show your information in a visual way, which can be helpful for understanding it better. Excel is easy to use and has lots of tools to make your work look neat and organized. You can type in your numbers, change how they look, and even share your work with others. People use Excel for lots of things, like keeping track of money, making schedules, or showing data in presentations. It's a handy tool for managing information and making it easier to understand.