Introduction to Database design

Сентябрь 4, 2022

Главная
Информатика
Introduction to Database design

Содержание

2. Course Outline Objectives Learn the steps of database design process. Learn to design a database based
3. By the end of this course the students will be able to: design a database starting
4. What are your association?
5. Today’s world Nowadays databases are everywhere, but we never see them. They are hidden behind the
6. Databases do most of the work in the information systems that we use every day Almost
7. What is a database? Database is an organized collection of data Databases have a structure
8. Phone book’s DB
9. Ordinary phone book vs. the DB Kate’s phone number Birthdays in January Who is owner of
10. Database management systems Database management systems (DBMSs) are specially designed applications that interact with the user,
11. Database management systems PostgreSQL Microsoft SQL Server Oracle MySQL IBM DB2
12. Database Design Modelling (subject area analisys) Decide which part of reality is represented in a database
13. What’s next? Next week lessons introduce the entity-relational model and how to design the schema of
15. Скачать презентацию

Слайд 2

Course Outline
Objectives
Learn the steps of database design process.
Learn to design

a database based on the user’s requirements.
Learn the Structured Query Language.

Слайд 3

By the end of this course the students will be able

to:

design a database starting from the conceptual stage to the physical implementation of all the database objects;
demonstrate the programming skills with SQL (Structured Query Language);
use database management system (DBMS);
think clearly and logically, as required for critical analysis of problems.

Слайд 4

What are your association?

Слайд 5

Today’s world
Nowadays databases are everywhere, but we never see them. They

are hidden behind the tools and services that we use everyday.

Слайд 6

Databases do most of the work in the information systems that

we use every day
Almost any business has a database
So the need for database professionals in the IT job market will always stay strong

Слайд 7

What is a database?
Database is an organized collection of data
Databases have

a structure

Слайд 8

Phone book’s DB

Слайд 9

Ordinary phone book vs. the DB
Kate’s phone number
Birthdays in January
Who is

owner of this number?
Find all phone number of people with last name …
…

Слайд 10

Database management systems
Database management systems (DBMSs) are specially designed applications that

interact with the user, other applications, and the database itself to capture and analyze data.
A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases.

Слайд 11

Database management systems
PostgreSQL
Microsoft SQL Server
Oracle
MySQL
IBM DB2

Слайд 12

Database Design
Modelling (subject area analisys)
Decide which part of reality is represented

in a database
Agree on structure of the database before deciding on a particular implementation
Conceptual Modelling
- ER diagram
Logical Modelling
Physical Modelling (the physical organization of the data)

Слайд 13