Posts

Showing posts from March, 2021
Image
 SQL Components DATA DEFINITION LANGUAGE      "Data Definition Language" is a term that refers to a programming language A DDL is a programming language that is used to construct and modify data structures. DDL commands may be used to add, delete, or change tables in a database, for example. The DROP command can be used to uninstall a table if it is no longer needed. INTERACTIVE DATA MANIPULATION LANGUAGE SELECT statements are used to retrieve data from a relational database, and INSERT, UPDATE, and DELETE statements are used to modify the data. The SQL sublanguage, also known as Data Manipulation Language, is made up of these sentences (or DML) EMBEDDED DATA MANIPULATION LANGUAGE Embedded SQL is intended for use in general-purpose programming languages like PL/1, Cobol, Java, Pascal, and C. Embedded Data Manipulation Language (EDML)- This version of SQL is intended for use in general-purpose programming languages.
Image
 Start of DBMS What is Database? Any structured array of data is referred to as a database. The below are some examples of databases that you can come across in your everyday life:   A telephone directory T.V. Guide Airline reservation system Motor vehicle registration records Papers in your filing cabinet  Files on your computer hard drive. Microsoft Office Excel Microsoft Excel is a spreadsheet program developed by Microsoft and was first released in 1985. Excel is a commonly used spreadsheet application that organizes data into columns and rows that can be manipulated using formulas to execute mathematical functions on the data. What type of software is Microsoft office? Microsoft Office is a series of desktop management software developed by Microsoft primarily for corporate use. It is a Microsoft Corporation proprietary software that was first published in 1990. MS Office has dominated the delivery of new office-related document-handling tech environments for decades. Excel vc. Ac
Image
 Class Experience My online learning experience has been unlike something I've ever had before. I enjoy working from home, but I would prefer to do my work in a real classroom because it allows me to ask questions if needed, and it is, in my view, much more productive than online learning. To be a good distance learner, I've found that you must be self-disciplined and capable of working independently. Since you will not be physically attending class each week, you will be able to participate in it from the convenience of your own home. Since the teacher would not continually alert you of assignments or mission deadlines, you must be self-disciplined.

Database Management System

Image
  Introduction to DBMS Function of DBMS A database's role is to store and organize information. A database is a logically structured set of interconnected data that supports a variety of business purposes. The database not only records the values of different entities' attributes but also the relationships between them. A database's role is to store and organize information. A database is a logically structured set of interconnected data that supports a variety of business purposes. The database not only records the values of different entities' attributes but also the relationships between them. Advantages of DBMS Reducing Data Redundancy is one of the benefits of DBMS, and Various files were stored in several different places within a system, or also through multiple systems, in file-based data processing systems. Also, Data Exchange Users of a database may exchange data between themselves. As well as Data Quality, refers to the accuracy and consistency of the data in