Page 372 - TP_IT_V1.0_C10_flipbpookl
P. 372
21 st
Century #Media Literacy
Skills
Video based question Scan the
QR Code
Watch the video and answer the questions. - https://youtu.be/TUXIQHWYPSQ?si=azVFtNRW-TwElmhF
What is the purpose of a Foreign Key in a relational database?
Explain the concept of Referential Integrity in database management.
REVISIT
▶ A database is an organised collection of structured information or data, typically stored in tabular format.
▶ Data is a collection of values in the form of text, numbers, dates, images, audios, videos, etc
▶ Flat file stores data in a plain text format.
▶ Relational file stores data of different data types like text, number, date in the form of rows and columns to form
a table.
▶ Information is processed, organised, and meaningful data that provides context, relevance, and value.
▶ To store and manage the data in a database electronically we use a Database Management System software.
▶ A data model in Database Management Systems (DBMS) is a conceptual representation of how data is
organised and structured within the database.
▶ The relational database model is a conceptual framework used to organise and structure data in a tabular
format, consisting of rows and columns.
▶ Tables are the basic structure of a database where data is stored.
▶ Fields or columns are the individual pieces of data stored within a table.
▶ Key is a field or combination of fields that uniquely identify a record (row) in a table.
▶ Relationships define how tables within a database are related to each other.
▶ Constraints are rules that enforce data integrity within a database.
▶ A primary key uniquely identifies each record (row) in a table.
▶ In a Relational Database Management System (RDBMS), objects are fundamental entities used to store,
represent, or manipulate data within the database.
▶ Data types help you define the type of the data that can be stored in a field/ column.
▶ Referential integrity is a fundamental rule in relational databases that ensures the consistency and validity of
relationships between tables.
▶ Query is a set of commands that generates a request to access or manipulate data in a table.
▶ Wildcard characters are used to retrieve a set of records from a table that contains some specified character.
▶ Structured Query Language (SQL) is the standard language for managing relational databases and performing
various operations on the data in the tables.
▶ Form is a database object which is used to create an interactive user interface by connecting it with a table.
▶ A report displays the retrieved data in an appealing and customised format.
370 Trackpad Information Technology (Ver. 1.0)-X

