Scribd
Upload
11 views3 pages

Database Creation and Management Guide

The document outlines an experiment for creating a database named 'bank_db' with a table for employee records. It specifies the required resources, including operating system, disk space, RAM, and software needed for the task. The task includes creating the table with specific constraints, entering records, handling duplicates, and setting a primary key for the employee ID.

Uploaded by

dhruvytofficial1
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
11 views3 pages

Database Creation and Management Guide

The document outlines an experiment for creating a database named 'bank_db' with a table for employee records. It specifies the required resources, including operating system, disk space, RAM, and software needed for the task. The task includes creating the table with specific constraints, entering records, handling duplicates, and setting a primary key for the employee ID.

Uploaded by

dhruvytofficial1
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

DEPARTMENT OF ELECTRONICS & COMPUTER

ENGINEERING
Experiment No. 2: *1) Create Database for given application
2) Create tables for the given application
3)Assign Primary key for created table
4) Modify the table as per the application needs.
Required Resources with specifications:

Sr. Particulars Specification


No.
1. Operating system Windows 10 or higher
2. Disk space 8.5 gigabytes min for oracle
software, plus 2 gigabytes or
more for temporary storage
3. RAM 2 Gigabytes RAM minimum
4. Software mysql

Task 1:

1. Create a database – bank_db


2. Create a table employee
Emp_id
Name
Desig
Dept
3. Emp_id column should not allow duplicate and null values
Value of emp_id column should auto increment
4. Name column should not contain null value
5. Design column should have default value as “Probation”
6. Enter 10 records
7. Enter 2 records with same name
8. Delete the duplicate record.
9. Make emp_id as primary key
DEPARTMENT OF ELECTRONICS & COMPUTER
ENGINEERING

Screen shots
DEPARTMENT OF ELECTRONICS & COMPUTER
ENGINEERING

You might also like