Scribd
Upload
2 views1 page

IV.+SQL+Script

The document contains an SQL script that creates a 'students' table with fields for student ID, full name, email, enrollment date, and major. It also includes a series of INSERT statements to populate the table with ten student records. Finally, there is a SELECT statement to retrieve all entries from the 'students' table.

Uploaded by

ashwinlokhande152
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

IV.+SQL+Script

The document contains an SQL script that creates a 'students' table with fields for student ID, full name, email, enrollment date, and major. It also includes a series of INSERT statements to populate the table with ten student records. Finally, there is a SELECT statement to retrieve all entries from the 'students' table.

Uploaded by

ashwinlokhande152
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL SCRIPT

CREATE TABLE students (

student_id INT PRIMARY KEY,

full_name VARCHAR(100) NOT NULL,

email VARCHAR(100) UNIQUE NOT NULL,

enrollment_date DATE NOT NULL,

major VARCHAR(50)

);

INSERT INTO students (student_id, full_name, email, enrollment_date, major)

VALUES

(1, 'Olivia Johnson', '[Link]@[Link]', '2024-09-01', 'Biology'),

(2, 'Liam Anderson', '[Link]@[Link]', '2024-09-01', 'Computer Science'),

(3, 'Emma Davis', '[Link]@[Link]', '2024-09-02', 'Psychology'),

(4, 'Noah Martinez', '[Link]@[Link]', '2024-09-02', 'Economics'),

(5, 'Ava Thompson', '[Link]@[Link]', '2024-09-03', 'Mechanical Engineering'),

(6, 'James Harris', '[Link]@[Link]', '2024-09-03', 'English Literature'),

(7, 'Sophia Robinson', '[Link]@[Link]', '2024-09-04', 'Business


Administration'),

(8, 'Benjamin Clark', '[Link]@[Link]', '2024-09-04', 'Physics'),

(9, 'Isabella Walker', '[Link]@[Link]', '2024-09-05', 'History'),

(10, 'Ethan Lewis', '[Link]@[Link]', '2024-09-05', 'Computer Science');

Select * from students;

You might also like