Homepage » Ceng 351 / Database

Database Courses – 1 (Introduction)

18 December 2010 1,338 views No comments

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


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


Any comments are welcome.

Etiketler: , , ,