当前位置:网站首页>[database] knowledge and skills at the end of the term ----- Chapter 9 database design
[database] knowledge and skills at the end of the term ----- Chapter 9 database design
2022-07-19 04:08:00 【Lambs can't fly】
Chapter nine Database design
1、 What are the stages of database design , What documents are generated ?
1) Demand analysis --- The data dictionary
2) Conceptual structural design ---E-R chart ,UML
3) Logical structure design --- Relationship model
4) Physical structure design
5) Database implementation
6) Database operation and maintenance
2、 The main tasks of each stage ?
The main tasks corresponding to the six stages
1) Investigate and analyze user activity , Collect and analyze demand data and prepare system analysis report
2) The user requirements obtained from requirement analysis are abstracted into information structure E-R chart
3) take E-R The diagram is transformed into a logical structure ( Relationship model )
4) Choose a storage structure and storage method for the logical data model
5) Use DDL Define the data structure , Data loading , Programming and debugging applications , Test run the database
6) Database dump and recovery , Safety integrity control , Performance improvements , Reconstruction of database
3、 Give requirements , Be able to draw E-R chart ( To be able to E-R Graph to relational pattern , The connection between entities ,1:1, 1:n, m:n,, meaning , drawing )
Reference resources : database -E-R Picture exercise _Mark7758 The blog of -CSDN Blog _ There are two entities: athletes and competition events
边栏推荐
- 关于数据库的问题,唯一和非重复的概念
- Asp.NetCore 中使用grpc
- sql界面切换不能获取焦点
- [Paper Abstract] screenshots of methods for recording abstracts of interest and papers in special fields.
- Common functions of JMeter - parametric introduction
- Chapter 1 performance platform godeye source code analysis - overall architecture
- [untitled]
- 无心剑汉英双语诗005.《抒怀》
- 【Notebook系列第七期】OpenVINO预训练模型的的下载和使用方法
- 多元统计分析 主成分分析 - 01
猜你喜欢

Realize the dual opening of wechat on the computer (log in to two wechat)

Redis数据迁移:方法二AOF

Hcip day 6 notes

基于OpenVINO Model Server打造人像抠图服务器

Hcip Experiment 4

Some problems after xcode11 new project

Chapter 2 - create and maintain MySQL database
![[untitled]](/img/3b/fb86cb1512c2dbe3626bb50b990e44.png)
[untitled]

Wechat online education video on demand learning applet graduation design (1) development outline

Small program completion work wechat online education video on demand learning small program graduation design (2) small program function
随机推荐
How to realize the association between interfaces in JMeter?
How session and cookies work
【超能云终端创领先机】本地计算云端管理,英特尔助力教育数字化
【RuoYi-Vue-Plus】学习笔记 30 - Redisson(六) 有界阻塞队列 Bounded Blocking Queue(Redisson 源码 + Lua 脚本)
厉害,竟然把VSCode玩成了IDEA的效果,有点哇塞
Hcip Experiment 4
go环境安装
Wechat Online Education video on Demand Learning of applet Graduation Design (3) Background Function
【Try to Hack】NTLM身份验证过程
多元统计分析 主成分分析 - 01
学术分享 | 基于OpenVINO的多染色病理图像信息评估系统设计与开发
【数据库】期末必知必会-----第八章 数据库安全
51 single chip microcomputer - double byte multiplied by double byte
Understand │ what is cross domain? How to solve cross domain problems?
Wechat online education video on demand learning applet graduation design (3) background function
JS array processing [slice implements the deletion, insertion and replacement of arrays]
The software supply chain security risk that makes enterprise digitalization and it executives bear the brunt of the cauldron points to the north
Tutorial: Adaptive Replication and Partitioning in Data Systems
Automake Chinese Manual_ incomplete
Dapr series (I)
