🗊Презентация Introduction to Database design

Категория: Информатика
Нажмите для полного просмотра!
Introduction to Database design, слайд №1Introduction to Database design, слайд №2Introduction to Database design, слайд №3Introduction to Database design, слайд №4Introduction to Database design, слайд №5Introduction to Database design, слайд №6Introduction to Database design, слайд №7Introduction to Database design, слайд №8Introduction to Database design, слайд №9Introduction to Database design, слайд №10Introduction to Database design, слайд №11Introduction to Database design, слайд №12Introduction to Database design, слайд №13Introduction to Database design, слайд №14

Вы можете ознакомиться и скачать презентацию на тему Introduction to Database design. Доклад-сообщение содержит 14 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации


Слайд 1







LECTURE 1
 Introduction to
Database design

IITU, ALMATY, 2014
DATABASE DESIGN 
Lyudmila Kozina, senior lecturer
Описание слайда:
LECTURE 1 Introduction to Database design IITU, ALMATY, 2014 DATABASE DESIGN Lyudmila Kozina, senior lecturer

Слайд 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.
Описание слайда:
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.
Описание слайда:
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?
Описание слайда:
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.
Описание слайда:
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
Описание слайда:
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
Описание слайда:
What is a database? Database is an organized collection of data Databases have a structure

Слайд 8





Phone book’s DB
Описание слайда:
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 …
…
Описание слайда:
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.
Описание слайда:
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
Описание слайда:
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)
Описание слайда:
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





What’s next?
	Next week lessons introduce the entity-relational model and how to design the schema of a database.
Описание слайда:
What’s next? Next week lessons introduce the entity-relational model and how to design the schema of a database.

Слайд 14





Books
Connolly, Thomas M. Database Systems: A Practical Approach to Design, Implementation, and Management / Thomas M. Connolly, Carolyn E. Begg.- Fifth.- United States of America: Pearson Education, 2010
Garcia-Molina, H. Database system: The Complete Book / Hector Garcia-Molina.- 2.- United States of America: Pearson Prentice Hall, 2009
Sharma, N. Database Fundamentals: A book for the community by the community / Neeraj Sharma, Liviu Perniu.- First Edition.- Canada, 2010
Описание слайда:
Books Connolly, Thomas M. Database Systems: A Practical Approach to Design, Implementation, and Management / Thomas M. Connolly, Carolyn E. Begg.- Fifth.- United States of America: Pearson Education, 2010 Garcia-Molina, H. Database system: The Complete Book / Hector Garcia-Molina.- 2.- United States of America: Pearson Prentice Hall, 2009 Sharma, N. Database Fundamentals: A book for the community by the community / Neeraj Sharma, Liviu Perniu.- First Edition.- Canada, 2010



Похожие презентации
Mypresentation.ru
Загрузить презентацию