DATABASE MANAGEMENT SYSTEM


DATABASE MANAGEMENT SYSTEM

 A. What is a Database?

- It is an organized collection of structure information, or data, typically stored electronically in computer system.

B. What type of Software is Microsoft excel?

- Microsoft Excel is a spreadsheet program included in Microsoft Office suite of application.

C. What type of Software is Microsoft access?

- Microsoft Access is a database management system DBMS that combines the relational Microsoft 

Jet Database Engine with a graphical user interface and software development tools.

D. think of at least two differences between access and excel.

- Excel is made up of sheets with cells that can be used to perform calculations, create charts, and so on. Access, on the other hand, includes tables, queries, forms, and report modules. Overall, Excel is a spreadsheet, whereas Access is a database management system.

B. Explore & Explain

1. What is Information Management?

- It is the collection and management of information from one or more sources and the distribution

of that information to one or more audiences.

2. What is Database?

- An organized collection of structured information, or data, typically

stored electronically in a computer system.

3. What is Database Management System?

- A Database Management System or DBMS is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the database or the management of the database structure itself.

4. What are the Difference between RDBMS and NON?

Relational databases store data in rows and columns, similar to spreadsheets, whereas non-relational databases store data in one of four storage models that are best suited for the type of data being stored.

5. What is object-oriented database

An object-oriented database OOD is a database system that can work with complex data object - that is, objects that mirror those used in object-oriented programming languages. In object-oriented programming OOP, everything is an object.

C. Elaborate & evaluation

1. Microsoft Access

2. DBMS

3.RDBMS

4. Excel

5. Database









Comments

Post a Comment

Popular posts from this blog

Functions Of DBMS and Its Advantage and Disadvantage

Image
  Functions Of DBMS and Its Advantage and Disadvantage A. Functions of DBMS    1. Data Dictionary Management    -    DBMS stores definitions of the data elements and their relationships       (metadata)     in a data dictionary. Example of   Data Dictionary Management: 2. Data Storage Management   -  creates and manage the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics. 3. Data transformation and presentation -  transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format. 4. Security Management -  creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and w...
Read more

Introduction to SQL 💗

Image
 Introduction to SQL💗 A. ENGAGE A. DATA DEFINITION LANGUAGE  - A data definition or data description language in the context of SQL is a syntax for creating and changing database objects such as tables, indices, and users. B. INTERACTIVE DATA MANIPULATION LANGUAGE - Interactive Data Manipulation Language or DML  is a set of computer languages that are expressly used to change the database, such as CRUD operations to create, read, update, and remove data. INSERT, SELECT, UPDATE, and DELETE commands are used. C. EMBEDDED DATA MANIPULATION LANGUAGE - Embedded SQL is a means of merging a programming language's computing capability with SQL's database manipulation capabilities. Embedded SQL statements are SQL statements that are written inline with the host language's program source code. B. EXPLORE & EXPLAIN  1. What are the basic sql expression?  - SQL expression can be classified into following categories.  SQL Boolean Expression -  fetches data bas...
Read more