Lecture 1 – Introduction

1.        OUTLINE          

2.       WHAT IS DATA?            

3.       WHAT IS DATABASE?

4.       RDBMS             

5.       INTEGRITY CONSTRAINTS      

6.       DATA AND DATABASE

7.        DATABASE ACTORS

7.1. “ON THE SCENES”       

7.2.               “BEHIND THE SCENES”            

8.       WHAT IS DATA MODEL?          

9.       SCHEMA           

10.     INTRODUCTION TO DATABASE          

10.1.              DATABASE OBJECTS   

10.1.1. TABLES     

11.       CREATING THE DATABASE      

11.1. Creating the First Table: tblS    

11.2.              Exercise 1: tblA 

11.3.              Exercise 2: tblG

12.      RELATIONS     

First homework