🗊Презентация Database Management Systems 1

Категория: Устройства и комплектующие
Нажмите для полного просмотра!
Database Management Systems 1, слайд №1Database Management Systems 1, слайд №2Database Management Systems 1, слайд №3Database Management Systems 1, слайд №4Database Management Systems 1, слайд №5Database Management Systems 1, слайд №6Database Management Systems 1, слайд №7Database Management Systems 1, слайд №8Database Management Systems 1, слайд №9Database Management Systems 1, слайд №10Database Management Systems 1, слайд №11Database Management Systems 1, слайд №12Database Management Systems 1, слайд №13Database Management Systems 1, слайд №14
Скачать
Вы можете ознакомиться и скачать презентацию на тему Database Management Systems 1. Доклад-сообщение содержит 14 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

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

Слайд 1


Number of credits: 3 (2/1/0) Term: Spring 2018 Instructor’s full name: Lyazat Naizabayeva
Описание слайда:
Number of credits: 3 (2/1/0) Term: Spring 2018 Instructor’s full name: Lyazat Naizabayeva

Слайд 2


Data Administrator Data Administrator Database Administrator Database designer Database Design Process The architecture of a database management systems
Описание слайда:
Data Administrator Data Administrator Database Administrator Database designer Database Design Process The architecture of a database management systems

Слайд 3


Database Management Systems 1, слайд №3
Описание слайда:

Слайд 4


Advantages of the approach using a database management system: Advantages of the approach using a database management system: • it reduces redundancy; • eliminates the inconsistency; • sharing of data; • comply with the standards; • introduce security measures; • supports data integrity.
Описание слайда:
Advantages of the approach using a database management system: Advantages of the approach using a database management system: • it reduces redundancy; • eliminates the inconsistency; • sharing of data; • comply with the standards; • introduce security measures; • supports data integrity.

Слайд 5


Data Administration: A high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate-wide definitions and standards Database Administration: A technical function that is responsible for logical and physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery
Описание слайда:
Data Administration: A high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate-wide definitions and standards Database Administration: A technical function that is responsible for logical and physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery

Слайд 6


Data Administrator is responsible for : Data Administrator is responsible for : Specification of organization data. The design and maintenance of data management application. Validating the data and files. Security of files or databases. Database Administrator is responsible for : reviewing the contents in the database designing, implementing the database to backed up data regularly prevent from unauthorized access.
Описание слайда:
Data Administrator is responsible for : Data Administrator is responsible for : Specification of organization data. The design and maintenance of data management application. Validating the data and files. Security of files or databases. Database Administrator is responsible for : reviewing the contents in the database designing, implementing the database to backed up data regularly prevent from unauthorized access.

Слайд 7


Database Management Systems 1, слайд №7
Описание слайда:

Слайд 8


The designer will learn from the applications designers The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) work with the developers to design a structure/schema Database designer considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.
Описание слайда:
The designer will learn from the applications designers The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) work with the developers to design a structure/schema Database designer considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.

Слайд 9


Development and implementation of a database in the organization must be performed in sequence. • Preliminary design • Analysis of feasibility • Determine requirements • Conceptual design • Implementation -select DBMS and get it, - convert the detailed conceptual model in a real model DBMS - create a data dictionary, - populate the database, - develop application programs and to train users. • Testing and maintenance of the database.
Описание слайда:
Development and implementation of a database in the organization must be performed in sequence. • Preliminary design • Analysis of feasibility • Determine requirements • Conceptual design • Implementation -select DBMS and get it, - convert the detailed conceptual model in a real model DBMS - create a data dictionary, - populate the database, - develop application programs and to train users. • Testing and maintenance of the database.

Слайд 10


Database Management Systems 1, слайд №10
Описание слайда:

Слайд 11


Database Management Systems 1, слайд №11
Описание слайда:

Слайд 12


The architecture of a database management system can be divided into three levels: The architecture of a database management system can be divided into three levels: The external level: This presentation describes only part of actually existing database. The conceptual level: conceptual level represents the entire database as a whole, and is used by the database administrator. The internal level: at this level there is a physical data storage, and it is the lowest level in the architecture.
Описание слайда:
The architecture of a database management system can be divided into three levels: The architecture of a database management system can be divided into three levels: The external level: This presentation describes only part of actually existing database. The conceptual level: conceptual level represents the entire database as a whole, and is used by the database administrator. The internal level: at this level there is a physical data storage, and it is the lowest level in the architecture.

Слайд 13


The external level: The external level: cout << “Emp#”<< EMPLOYEE_CODE; cout << “Dept#”<<DEPARTMENT_CODE; cout<< “Salary”<< SALARY; The conceptual level: EMPLOYEE EMPLOYEE_CODE CHARACTER 6 DEPARATMENT_CODE CHARACTER 4 SALARY NUMERIC 5 The internal level: STORED EMPLOYEE LENGTH=18 PREFIX TYPE=BYTE(6), OFFSET=0 EMP# TYPE=BYTE(4), OFFSET=6, INDEX EMPX DEPT# TYPE =BYTE (4), OFFSET=12 SALARY=BYTE (4), OFFSET=16
Описание слайда:
The external level: The external level: cout << “Emp#”<< EMPLOYEE_CODE; cout << “Dept#”<<DEPARTMENT_CODE; cout<< “Salary”<< SALARY; The conceptual level: EMPLOYEE EMPLOYEE_CODE CHARACTER 6 DEPARATMENT_CODE CHARACTER 4 SALARY NUMERIC 5 The internal level: STORED EMPLOYEE LENGTH=18 PREFIX TYPE=BYTE(6), OFFSET=0 EMP# TYPE=BYTE(4), OFFSET=6, INDEX EMPX DEPT# TYPE =BYTE (4), OFFSET=12 SALARY=BYTE (4), OFFSET=16

Слайд 14


Why need to use a database management system? Why need to use a database management system? The major function of data administrator and database administrator. What is the difference between database administrator and database designer? Database Design Process The architecture of a database management system
Описание слайда:
Why need to use a database management system? Why need to use a database management system? The major function of data administrator and database administrator. What is the difference between database administrator and database designer? Database Design Process The architecture of a database management system

Скачать

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