Anasayfa » Ceng 351 / Database

Database Courses – 1 (Introduction)

18 Aralık 2010 1.236 views Yorum Yok Kii

Introduction to Database Management Systems

Basic terms which we will use in this lecture:

schema = structure

instance = data

data dictionary (containing name of the tables)

SQL is a

data management language (dynamic ones)

insert a record

update a record

delete a record

query language

select

data defining language (static ones)

create table

alter table

drop table

table = schema + instance

schema of database = colection of (sum of) table schemas

instance of database = colection of (sum of) instances of tables

Data Models

?   Relatioanal (Table = schema + instance )

?   E-R Diagram ( Entity-Relationship)

This is enough for the beginning:) See you..

Yoruma Açığız! :)

Be nice. İçeriği çirkin olmadığı sürece her yoruma, öneriye ve soruya "evet" :)

Etiketler: , , ,