1) Create a database ‘LIBRARY USERS’ with the following tables: Students Class Add the following fields in the ‘Students’: Students _Enrollment ID, Students _NAME, Students_AGE, Students _ADDRESS, Class_NAME Add at least 20 records in the table ‘Students’.

To create a database named 'LIBRARY USERS' with tables for 'Students' and 'Class', and populate the 'Students' table with 20 records, follow these steps using SQL:

Step 1: Create the Database

First, we need to create the database. Use the following SQL command:

 CREATE DATABASE LIBRARY_USERS; 

Step 2: Switch to the Database

Next, we switch to the 'LIBRARY_USERS' database where we will create the tables:

 USE LIBRARY_USERS; 

Step 3: Create the 'Class' Table

The 'Class' table will store information about different classes to which the students belong. You can define the 'Class' table with the following fields:

• Class_ID: A unique identifier for the class.
• Class_NAME: The name of the class.

Here’s the SQL command to create the 'Class' table:

 CREATE TABLE Class ( Class_ID INT  __________ ______ ______ _____ _____ _________ ____.
 ______ _____ _______ __________ _____ ________ ____ ____ ____ _____.
 _____ ___ _______ ___ __________ ________ ________ _____ _________ ________ _________ ________.
 ________ ________ _____ _____ _________ __________ __________ ____ ________.
 __________ __________ ________ ___ __________ _______ ______ ___ ___ _______ _________.
 _____ _______ ___ _________ ______ _______ ___ ___ _______ ______ __________ _________.
 ________ ____ ______ ______ ______ ____ __________ ____ __________ _________ ________.
 _________ _______ _____ _______ _________ _____ ______ ___ __________.
 ____ ________ _________ ____ ________.
 _______ ____ ________ _______ _______ _________ ___.
 __________ ___ _______ _______ ___ ________ ________ _________ _________ _________ ____.
 _______ ________ ____ ___ _____ _______ _________ __________ _________.
 _________ ___ ____ _________ ____ _________ _______ ________ ________.
 _____ __________ ______ ___ ____.
 _______ _____ ______ ________ ___ _________ _____.
 __________ _____ _________ _________ ________ _______ ________ ____ _______ _________ __________.
 _______ ___ ________ _______ ________ ____ ______ ______ ____ ______ ___ _____.
 _____ ________ ______ ________ ___ _______ _______ ___ ___ ____ _________.
 _________ _______ ________ ____ __________ _____ _________.
 _____ _______ ______ ________ _______ ____ ____.
 ___ ____ ________ _________ _____ ___ _____.
 __________ _______ ____ _______ ______ _______ ____ ___ ______ _____.
 ______ _______ __________ ______ _________ _____ __________ _________.
 _________ _________ ______ _______ ____ _______ ________ __________ _______ ___ ____.
 ________ _______ ______ ___ _______.
 ________ __________ ________ __________ _______ ____ _________.
 ___ ______ ___ _______ ________ __________ __________ ____.
 _______ ________ _____ _____ _____ ____ ____.
 ___ ________ _________ ___ _________ ________ ___ _____ __________ ____.
 _______ _______ ____ ___ ___ __________ _______ _____ _____.
 ___ ______ ___ ______ _______ __________ ________ ______ _________ ___ ___ ________.
 ____ ______ _____ _______ ____ ________ _________.
 ______ ____ ______ _________ ______ _________ ______ ______.
 ________ ________ ______ ________ _____ _______ ________ ________ _________ _______ ______ _____.
 __________ ________ __________ __________ ______ _______ _____ _____ _____ ______ ___.
 ____ __________ ____ ____ ____ _________ ________ ___ ____ _________.
 ________ _________ _____ _________ _____ _______ ___ _____ _____.
 ______ ______ ______ _______ ___ ____ _________ _______.
 ____ ____ _______ _______ ____.
 ___ ______ _______ ___ __________ __________ _______ ___ __________ __________ ____.
 ________ ______ __________ _____ ____ _______ ___.
 _________ ______ _________ _____ ______ __________ __________ ____ _________ _________ ________ ________.
 _________ _______ ____ ______ _____ ___ _________ ______ ________ ___ ________.
 __________ ________ _____ _________ _________ _________.
 ___ ______ ______ __________.
Get Full Answer on WhatsApp