What is Database Design ?

[chinmay]

Database systems are designed to manage large bodies of information. These large bodies of information do not exist in isolation. They are part of the operation of some enterprise whose end product may be information from the database or may be some device or service for which the database plays only a supporting role.

Database design mainly involves the design of the database schema. The design of a complete database application environment that meets the needs of the enterprise being modeled requires attention to a broader set of issues. In
this text, we focus initially on the writing of database queries and the design of database schemas.

[seotrainingsurat]

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.

[galih]

Database design is a process of modeling an enterprise in the real world. In fact, a database itself is a model of the real world that contains selected information needed by the enterprise.

[stephaniego9]

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.

[clonect]

Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.

[kaufenpreis]

Database design, as the name might suggest, is much like house design, though the term also can be used to refer to actual database construction. The design process is something of a blueprint that outlines a database's details, from relationships between tables to what information is important and how the data will be implemented. Aside from helping the builder know what tables and information to collect, a design uses naming conventions, and spelling errors are checked before the database is completed. The database also goes through normalization, which seeks to remove redundancy, during the design process. Without first working out a design, a database creator can easily mess up the order of tables or the primary key for tables, or simply miss a few sections, among a slew of other potential errors.
The first step of database design is to know the purpose of the database. There are no diagrams or abstract representations; the designer just thinks about the database’s objectives. Some information may be written down, but generally the designer simply considers the best way to organize and use the database.