Get latest, qualitative and comprehensive notes of database concept it 802 class 12. it covers all topics very optimally that certainly help students to secure high marks. What is data? Generally, data is collection of characters, numbers and other symbols that represents values of some situations or variables. It is raw facts which have not […]
IT 802 Class 12 Database Concept Notes Read More »
Get well organized Unit-2 Class 12 IP Database Query Using SQL Notes prepared as per CBSE Syllabus cover all topics to score high marks. SQL Functions Are subprograms used to manipulate data in different ways as: Perform calculations on data Modify data items Format data items to display Summarizes and calculate group of rows SQL
Class 12 IP Database Query Using SQL Notes | IP Class 12 SQL Notes Read More »
Download Latest and Complete pdf series of CBSE IP Class 12 Practical Program Worksheets with code and output covers all important topics. Practical Worksheets for Class 12 IP are designed to help students develop logical and analytical capabilities, problem solving skills, and improve their subject knowledge. these worksheets are best study materials for students designed
Class 12 IP SQL Practical Questions | MySQL Worksheet for Class 12 Read More »
They made UniformCode as the primary key for UNIFORM relation. Further, they used UniformCode and Size as composite keys for PRICE relation. By analyzing the database schema and database state, specify SQL queries to rectify the following anomalies. (a) The PRICE relation has an attribute named Price. In order to avoid confusion, write SQL query
EMPLOYEE (AadhaarNo, Name, Address, Department, EmpID)DEPENDENT (EmpID, DependentName, Relationship)Use the EMP-DEPENDENT database to answer the following SQL queries:(a) Find the names of employees with their dependent names.Ans: Select E.Name, D.DependentName FROM EMPLOYEE E, DEPENDENT DWHERE E.EmpID = D.EmpID;(b) Find employee details working in a department, say, ‘PRODUCTION’.Ans: SELECT * FROM EMPLOYEE WHERE Department = ‘PRODUCTION’;(c) Find employee
Table: STUDENT RollNo Name Stream Section RegistrationID *The values in Stream column can be either Science, Commerce, or Humanities.* The values in Section column can be either I or II.Ans:CREATE TABLE STUDENT (RollNo INT NOT NULL UNIQUE,Name varchar(20) NOT NULL,Stream varchar(20) CHECK (Stream IN (‘Science’, ‘Commerce’, ‘Humanities’)),Section varchar(2) CHECK (Section IN (‘I’, ‘II’)),RegistrationID int PRIMARY
DELETE DROP DELETE is DML statement DROP is DDL statement DELETE is a SQL Command, removes some or all records from a table DROP is a SQL Command, which removes different elements of database like table, constraints or entire database schema. WHERE clause can be used with DELETE WHERE can not be used with DROP
Differentiate between DELETE and DROP Read More »
ALTER UPDATE ALTER is a DDL statement UPDATE is a DML statement ALTER is a SQL command that is used to modify, delete or add a column to an existing table in a database. UPDATE is a SQL command that is used to update existing records in a database ALTER command modifies the database schema
Differentiate between ALTER and UPDATE Read More »
(a) Retrieve the MatchID of all those matches where both the teams have scored > 70.Ans: SELECT MatchID FROM MATCH_DETAILSWHERE FirstTeamScore >70 AND SecondTeamScore >70;(b) Retrieve the MatchID of all those matches where FirstTeam has scored < 70 but SecondTeam has scored > 70.Ans:SELECT MatchID FROM MATCH_DETAILSWHERE FirstTeamScore <70 AND SecondTeamScore >70;(c) Find out the MatchID
(a) Create a database “Sports”.Ans: CREATE DATABASE Sports;(b) Create a table “TEAM” with following considerations:It should have a column TeamID for storing an integer value between 1 to 9, which refers to unique identification of a team.Each TeamID should have its associated name (TeamName), which should be a string of length not less than 10
