Class - X || UNIT - 3 || Database Management Systems || Creating Database & Table || Part - II
In this video, I have discussed the most important questions of Database Development class 10 I.T - 402.
Class - X
Topic: Relational Database Management Systems (Basic)
Unit - 3
#RDBMS #database #IT402
Theory part
Concept and examples of data and information,
Concept of database,
Advantages of database,
Features of database,
Concept and examples of Relational database,
Concept and examples of field, record, table, database,
Concept and examples of Primary key, composite primary key, foreign key,
Relational Data base management system (RDBMS) software.
Practical part
Concept and examples of
data and information,
Concept of database,
Advantages of database,
Features of database,
Concept and examples of
Relational database,
Concept and examples of
field, record, table,
database,
Concept and examples of
Primary key, composite
primary key, foreign key,
Relational Data base
management system
(RDBMS) software.
Identify the data and information,
Identify the field, record, table in the database,
Prepare the sample table with some standard fields.
Assign the primary key to the field,
Identify the primary key, composite primary key, foreign key.
Introduction to a RDBMS
Database objects – tables,
queries, forms, and reports
of the database,
Terms in database – table,
field, record,
Steps to create a table
using table wizard, *
Data types in Base,
Option to set primary key
Table Data View dialog box
DDL Commands
Inserting data in the table,
Editing records in the table,
Deleting records from the
table,
Sorting data in the table,
Referential integrity,
Creating and editing
relationships – one to one,
one to many, many to
many,
Field properties.