At the end of this lesson-
1. You will be able to explain different database Model.
3. You will be able to explain different key Fields(Candidate key, Primary key, Composite primary key and Foreign key).
Database Model: A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated. The most popular example of a database model is the relational model, which uses a table-based format. Some database models:
1. Linear model
2. Entity-relationship mo...
Read More
ICT HSC (English Version)
Sixth Chapter Lesson-6: Database sorting and indexing.
At the end of this lesson-
1. You will be able to explain concept of database sorting.
2. You will be able to explain concept of database indexing.
3. You will be able to describe advantages and disadvantages of indexing.
4. You will be able to differentiate between sorting and indexing.
Database Sorting: Sorting is the process of arranging the records in either ascending or descending order based on specific fields to make reported data more usable.Sorting a table would create a copy of the table in which the rows may have a different order than the original. Storin...
Read More
Sixth Chapter Lesson-5: Different SQL commands of database.
At the end of this lesson-
1. You will be able to write DDL commands of SQL.
2. You will be able to write DML commands of SQL.
3. You will be able to write DQL commands of SQL.
Data Definition Language (DDL):
Syntax of SQL Command for Creating Database:
CREATE DATABASE database_name;
SQL Command for creating a database named db_sagc
CREATE DATABASE db_sagc;
Syntax of SQL Command for Creating Table:
CREATE TABLE table_name
( column_name_1 data_type(size),
column_name_2 data_type(size),
.............................
column_name_n ...
Read More
Sixth Chapter Lesson-4: Database queries, Query Languages and Different operators.
At the end of this lesson-
1. You will be able to explain different database queries.
2. You will be able to explain different query languages.
2. You will be able to explain different database operators.
Query: A query is a request for data or information from a database table or combination of tables.
Types of query:
1.Select Query
2.Parameter Query
3.Crosstab Query
4.Action Query
Select Query: Select query is used to retrieve data from a table by selecting fields. It is the mostly used SQL query.
Parameter Query: A parameter query is one of the...
Read More
Sixth Chapter Lesson-3: Creating database & table and field’s data type.
At the end of this lesson-
1. You will be able to create database using DBMS.
2. You will be able to create database table using DBMS.
3. You will be able to explain different field’s data type.
Creating database: For creating a database “MS Access 2010” as DBMS is used. First of all, “MS Access 2010” should be installed. After completing installation, if it is opened, the following window will be appeared.
You can change the database name (file name) and database location as you want from the right side.Next click the create button and database will be created.
...
Read More
Sixth Chapter Lesson-2: Database Management System(DBMS) and RDBMS.
At the end of this lesson-
1. You will be able to explain concept of DBMS.
2. You will be able to describe the functions of DBMS.
3. You will be able to describe advantages and disadvantages of DBMS.
4. You will be able to describe RDBMS, uses of RDBMS and advantages of RDBMS.
5. You will be able to describe DBA and it's functions.
DBMS: A Database Management System (DBMS) is one kind of system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. The DBMS essential...
Read More
Sixth Chapter Lesson-1: Concept of Database.
At the end of this lesson-
1. You will be able to explain data and information.
2. You will be able to distinguish data over information.
3. You will be able to explain data hierarchy.
4. You will be able to explain the advantages and disadvantages of database.
5. You will be able to describe the application areas of database.
Data: Data is raw, unorganized facts that need to be processed. For getting desired output in a processing data is used as input. Data can be defined as a representation of facts and it is the smallest part of information. Data is represent...
Read More
First Chapter Lesson-3: Principal elements related to the concept of global village.
At the end of this lesson-
1. You will be able to explain different types of communications.
2. You will be able to explain the easiest ways of communication.
3. You will be able to explain the role of ICT in employment sector.
4. You will be able to explain the role of ICT in education sector.
5. You will be able to explain the role of ICT in treatment sector.
6. You will be able to explain the role of ICT in research sector.
7. You will be able to explain the role of ICT in office management sector.
8. You will be able to explain the role of ICT in creating smart home sector.
9. Y...
Read More
First Chapter Lesson-2: Global village, Advantages & Disadvantages of global village.
At the end of this lesson-
1. You will be able to explain the concept of global village.
2. You will be able to explain the elements for establishing global village.
3. You will be able to explain the advantages and disadvantages of global village.
4. You will be able to describe the principal elements related to concept of global village.
Go for Bangla Version
Global village:
Global village is such an environment where the world considered as a single community in which telecommunications link the inhabitants together.
In other words, Global village is an idea where al...
Read More
First Chapter Lesson-1: Concept of Information and Communication Technology
At the end of this lesson-
1. You will be able to explain the concept of ICT.
2. You will be able to explain the concept of information technology and communication technology.
3. You will be able to explain the different types of information and communication technologies.
4. You will be able to describe various machines related to information and communication technology.
Go for Bangla Version
Data:Datum is a singular form of Data. It is the smallest part of information that's stored in or used by a computer.
Types of Data:
Information: Information is organized or ...
Read More
HSC ICT Chapter 1 : Comprehension Based Questions & Answers
How to write answers to a comprehension based question?
⇒ 'Comprehension' refers to the ability to understand the meaning of a topic. It can be the ability to understand any information, policy, formula, rule, procedure, process etc.
⇒ Perceptual level is the second level of thinking skills. This question is given in 'b'. Such questions do not directly ask for textbook-like details. So the student has to explain or describe the content in his own way.
⇒ Marks of comprehension based question will be 2. Out of which 1 is for knowledge and 1 is for comprehension.
⇒ Comprehension based q...
Read More
First Chapter: Knowledge Based Questions & Answers.
What is data?
Data is the unprocessed raw material. In another way data is the smallest unit of information.
What is information?
The output that we get by processing data is known as information. We get full concept about any object or person from information.
What is information technology?
The technology related to collecting, storing, processing, carrying and analysing information is known as information technology.
What is communication technology?
The technology related to transferring information from one place to another flawlessly is known as information...
Read More