Create and edit tables using wizard and SQL commands |Part - 3| IT 402 | Class 10 | OpenOffice Base|

Опубликовано: 09 Октябрь 2024
на канале: CBSE INFOTECH

44,606

933

#cbseinfotech
#it402
Hello Everyone,
DDL & DML Queries
   • MySQL DDL Commands, Unit-6, Database ...
   • MySQL DML Commands, Unit-6, Database ...
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
****************
Supporting files and SM class 10, IT 402 (2020-21)
https://drive.google.com/drive/folder...
*****************
Theory Part
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
 Introduction to an 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
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Practical Part
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
 Start the RDBMS and observe the parts of the main window,
 Identify the database objects Create the sample table in any category using wizard, Practice to create different tables from the available list, and choosing fields from the available fields.
 Assign data types of field, Set primary key,
 Edit the table in design view, Enter the data in the fields.
 Create and edit table using DDL Commands
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
www.facebook.com/infotechcbse
http://cbseinfotech.blogspot.com/
  / cbseinfotech
  / cbseinfotech
  / gulsan9