LO: To define the term database.
To analyze the basic relational model elements SUCCESS CRITERIA
Database: Collection of interconnected relations.
To define database
Database Management System (DBMS): Software system which is used to manage Database.
DBMS acts as an interface between a user and database which enables the user to create,
insert, retrieve, update and delete the data.
To explain the key
Relation/Table: Relation is also known table. And table is a collection of related data and elements of RDBMS
information in row and column. Relation is composed of rows and columns.
Row/Tuple/Record: Row represent horizontal form of Table/Relation. To identify the keys in
a relation
Column/Attributes/Fields: Column represent vertical form of Table/Relation.
Cardinality: Total number of row/record/tuple in a relation. To differentiate DBMS
& RDBMS
Degree: Total number of column/attributes in a relation.
Primary Key: Primary Key is a unique identifier which identify unique record in a particular table. It must contain
unique values for each record. And Primary key attribute/column/field can’t be NULL.
Candidate key: Keys which are eligible for primary key and can be used as primary key in a table. From the set of
these candidate key, one column is selected as primary key.
Alternate Key: After selecting primary key from candidate key, the remaining keys are called Alternate Key.
Foreign Key: A Foreign key is a column or group of columns in a table that provides a link between two tables.
LO: To explore the data types supported by MySQL.
KEYWORDS
To define the term constraint. SUCCESS CRITERIA
To assign constraints to the given relation. Datatypes
Constraint To assign the most
suitable data types
for a given scenario.
To analyze the
potential errors
when choosing
incorrect data type.
To define the term
constraint.
To apply constraints
on the given
relation.
MySQL constraints are rules
for the data that can be
entered into a field or
relation, i.e., constraints are
basically limitations or
restrictions on the data
type. Hence, they ensure
the data’s reliability,
consistency, and accuracy.
LO: To apply basic SQL commands.
To design and manage database structures. SUCCESS CRITERIA
To construct complex queries for data analysis.
To execute basic SQL
SQL is shortened of Structured Query Language. commands.
To create relation
SQL is language that help user to communicate with databases.
with appropriate
SQL is not case sensitive language means you can type your query in small or capital letter as per
data types and
user.
constraints.
Query is a request in the form of SQL command to retrieve information with some condition.
To modify database
SQL Commands: Predefined set of commands in SQL. Commands are basically combination of structures using
keyword and statement you want to execute. Keywords are reserved words that has special suitable SQL
meaning for SQL. command.
To retrieve and filter
Clause: Clause are built in functions which is use to deal with data inside the table that help data using various
SQL to filter and analyses data quickly. clauses.
All SQL statements are terminated with (;) semicolon
LO: To apply basic SQL commands.
To design and manage database structures. SUCCESS CRITERIA
To construct complex queries for data analysis.
To execute basic SQL
commands.
To create relation
with appropriate
data types and
constraints.
To modify database
structures using
suitable SQL
command.
To retrieve and filter
data using various
clauses.
Creating database
and relation
Showing the
structure of table
Inserting records
Dropping a table
Changing structure
of table
