My Information Management Class Experience

 What is SQL? Have you ever heard of SQL? If not, then allow me to clarify. SQL or " Structured Query Language ",  is a standardized programming language that is used to manage relational databases and perform various operations on the data in them, it is honestly an easy language to learn . If you understand programming and already know some other languages, you can learn SQL in a few weeks. If you're a beginner, completely new to programming, it can take longer. Now for a bonus question, should you use SQL? Well it is  a better fit for heavy duty or complex transactions because it's more stable and ensure data integrity . You need to ensure ACID compliance. (Atomicity, Consistency, Isolation, Durability) or defining exactly how transactions interact with a database. You don't anticipate a lot of changes or growth, compared to python, the significant difference between SQL and Python is that  SQL is used to access and extract data from a database . At the same ti...

  What is a Data Definition Language?       Data Definition Language (or DDL)  includes those SQL statements that create and drop locations, databases and database objects such as tables and indexes, it   also includes statements to alter database objects and impose integrity constraints on tables. Interactive Data Manipulation Language       What is interactive Data Manipulation Language? It is simply a  data manipulation language   allows users to access and retrieve database contents in both interactive and embedded modes, now that's interesting!      It also includes constructs that allow retrieval and manipulation of database content. Embedded Data Manipulation Language Now what about embedded data manipulation language? Well Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements wr...

Last blog we talked about what exactly a DBMS  (Database Management System)  is, but now let's dig in a little deeper about it, what it's functions and pros and cons are. What are the functions of DBMS? Down below is a list of it's functions. DATA DEFINITION The DBMS must be able to accept data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form.   DATA MANIPULATION The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. DATA SECURITY AND INTEGRITY The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. DATA RECOVERY AND CONCURRENCY The DBMS must have the capability of recover from, or minimize the effects of a system crash. DATA DICTIONARY The DBMS must provide a system database call...

  A. Engage A. What is a Database? - What is it? Well a database is an organized collection of structured information, or data that are usually stored within a computer system, they also manage the retrieval, modification and deletion of a data in conjunction with various data-processing operations. B. What type of software is Microsoft Excel? - Microsoft Excel is a spreadsheet program,  it allows users to organize, format and calculate data with formulas using a spreadsheet system. This spreadsheet provides charts and graphs for data visualization, and the spreadsheet's limit can reach over  1,048,576 rows and 16,384 columns, it's that massive! C. What type of software is Microsoft Office Access? - The Office Access is a database management system (DBMS) used to store and manage data, this software is perfectly made for business and enterprise users. D. Think of atleast two differences between Access and Excel - Firstly, in terms of data storing capacity, Excel stores l...

The Next Topic        It's a wonderful morning, especially with a brand new subject at hand that is Information Management.                           What is Information Management?      Well first off,  Information Management System (IMS) is a general term for software designed to facilitate the storage, organization and retrieval of information. What is it used for?      The Data and various types of information are collected, stored, managed, and maintained through information management. It necessitates the development of specialized information management systems aimed at assisting the organization in the efficient use of its resources to support business activities.      To Design, produce, manage, and use information with insight and innovation is the goal of information management. individuals, organizations, communities, and society by assi...

TECHNOLOGY           You can't deny the existence of technology and the fact that it truly improved the way of lifestyle for everyone, despite the downsides and negative effects it holds on the younger generation like gaming addictions.           Looking at the brighter side of the spectrum technology has helped humanity progress in a fast rate, new devices are being produced and sold to the public, advance computers, electrical cars, sophisticated gadgets and so much more helps entertain and assist us in our tasks almost everyday. MUSIC & ENTERTAINMENT           Music and overall entertainment had a huge effect on the lives of people, it keeps us motivated, happy and stable, without it people and society would look and feel a lot different in a more sad and monotone way, devoid of emotion and filled with negativity.            It really is a medium that we as individuals seek t...