Tham khảo tài liệu 'giáo trình sql bài 8', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Lecture 3 Relational Database Design by ER- and EER-to-Relational Mapping UNIVERSITY Objectives Relational Model concepts Relational Model Constraints and Relational Database Schemas Relational Database Design Using ER-to-Relational Mapping Mapping EER Model Constructs to Relations Reference Chapter 5-7 Faculty of Science and Technology Database Fundamentals 2 UNIVERSITY Relational Model Concepts The relational Model of Data is based on the concept of a Relation The strength of the relational approach to data management comes from the formal foundation provided by the theory of relations We review the essentials of the formal relational model in this chapter In practice there is a standard model based on SQL -this is described in Chapters 8 and 9 Note There are several important differences between the formal model and the practical model as we shall see Faculty of Science and Technology Database Fundamentals