# Series on the Oracle database system: Database design and very basic SQL

- Institution: CERN
- Department: IT Informatics Tutorial
- Speaker: Paula Figueiredo (CERN-IT-DB)
- Year: 2002
- Language: English
- Subjects: Art, architecture and design
- Source: [CERN](https://videos.cern.ch/record/3019572)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

Database design is an important phase of the database development process.

Basic concepts and methodologies used on the several database design phases will be covered:

- Identification of the main components of the Entity-Relationship Diagram (ERD). - Translating the ERD into relational tables (relational model) - Data normalization

Communicating with the database using basic SQL statements will also be presented..

0:00:00 Slide 1

6:48:18 Slide 2

6:48:34 Slide 3

6:48:58 Slide 4

6:49:28 Slide 5

6:49:45 Slide 6

6:50:35 Slide 7

6:51:04 Slide 8

6:51:28 Slide 9

6:52:21 Slide 10

6:52:39 Slide 11

6:52:55 Slide 12

6:53:24 Slide 13

6:54:04 Slide 14

6:55:17 Slide 15

6:55:58 Slide 16

6:56:46 Slide 17

6:57:32 Slide 18

6:58:07 Slide 19

6:58:43 Slide 20

6:59:18 Slide 21

6:59:48 Slide 22

7:00:24 Slide 23

7:00:51 Slide 24

7:01:16 Slide 25

7:01:38 Slide 26

7:02:09 Slide 27

7:02:50 Slide 28

7:03:07 Slide 29

7:03:36 Slide 30

7:04:21 Slide 31

7:05:26 Slide 32

7:05:53 Slide 33

7:06:40 Slide 34

7:07:08 Slide 35

7:07:27 Slide 36

7:08:11 Slide 37

7:08:47 Slide 38

7:09:09 Slide 39

7:10:45 Slide 40

7:11:37 Slide 41

7:11:58 Slide 42

7:12:36 Slide 43

7:13:11 Slide 44

7:13:54 Slide 45

7:14:38 Slide 46

7:15:01 Slide 47

7:15:25 Slide 48

7:16:17 Slide 49

7:16:31 Slide 50

7:17:07 Slide 51

7:17:25 Slide 52

7:17:37 Slide 53

7:18:39 Slide 54

7:19:23 Slide 55

7:19:41 Slide 56

7:20:12 Slide 57

7:20:57 Slide 58

7:21:45 Slide 59

7:22:34 Slide 60

7:23:35 Slide 61

7:24:02 Slide 62

7:24:23 Slide 63

7:25:56 Slide 64

7:26:03 Slide 65

7:27:10 Slide 66

7:27:27 Slide 67

## Lectures

1. [Series on the Oracle database system: Database design and very basic SQL](https://invisiblenetwork.ai/learn/cern/3019572/225de2344318), 40 min (CERN's player)