Create a database plan User Guide

Since its birth, database technology has formed a solid theoretical foundation in less than half a century.

Since its birth, database technology has formed a solid theoretical foundation in less than half a century.

Since its birth, technology has formed a solid theoretical foundation, mature commercial products and a wide range of application fields in less than half a century, attracting more and more researchers to join. The Birth and Development of Computer Information Management has brought about a huge revolution. Over the past 30 years, thousands of databases have been developed and built at home and abroad. It has become an infrastructure for enterprises, departments, and even individuals to work, produce, and live.

At the same time, with the expansion and deepening of applications, the number and scale of databases are growing, and the research field of databases has been extended and deepened. In the past 30 years, the database field has obtained three computers: Turing (C. w. bachman, E. f. codd, J. gray), which fully demonstrates that the database is a dynamic and innovative field. Let's trace the history of the database.

The first step in creating a database is to develop a plan that can be used as a guide when implementing the database, or as a description of the function of the database after the database is implemented. The complexity and details of database design are determined by the complexity and size of database applications and the number of users.

The nature and complexity of database applications and the process of planning them can change a lot. Databases can be relatively simple, such as databases designed for single users. They can also be large and complex, such as databases designed to handle all banking transactions of millions of customers. In the previous case, the database design may only need to write a few remarks on some drafts. In the latter case, the design may be a hundred-page official document containing various possible details about the database.

When planning a database, regardless of its size and complexity, follow these basic steps:

Collect information.
Id object.
Create an object model.
Identifies the information type of each object.
Identifies the relationship between objects.
Collect information

Before creating a database, you must have a thorough understanding of the work expected to be performed on the database. If the database is used to replace an information system that is based on paper or manual execution, the existing system can provide you with most of the required information. It is important to communicate with everyone involved in the system to find out what they do and what they need to get from the database. It is also important to understand what they want the new system to do and identify the problems, limitations, and bottlenecks of the existing system. Collect customer settlement, inventory lists, management reports, and copies of any other documents in the existing system, as these are useful for designing databases and interfaces.

Id object

During information collection, you must identify the primary object or entity managed by the database. An object can be a tangible entity (such as a person or a product) or an intangible Project (such as a business transaction, a department in a company, or a pay-as-you-go cycle ). There are usually several main objects. After these objects are identified, the related projects will become clear. Each project in the database should have a corresponding table.

Microsoft®SQL Server™The main object in the pubs sample database attached with 2000 is books. In the company's business, book-related objects include: the author of the book, the publisher that produces the book, the bookstore that sells the book, and the sales transactions executed by the bookstore. Each of these objects is a table in the database.

Create an object model

After the objects in the system are identified, it is very important to use an intuitive representation of the system to record these objects. During database implementation, you can use the database model as a reference.

For this purpose, database developers use a variety of tools for database design. In terms of technical complexity, these tools can be simple pencil and draft paper, or word processing or spreadsheet programs, it can even be a software program designed specifically for database modeling. No matter which tool you want to use, it is important to always use the latest tool.

SQL Server Enterprise Manager includes visual design tools (such as Database Designer) that can be used to design and create objects in a database. For more information, see Database Designer.