Develop a database system with evidence of a user
interface, output and validations and querying around
multiple tables (P2)
Data manipulation-This is the process of changing data to make it easier to read or be more
organized. For example, a log of data could be organized in alphabetical order, making
individual entries easier to locate
A data manipulation language (DML)-This is a computer programming language used for adding
(inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage
of a broader database language such as SQL, with the DML comprising some of the operators in
the language
Select statement
Statement is used to retrieve rows from one or more tables. The statement can also include
UNION statements and subqueries. SELECT statement is used to fetch rows or records from one
or more tables. Indicating all columns
SELECT* FROM TABLE NAME
SELECT [column name] from [table name] where condition
Example
INSERT STATEMENT –This is used to add data into the table
INSERT INTO [table name] [column] VALUES [values]
Example
, UPDATE STATEMENT – This statement is used to modify one or more records
UPDATE table name SET [column name= value] where condition]
Example
DELETE STATEMENT – This statement is used to delete one or more records
DELETE FROM table name where [conditions]
Example
interface, output and validations and querying around
multiple tables (P2)
Data manipulation-This is the process of changing data to make it easier to read or be more
organized. For example, a log of data could be organized in alphabetical order, making
individual entries easier to locate
A data manipulation language (DML)-This is a computer programming language used for adding
(inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage
of a broader database language such as SQL, with the DML comprising some of the operators in
the language
Select statement
Statement is used to retrieve rows from one or more tables. The statement can also include
UNION statements and subqueries. SELECT statement is used to fetch rows or records from one
or more tables. Indicating all columns
SELECT* FROM TABLE NAME
SELECT [column name] from [table name] where condition
Example
INSERT STATEMENT –This is used to add data into the table
INSERT INTO [table name] [column] VALUES [values]
Example
, UPDATE STATEMENT – This statement is used to modify one or more records
UPDATE table name SET [column name= value] where condition]
Example
DELETE STATEMENT – This statement is used to delete one or more records
DELETE FROM table name where [conditions]
Example
