Revision: Database Management Systems and SQL Computer Science (C++) Science (English Medium) Class 12 CBSE
- Observe the Following Table Carefully And· Write the Names of the Most Appropriate Columns, Which Can Be Considered as (I) Candidate Keys And. (Ii) Primary Key:
- Write Sql Queries for (I) to (Iv) and Find Outputs for Sql Queries (V) to (Viii) Which Are Based on the Table. to Display Details of All Transaction Of Type Depos1t From Table Transact. and to Display All Ano, Aname and Dot of Those Persons from Tables Account and Transact Who Have Done Transactions Less than Or Equal to 3000? Select Count(*), Sum(Amount) from Transact Where Dot <= '2017-06-01'
- Observe the Following Table Member Carefully and Write the Name of the Rdbms Operation Out of (I) Selection (Ii) Projection (Iii) Union (Iv) Cartesian Product, Which Has Been Used to Produce the Output as Shown in Result. Also, Find the Degree and Cardinality of the Result
- Write Sql Queries for (I) to (Iv) and Find Outputs for Sql Queries (V) to (Viii), Which Are Based on the Tables. to Display All Details from the Table Member in Descending Order of Issuedate to Display the Dtype and Number of Dvds in Each Dtype From the Table Dvd. Select Dtitle from Dvd Where Dtype Not in ("Folk", "Classical" ) ;
- Consider the Following Dept and Employee Tables. Write Sql Queries for (I) to (Iv) and Find Outputs for Sql Queries (V) to (Viii). to Display Eno, Name, Gender from the Table Employee in Ascending Order of Eno. Select Count(*), Dcode from Employee Group by Dcode Having Count(*)>1; Select Max(Doj), Min(Dob) from Employee;
- Introduction to Data Base Concepts and Its Need in C++
- Relational Data model
- Relational Algebra
- Structured Query Language Advantages of Using SQL
- Data Definition Language and Data Manipulation Language
- Data Types - NUMBER/DECIMAL, CHARACTER/VARCHAR/VARCHAR2, DATE
- SQL COMMANDS - CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ….SET…., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY
- Functions in SQL
- Obtaining Results (Select Query) from 2 Tables Using equi-join
- Cartesian Product and Union
