Database design document教学管理系统.docVIP

XX Project Database Design Document Project Suppose you are a DBA (Database Administrator) in a company, and you are going to participate in a project and help to design the database for the project. Please give detail steps to explain your design. And you are asked to write a document to record corresponding content. The template of this document is “Database design document.doc”, please download it. Please note that you are entitled to make minor changes to this document. It is suggested, but not limited, to contain the following steps: Requirement analysis of this project Conceptual database design Logical database design Validate the result and modify The related issues of database, such as security and performance The related chapters in the textbook are: chap 10-18, 20 The optional projects are listed as follows, but not limited to them: Management System for Library Management System for undergraduates Management System for hospital Ticketing System for Train Ticketing System for Air ticket agency Reservation System for Restaurant Booking System for driving school …… Reminders: The requirements should fit the actual demand, the more the better. The steps should be given as much detailed as possible.  Contents 1 Overview 2 1.1 Purpose 2 1.2 Background 3 1.3 References、abbreviations、definitions 3 2 External Design 3 2.1 Surroundings 3 3 Database Logical design 3 3.1 Entity-relationship diagram 3 3.2 Entities 4 3.3 Relationships 4 4 Database Physical design 5 4.1 Physical structure 5 4.2 Security design 5 5 Design of Tables 5 6 Design of Views 7 7 Design of stored procedures、functions and triggers 7 8 Accounts and Privileges 8 9 Appendix 8 9.1 Word processing and database tools 8 Overview Purpose 应用对数据库系统原理的理论学习,通过上机实践的方式将理论知识与实践 更好的结合起来,巩固所学知识。 数据库应用 课程实践：实践和巩固在课堂教学中学习有关知识，熟练掌握对于给定结构的数据库的创建、基本操作、程序系统的建立和调试以及系统评价。 数据库原理 软件设计实践：实践和巩固在课堂教学中学习的关于关系数据库原理的有关知识和数据库系统的建立方法，熟练掌握对于给定实际问题，为了建立一个关系数据库信息管理系统，必须得经过系统调研、需求分