Rathore's Academy Live Stream IT Database System Important Question REVISION CBSE -23 CLASS 10
Important Question Answers of Database Management System REVISION CBSE BOARD -23 CLASS 10 IT-402
MCQ of Database Management System REVISION CBSE BOARD -23 CLASS 10 IT-402
Concepts of DBMS All 5 sessions with NCERT All important Topics Covered
Important Links
1.Part B -Subject Specific Skills NCERT PDF LINK https://cbseacademic.nic.in/web_mater...
2. Part A- Employability Skills NCERT PDF LINK https://cbseacademic.nic.in/web_mater...
3. Syllabus IT - 402 Session 23-24
https://cbseacademic.nic.in/web_mater...
4. Sample Question Paper From CBSE https://cbseacademic.nic.in/web_mater...
5. Marking Scheme of Sample Q Paper https://cbseacademic.nic.in/web_mater...
How to fix JRE Error
• #how to #how to Download and Install OpenO...
Full Playlist Link ::::
• Database Management System
We will cover the following: You can Watch the detailed Videos too, Link is given with topics.
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC)
SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT
SYSTEM
• Appreciate the Concept of Database Managem...
• Appreciate the Concept of Database Managem...
SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS
• Create And Edit Tables Using Wizard & SQL ...
• Create And Edit Tables Using Wizard & SQL ...
SESSION 3: PERFORM OPERATIONS ON TABLE
• Perform Operations on Table Unit -3 Databa...
• Perform Operations on Table Unit -3 Databa...
SESSION 4: RETRIEVE DATA USING QUERY
• Retrieve Data using Query | Database Manag...
SESSION 5: CREATE FORMS AND REPORTS USING WIZARD
• Create Forms and Reports using Wizard | Un...
SQL Commands Watch Full video for full marks in SQL Commands Questions
• Class 10 IT Unit 3 Structured Query Langua...
• Class 10 IT Unit 3 Structured Query Langua...
The Topics Covered are:
SESSION 1: APPRECIATE CONCEPT OF DATABASE
MANAGEMENT SYSTEM
DBMS, Database Servers, Advantages of DBMS, Features of DBMS(Data redundancy, data integrity, data consistency, data security, data backup and recovery, data sharing, data privacy)
SESSION2:CREATE AND EDIT TABLES USING WIZARD & SQL COMMANDS
DBMS and RDBMS : Tables, Columns Rows, Attributes Tuples, Fields records,
Keys : primary key, foreign key, candidate key, alternate key composite primary key, Referential integrity
DATABASE OBJECTS : Tables, Columns or Fields or Attributes, Rows or Records or Tuples,
CREATING DATABASE USING OPENOFFICE :: CREATING DATABASE USING OPENOFFICE, Using Design View
Data Types
• Numeric Types
• Alphanumeric Types
• Binary Types
• Date time
• Other Variable types
SESSION 3: PERFORM OPERATIONS ON TABLE
Inserting Data In The Table
Editing Records In The Table
Deleting Records In The Table
Field Properties : Format, Default values, Entry Required, Length, Auto value
Sorting Ascending and /descending Order
Relationships between tables: Types (One to one, one to many or MANY to ONE, many to many)
Creating Relationship between tables , Remove the Relationships
SESSION 4: RETRIEVE DATA USING QUERY
Query Creation Using Wizard
Creation Of Query Using Design View using SQL query
SESSION 5: CREATE FORMS AND REPORTS USING WIZARD
Creating Form Using Wizard
Creating Form Using Design View
Creating Report Using Wizard
