Fergana branch of tashken university of information technologies named after al

Candidate keys:  
 
The set of columns that can each uniquely identify a record and from 
which the primary key is chosen. 
Primary keys:  
This key uniquely identifies a record in a table. It cannot be null. 

---

 
5 
 
Foreign keys:  
 
The key linking a record to a record in another table. A table's foreign key 
must exist as the primary key of another table. 
NoSQL 
 
NoSQL is a database model developed to respond to the need for storing 
unstructured data such as emails, social media posts, video, or images. 
Rather than using SQL and the strict ACID model to ensure data integrity, 
NoSQL follows the less-strict BASE model. A NoSQL database schema 
does not use tables to store data; rather, it might use a key/value design or 
graphs. 
Structured Query 
Language 
 
Structured Query Language, or SQL, is the most commonly used language 
to access data from a database. SQL branches into two types of syntax. 
The Data Manipulation Language contains the subset of SQL 
commands used most frequently and includes SELECT, INSERT, 
UPDATE and DELETE. The Data Definition Language creates new 
database objects like indexes and tables. 
View 
 
A database view is a filtered set of data displayed to the end user in order 
to hide data complexity and streamline the user experience. A view can 
join data from two or more tables and contains a subset of information. 
A materialized view is a view that looks and acts as if it were a table in its 
own right. 
 
APPENDIX 3. LANGUAGE  
Watch a video and do exercises 
“by+Ving” 
 
 
Task 1. Work in pairs. Ask and answer questions about how to do these things 
See sample: enter data in a database (form) 
 
A: How do you enter data into database? 
B: You can do that by opening a form and entering the data into the fields 
 
1.  Find information (query) in database  
2.  Add a column of numbers in a spreadsheet (sum/formula/spreadsheet) 
3.  Make sure each record in database is unique (use/primary key) 
4.  Print information from a database (run/report) 
 

---

 
6 
 
APPENDIX 4. READING 
Read, discuss and do exercises