Guide to Oracle 10


Database Approach to Data Processing



Download 0,57 Mb.
bet2/4
Sana11.03.2022
Hajmi0,57 Mb.
#491327
TuriGuide
1   2   3   4
Bog'liq
Joline1

Database Approach to Data Processing

  • Guide to Oracle 10g

Database Systems (continued)

  • Guide to Oracle 10g
  • Database administrator
    • Person responsible for installing, administering, and maintaining the database
    • Often called DBA

Overview of Relational Databases

  • Guide to Oracle 10g
  • Table
    • Matrix with columns and rows
  • Columns
    • Represent different data fields
    • Characteristics or attributes about entity
  • Rows
    • Contain individual records
    • Attributes about a specific instance of entity

Overview of Relational Databases (continued)

  • Guide to Oracle 10g

Overview of Relational Databases (continued)

  • Guide to Oracle 10g
  • Entity
    • Object about which you want to store data
    • Different tables store data about each different entity
  • Relationships
    • Links that show how different records are related

Overview of Relational Databases (continued)

  • Guide to Oracle 10g
  • Key fields
    • Establish relationships among records in different tables
    • Main types of key fields
      • Primary
      • Candidate
      • Surrogate
      • Foreign
      • Composite

Primary Keys

  • Guide to Oracle 10g
  • Column in relational database table whose value must be unique for each row
  • Serves to identify individual occurrence of entity
  • Every row must have a primary key
  • Cannot be NULL
  • NULL
    • Value is absent or unknown
    • No entry is made for that data element

Download 0,57 Mb.

Do'stlaringiz bilan baham:
1   2   3   4




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