My Information Management Class Experience

  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...