Posts

Database Management System(DBMS)

Image
  A. My Understanding of DBMS In my Fundamentals of  Information Management class, I was taught that the use of a Database Management System (DBMS) helps to store, organize, and manage data properly. I never really had an idea of the importance of databases until I had this particular class. I now see that many of the systems I use on a daily basis use the DBMS to run properly. B. Functions of DBMS From this learning, I realized that a DBMS has a number of functions. First of all, a DBMS stores and organizes the data in a structured manner. This ensures that the information can be easily accessed. Instead of storing the information in a random manner, the DBMS stores the information in a structured manner in the form of tables and records. Another function of a DBMS is to provide security to the information. This ensures that only authorized people have access to the information and can modify or delete it. This helps in protecting the sensitive information from unauthorized u...
Post a Comment
Read more

Understanding Databases and the Difference Between Excel and Access

Image
  Understanding Databases and the Difference Between Excel and Access A database is an organized collection of data that is stored electronically so it can be easily accessed, managed, and updated. Databases help users store large amounts of information efficiently and allow data to be searched, sorted, and retrieved quickly. They are commonly used in schools, businesses, hospitals, and many other organizations to keep records safe and well-organized. Microsoft Office Excel is a type of spreadsheet software . It is mainly used for calculations, organizing data into rows and columns, creating charts, and performing simple data analysis. Excel is very useful for tasks like budgeting, grading, tracking expenses, and making reports because it allows users to easily enter data and use formulas. Microsoft Office Access , on the other hand, is a database management system (DBMS) . It is designed to store large amounts of data and manage relationships between different sets of informa...
Post a Comment
Read more