Information Management - John Iverson Javier

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.

  A database is like a big organized collection of information that you can easily find things in. It's kind of like a giant filing cabinet where you can store all sorts of different stuff and then quickly look it up when you need it. It's used in lots of different places, like schools, businesses, and hospitals, to keep track of important information and make sure everything stays organized and secure.   In a database, information is put into tables, which are like grids made up of rows and columns. Each row is like a separate piece of information, while each column tells you something specific about that information. You can ask the database questions using a special language called SQL, which helps you find exactly what you're looking for. Databases also have other features, like making sure everything is accurate and safe, which helps them work smoothly and efficiently.