IP Practicals

Term-2 IP Class 12 CBSE 2021-22 Suggested Practical List with solution

2 Comments / IP Class 12 Tutorial, IP Practicals /

Create a student table with the student id, name, and marks as attributes where the student id isthe primary key. Insert the details of a new student in the above table. Delete the details of a student in the above table. Use the select command to get the details of the students with marks more […]

Term-2 IP Class 12 CBSE 2021-22 Suggested Practical List with solution Read More »

An organization wants to create a database EMPDEPENDENT to maintain following details about its employees and their dependent.
EMPLOYEE (AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT (EmployeeID, DependentName, Relationship)

CS Class 12 Tutorial, Database Concept, IP Class 12 Tutorial, IP Practicals, IT 802 Class 12 Tutorial, NCERT Solutions, RDBMS, SQL Tutorials /

a) Name the attributes of EMPLOYEE, which can be used as candidate keys.b) The company wants to retrieve details of dependent of a particular employee. Name the tables and the key which are required to retrieve this detail.c) What is the degree of EMPLOYEE and DEPENDENT relation? Ans: (a) AadharNumber, EmployeeID (b) To retrieve the

An organization wants to create a database EMPDEPENDENT to maintain following details about its employees and their dependent.
EMPLOYEE (AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT (EmployeeID, DependentName, Relationship) Read More »

error: Content is protected !!