Database fundamentals
-
The research content in the thesis is the current problems which are renewed with a series of works of foreign authors; while in the country (in Vietnam), there are many published works related to methods and algorithms finding reducts of a decision table by different approaches. The objective of the thesis is to research some analyzed problems in range of relational databases.
26p xacxuoc4321 08-07-2019 38 5 Download
-
Bài giảng "Bảo mật cơ sở dữ liệu - Chapter 7: Database auditing models" trình bày các nội dung: Gain an overview of auditing fundamentals, understand the database auditing environment, create a flowchart of the auditing process, list the basic objectives of an audit. Mời các bạn cùng tham khảo.
49p thangnamvoiva20 20-09-2016 95 9 Download
-
Chapter 1 - Getting started. After completing this unit, you should be able to: Identify the purpose and scope of this book, know the potential problems with lists, understand the reasons for using a database, understand how related tables avoid the problems of lists, learn the components of database system, learn the elements of a database, learn the purpose of the database management system (DBMS), understand the functions of a database application.
32p tangtuy17 11-07-2016 43 2 Download
-
Chapter 2 - The relational model. In this chapter students will be able to: Learn the conceptual foundation of the relational model, understand how relations differ from nonrelational tables, learn basic relational terminology, learn the meaning and importance of keys, foreign keys, and related terminology, understand how foreign keys represent relationships.
41p tangtuy17 11-07-2016 41 2 Download
-
Chapter 3 - Structured Query Language. After completing this unit, you should be able to: Learn basic SQL statements for creating database structures, learn SQL statements to add data to a database, learn basic SQL SELECT statements and options for processing a single table, learn basic SQL SELECT statements for processing multiple tables with subqueries,...
46p tangtuy17 11-07-2016 45 2 Download
-
Chapter 4 - Data modeling and theentity-relationship model. In this chapter students will be able to: Learn the basic stages of database development, understand the purpose and role of a data model, know the principal components of the E-R data model, understand how to interpret traditional E-R diagrams, understand how to interpret Information Engineering (IE) Crow’s Foot E-R diagrams,…
54p tangtuy17 11-07-2016 38 2 Download
-
Learning objectives of this chapter include: Learn how to transform E-R data models into relational designs; practice the normalization process from chapter 2; understand the need for denormalization, learn how to represent weak entities with the relational model; know how to represent 1:1, 1:N, and N:M binary relationships.
40p tangtuy17 11-07-2016 44 2 Download
-
Upon completion of this lesson, the successful participant will be able to: Understand the need for and importance of database administration; learn different ways of processing a database; understand the need for concurrency control, security, and backup and recovery; learn typical problems that can occur when multiple users process a database concurrently; understand the use of locking and the problem of deadlock;…
62p tangtuy17 11-07-2016 40 2 Download
-
Chapter 7 - Database processing applications andbusiness intelligence. In this chapter, you will learn: Understand and be able to set up Web database processing, learn the basic concepts of Extensible Markup Language (XML), learn the basic concepts of business intelligence (BI) systems, learn the basic concepts of OLAP and data mining.
61p tangtuy17 11-07-2016 36 2 Download
-
Chapter 1 introduction and conceptual modeling. To understand the fundamentals of database technology, however, we must start from the basics of traditional database applications. we start by defining a database, and then explaining other basic terms,...
24p kiepnaybinhyen_04 15-12-2015 83 5 Download
-
In this chapter presenting the terminology and basic concepts that will be used throughout the lecture. This chapter discusses data models and defines the concepts of schemas and instances, which are fundamental to the study of database systems, discuss the three-schema DBMS architecture, provides a user’s perspective on what a DBMS is supposed to do, describe the types of interfaces and languages that are typically provided by a DBMS,...
33p kiepnaybinhyen_04 15-12-2015 66 3 Download
-
In chapter 3, we follow the traditional approach of concentrating on the database structures and constraints during conceptual database design. The design of application programs is typically covered in software engineering courses. this chapter also present the modeling concepts of the Entity-Relationship (ER) model, which is a popular high-level conceptual data model.
38p kiepnaybinhyen_04 15-12-2015 69 3 Download
-
In this chapter, we describing features that have been proposed for semantic data models, and show how the ER model can be enhanced to include these concepts, leading to the Enhanced ER (EER) model.
22p kiepnaybinhyen_04 15-12-2015 43 2 Download
-
Chapter 4 (Part II) - Enhanced Entity-Relationship and UML modeling include contens as: Fundamental principle of modeling, basic process of modeling, add constraints - structural/ semantic,...
29p kiepnaybinhyen_04 15-12-2015 70 2 Download
-
In this chapter, The contents concentrate on describing the basic principles of the relational model of data, begin by defining the modeling concepts and notation of the relational model, discussion of relational constraints that are considered an important part of the relational model and are automatically enforced in most relational DBMSs, defines the update operations of the relational model,...
29p kiepnaybinhyen_04 15-12-2015 58 2 Download
-
Chapter 7 discusses how to design a relational database schema based on a conceptual schema design. This chapter presented a high-level view of the database design process, and in this chapter we focus on the logical database design or data model mapping step of database design. We present the procedures to create a relational schema from an Entity-Relationship (ER) or an Enhanced ER (EER) schema.
32p kiepnaybinhyen_04 15-12-2015 85 4 Download
-
In this chapter we discuss the two formal languages for the relational model: the relational algebra and the relational calculus. The main contents in this chapter include: Example database application (COMPANY), overview of the QBE language (appendix D),...
53p kiepnaybinhyen_04 15-12-2015 51 3 Download
-
Chapter 8 describes more advanced features of the SQL language standard for relational databases. In this chapter present more complex features of SQL retrieval queries, such as nested queries, joined tables, outer joins, aggregate functions, and grouping.
71p kiepnaybinhyen_04 15-12-2015 59 3 Download
-
Chapter Objectives: Specification of more general constraints via assertions, SQL facilities for defining views (virtual tables), various techniques for accessing and manipulating a database via programs in general-purpose languages (e.g., Java).
45p kiepnaybinhyen_04 15-12-2015 50 3 Download
-
Chapter 10 present functional dependencies and normalization for relational databases. This chapter includes contents: Informal design guidelines for relational databases, functional dependencies (FDs), normal forms based on primary keys, general normal form definitions (For Multiple Keys), BCNF (Boyce-Codd Normal Form).
49p kiepnaybinhyen_04 15-12-2015 64 3 Download