数据库基础课堂笔记第六章

最新推荐文章于 2023-11-08 14:35:39 发布

Chow Yun-thin

最新推荐文章于 2023-11-08 14:35:39 发布

阅读量212

点赞数

分类专栏：零散的课堂笔记文章标签：数据库

本文链接：https://blog.csdn.net/qq_44761507/article/details/106143486

版权

零散的课堂笔记专栏收录该内容

20 篇文章 2 订阅

订阅专栏

文章目录

Database Design

Database Design

6.1 Introduction to E-R Concepts

在这里插入图片描述

distinguishable
having common properties

Example: Classrooms

distinguishable: using room number
common properties : seating capacity

Entities are represented by rectabgles in E-R diagrams

在这里插入图片描述

在这里插入图片描述

identifiers
descriptors
multi-valued attribute
composite attribute

Transfroming Entities and Attributes to Relations
在这里插入图片描述

Relationships among Entities

Relationships are represented by diamonds in an E-R diagram

6.2 Further Details of E-R Modeling

Cardinality of Entity Participation in a Relationship
card(E, R)
One-toOne, Many-to-Many, and Many-to-one Relationships
Transfroming Binary Relationships to Relations

6.3 Additional E-R Concepts

在这里插入图片描述

Weak Entities
在这里插入图片描述

在这里插入图片描述

Generalization Hierarchies

6.5 Normalization: Preliminaries

In the normalization approach, the designer starts whith a real-world situation to be modeled and lists the data items that are candidates to become column names in relational tables, together with a list of rules about the relatedness of these data items. The aim is to represent all these data items as data items as attributese of tables that obey restrictive conditions associated with what we call normal froms
. These normal form definitions limit the acceptable form of a table so that it has certain desirable properties, thus avoiding variouts kinds of anomalous behavior.
在这里插入图片描述

在这里插入图片描述

A 3NF decomposition constructed to have the three desirable properties just mentioned is generally considered an acceptable database design.