Who is a database designer?

Database design is the process of generating a detailed data model of the database. This data model contains all necessary logical and physical design choices and physical storage parameters necessary to generate the design in the data definition language and can be used to create the database. The full attribute data model contains detailed properties for each entity

The term database design can be used to describe various parts of the overall database system design. In principle, and most accurately, it can be thought of as the logical design of the underlying data structure used to store the data. In the relational model, these are tables and views. In the object database, entities and relationships are directly mapped to object classes and naming relationships. However, the term database design can be used throughout the design process, not only as the underlying data structure, but also as a database management system (DBMS) form and query that is part of the overall database application.

The process of designing a database usually involves many steps performed by the database designer. Normally, the designer needs to do the following.

Find and organize necessary information - Collect all kinds of information such as product name and order number recorded in the database.

Split information into tables - Divide information items into key entities or topics such as products and orders. Then each topic becomes a table

Convert information items to columns - Determine what information you need to store in each table. Each item becomes a field and it is displayed as a column in the table. For example, suppose the Employees table contains fields such as Last Name and Hire Date.

Specify primary key - Select the primary key for each table. A primary key is a column or set of columns that uniquely identifies each row. An example is a product ID or an order ID.

Setting table relationships - Display each table and determine the association between the data of one table and the data of another table. Add fields to the table as needed, or create new fields to clarify the relationship.

Design Optimization - Analyze design errors. Create a table and add some sample data records. Check if the results are based on table expectations. Adjust the design as necessary

But, of course, due to the large number of requests from users for MySQL support, we have worked hard to expand our products.

Now, we are proud to announce that SqlDBM supports MySQL - one of the world's most popular open source databases

You can now model and design MySQL database directly on SqlDBM. Of course, you can adjust SqlDBM functions such as Subject Area, Relationship, Chart, View Mode etc. to MySQL database for adjustment.

If you have learned about database design, you can not demonstrate this dataset design through database design testing. Or, if you are a programmer, your boss will blame you for presenting this dataset design. Your instructor or boss has the right to do so. It is not a standardized data set optimized by computer science representatives. But since this is a data news data analysis, you may laugh at these rules! Duplicate rows are required to aggregate the data later (Do you remember?). In the screenshot above, I entered the structure of the relevant year. Next, paste the total of 2013, 2014, 2015. The data set looks like this. (It does not allow iframe embedding, so it provides a link to the dataset.) It should have 91 lines, and in 2015 only the first and second seasons

Database design is the process of generating a detailed data model of the database. This data model contains all the necessary logical and physical design choices and physical storage parameters necessary to generate the design in the data definition language. The full attribute data model contains detailed attributes for each entity. The term database design can be used to describe various parts of the overall database system design. In principle, and most accurately, it can be thought of as the logical design of the underlying data structure used to store the data. In the relational model, these are tables and views. In the object database, entities and relationships are directly mapped to object classes and naming relationships.