Fergana branch of tashken university of information technologies named after al



Download 7,96 Mb.
Pdf ko'rish
bet3/189
Sana31.12.2021
Hajmi7,96 Mb.
#224769
1   2   3   4   5   6   7   8   9   ...   189
Bog'liq
workbook 2

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. 


 

 
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. 
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) 
 


 

 
APPENDIX 4. READING 
Read, discuss and do exercises 
 

Download 7,96 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7   8   9   ...   189




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish