DATABASE MANAGEMENT SYSTEM

 DATABASE MANAGEMENT SYSTEM

A.  Engage


 A. Functions of DBMS
Data Storage Management. 
Security Management.
Backup and Recovery Management. 
Database Access Language and Application Programming Interface.
Data Dictionary Management.
Data Transformation and Presentation. 
Multi User Access Control.
Data Integrity Management.

B. Advantages of DBMS

C. Disadvantages of DBMS


B.  EXPLORE & EXPLAIN


1.       What are the different components of DBMS?

- Data, User, Hardware, Software, Database Access Language, Procedures.

2.   What is the difference between data and information?

- Data is unorganized, while information is structured or organized. Data is a mass noun, whereas information is an uncountable noun. Data on its own is rarely useful, but information is. The raw forms of numbers, statements, and characters are all examples of data.

3.      What is an overall system structure of a DBMS?

- related data are grouped into tables, each of which consists of rows and columns, like a spreadsheet.

4.      What are the different functions of DBMS?

- Data Dictionary Management, Data Storage Management, Data transformation and presentation, Security Management, Security Management, Backup and Recovery Management, Data Integrity Management, Database Access Languages and Application Programming        Interface and Database Communication Interfaces.

5.       Who are the different users of dbms?

- End users of DBMS are primarily database administrators, system analysts, application       programmers, and others whose jobs require access to databases for querying, updating and generating reports.

C. Elaborate & evaluation  


1.  Automated records management system

2. File manager/ File System                         

3.Data

4. End Users

5.Query Language                          




Comments

Post a Comment

Popular posts from this blog

DATABASE MANAGEMENT SYSTEM

Image
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 informat...
Read more

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