Оцените презентацию от 1 до 5 баллов!
Тип файла:
ppt / pptx (powerpoint)
Всего слайдов:
14 слайдов
Для класса:
1,2,3,4,5,6,7,8,9,10,11
Размер файла:
1.77 MB
Просмотров:
55
Скачиваний:
0
Автор:
неизвестен
Слайды и текст к этой презентации:
№1 слайд
Содержание слайда: 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
№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.
№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
№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.
№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.
№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.
№10 слайд
№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.
№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
№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