Basic components of DBMS

1. Table:

A table is a collection of related data organized in rows and columns, representing entities in the database.

A field is a single piece of data within a table representing a specific attribute of the entity.

A record is a complete set of related fields, representing a single instance or row in a table.

Data types define the kind of data a field can hold, such as text, number, date, or boolean

Name of Data Type	Description of Data Type	Example
Integer	Represents whole numbers without decimal points.	42, -17, 0
String	Represents a sequence of characters.	"Hello", "Database", "123"
Date	Represents a date or date and time.	"2023-08-01", "15:30:00"
Float/Double	Represents numbers with decimal points.	3.14, -99.99, 0.0
Boolean	Represents a binary value (True or False).	True, False
Char	Represents fixed-length character strings.	"ABC", "X", "John"

Views are virtual tables generated from the data in one or more tables, presenting a customized subset of the data to users.

Open the database management software and create a new blank database.
Click on the “Create” tab and select “Table Design” to open the design view.
Define the table’s fields by entering the field names, data types, and other properties.
Set a primary key by selecting a field and clicking the “Primary Key” button.
Save the table and provide it with a meaningful name.
Add additional fields, set their data types, and define any necessary constraints.
Set relationships with other tables if required using the “Lookup Wizard” or direct relationship connections.
Save the table design, and it will be created in the database with the specified fields and properties.

Open the database management software and open the database where you want to create the query or view.
Click on the “Create” tab and select “Query Design” or “View Design” to open the design view.
In the “Show Table” dialog, add the tables you want to use in your query or view.
Drag and drop the desired fields from the tables into the “Query Design” or “View Design” grid to include them in the query or view.
Specify the criteria for the query or view by adding conditions to the “Criteria” row of the relevant fields.
If needed, add sorting to the query or view by using the “Sort” row of the fields.
For queries, you can add calculated fields using expressions in new columns.
Save the query or view with a meaningful name to access it later, and then run it to see the results.