Question
What is SQL? Explain its important features.
b) Consider the following schemas:
BOOK (Book_ ID, Title, Publisher_ID, Year_of Pub, Price)
AUTHOR (Author_ID, Book_ID, Author Name)
PUBLISHER (Publisher_ID, Book ID, Address, Name_of Pub, No. of Copies)
Answer :
Word Count : 477
___ ___ _______ __________ _________ __________ ___.
__________ _________ ___ ________ ____ _______ _________ ___ _______ _______ ____.
_______ ________ ___ ________ ________ _________ _______ ____ _____.
_____ __________ _________ ___ _________.
____ __________ _______ _________ ____ ____ ______ ____ ___ __________.
________ _______ _____ _________ ____ _________ ________ _____ ____ ______ _______ _________.
________ __________ ______ ________ _____.
_________ ______ ______ __________ _______ _______ ________ ___ ____ ____ _____ ______.
_____ _________ __________ ________ ____ _______.
____ _________ ____ ____ _______.
________ __________ ______ ____ ___ _____ _____ ____ ________ ____ _________.
_______ _______ ________ ____ _____ _____ _____.
_________ _____ __________ __________ _____.
______ __________ _______ ________ ___.
_________ __________ ___ _______ _____ ______ _____.
_____ _____ ___ _________ ____ _________ _______ _____ _______ _________ ______.
_______ ________ _________ ___ ________ _____ ______.
_______ ______ ______ ___ __________ _______ ______.
_______ _________ _____ ____ _____ ___ ____ _____ ___ _____ ________ __________.
_______ _______ _______ _____ ___ ___.
_________ ________ _________ ____ _______ _______ ________.
______ _______ _____ _____ ____.
__________ _______ ____ _________ ________ _______ _____ _____ _______ ______.
_________ _______ __________ ____ ___.
______ __________ _________ _______ _____ ____ ____ ___ ______ ___ ____.
_________ ________ ________ ____ ____ _________ ____ ______ ______.
________ __________ ____ ________ _________ ___ ___ ____ __________ __________.
___ __________ _____ ________ ____ ___ ______ ___.
______ ______ _____ __________ _______ _____ _______.
_______ _____ _________ _________ ____ ____.
______ __________ ________ ________ _________ ________ _________ ____ _____.
_________ ___ _____ ______ ____ ____ _____ ________ _______ __________ _____.
_______ ______ ____ _____ _________ _______ ______ ___ ______ ______ ___.
_________ ____ ____ ___ ____ _______ _____ _____ ____.
_________ _______ ________ _______ _____ _________ ________ ___ ____ _________ _______.
______ ______ ________ __________ ______ _________ ________ _________ ________ ________ ______ ______.
__________ ______ ________.
Skip in 10
SQL (Structured Query Language) is a standard programming language specifically designed for managing and manipulating relational databases. It allows users to create, modify, retrieve, and manipulate data stored in a database. SQL is used for both data definition (DDL), data manipulation (DML), data control (DCL), and transaction control (TCL). Important features of SQL include: 1. Data Definition Language (DDL): SQL allows the creation and modification of database schema through statements like `CREATE`, `ALTER`, and `DROP`. 2. Data Manipulation Language (DML): SQL provides commands such as `INSERT`, `UPDATE`, `DELETE`, and `SELECT` to manipulate and retrieve data. 3. Data Control Language (DCL): It includes `GRANT` and `REVOKE` commands that control access to data in the database. 4. Transaction Control: SQL supports transactions using commands like `COMMIT`, `ROLLBACK`, and `SAVEPOINT` to ensure data integrity. 5. Embedded SQL: SQL can be embedded within other programming languages like C, Java, or Python for database interaction. 6. Declarative Language: SQL is non-procedural, which means users specify what data is needed, not how to
_____ _________ _________ ______ _____ _________.___ ___ _______ __________ _________ __________ ___.
__________ _________ ___ ________ ____ _______ _________ ___ _______ _______ ____.
_______ ________ ___ ________ ________ _________ _______ ____ _____.
_____ __________ _________ ___ _________.
____ __________ _______ _________ ____ ____ ______ ____ ___ __________.
________ _______ _____ _________ ____ _________ ________ _____ ____ ______ _______ _________.
________ __________ ______ ________ _____.
_________ ______ ______ __________ _______ _______ ________ ___ ____ ____ _____ ______.
_____ _________ __________ ________ ____ _______.
____ _________ ____ ____ _______.
________ __________ ______ ____ ___ _____ _____ ____ ________ ____ _________.
_______ _______ ________ ____ _____ _____ _____.
_________ _____ __________ __________ _____.
______ __________ _______ ________ ___.
_________ __________ ___ _______ _____ ______ _____.
_____ _____ ___ _________ ____ _________ _______ _____ _______ _________ ______.
_______ ________ _________ ___ ________ _____ ______.
_______ ______ ______ ___ __________ _______ ______.
_______ _________ _____ ____ _____ ___ ____ _____ ___ _____ ________ __________.
_______ _______ _______ _____ ___ ___.
_________ ________ _________ ____ _______ _______ ________.
______ _______ _____ _____ ____.
__________ _______ ____ _________ ________ _______ _____ _____ _______ ______.
_________ _______ __________ ____ ___.
______ __________ _________ _______ _____ ____ ____ ___ ______ ___ ____.
_________ ________ ________ ____ ____ _________ ____ ______ ______.
________ __________ ____ ________ _________ ___ ___ ____ __________ __________.
___ __________ _____ ________ ____ ___ ______ ___.
______ ______ _____ __________ _______ _____ _______.
_______ _____ _________ _________ ____ ____.
______ __________ ________ ________ _________ ________ _________ ____ _____.
_________ ___ _____ ______ ____ ____ _____ ________ _______ __________ _____.
_______ ______ ____ _____ _________ _______ ______ ___ ______ ______ ___.
_________ ____ ____ ___ ____ _______ _____ _____ ____.
_________ _______ ________ _______ _____ _________ ________ ___ ____ _________ _______.
______ ______ ________ __________ ______ _________ ________ _________ ________ ________ ______ ______.
__________ ______ ________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.