How to build a good database, how to build a simple database

You can use the database modeling tool to create it, you only need to analyze the number of tables and fields in the database.

and constraints. Relationships, all of which can be set up, are commonly used with the PowerBuildRose design.

Simple and fast, you can directly generate database scripts, and you can create a database by executing, the relationship is simple and intuitive!

It stands to reason that the data in your table should be available according to other data tables, and there should be a student information table, which will reflect the grade of the class, so that you can get the information of a certain grade and a class according to this data table, for example:

select * from student information where class=1 and grade=1 and gender=male.

select * from Student Information where class=1 and grade=1 and test scores=90

Of course, if you are sure that you need to create a corresponding data table, you can do that, for example:

id Class Grade Number of boys Number of girls Score band 1 Band 2....Score band 6

This is not a database, this is how to build a table, the logical design should divide the data into 3 tables, 1 is a student table, with coding, name, gender, age, etc., 1 is a class table, there is a class, student code, and the last one is a grade table, with student code, semester, subject, grade, and then write sql to take out the data that meets your format.

The specific steps are as follows:

1. First of all, open our AESS program, and open it by clicking Start - All Programs.

2. Find the Microsoft Office folder in all programs and open it.

3. Find AESS and click Open.

4. In the AESS interface, click File - New.

5. Select: On the right side of the interface, a new dialog box appears, and select an empty database.

6. Select a location to store the file, and then click on Chuangling Silver Lease to build the library.

7. So we create an AESS database.

A very, very good database software is recommended, and it is also free to use. In other words, you have this tool, no matter what kind of data processing actions or management you want to do, you can do it. (Free ** usage method at the end of the article).

Quickly make data analysis reports, and no longer worry about excel messes!

Cloud Table Enterprise Application Platform, a data processing software that integrates MySQL databases, is also a powerful 0** software development platform, (of course, it can also be adapted to SQL and Oracel).

With cloud table, you can complete almost all kinds of data collection, statistics, analysis, query and other data processing actions, and users, multi-user collaboration capabilities, can achieve data sharing in the organization, and for user permissions can be set freely, you can also join the approval process and business process, support Excel or WPS electronic ** import and export, bridge can also generate APP, word, PDF.

In terms of data interactivity, it comes with OpenAPI, which can be seamlessly integrated with third-party software (such as SAP, UFIDA, etc.), **, APP (WeChat, DingTalk), and can also directly read and write third-party databases, which is very convenient.

Need to know about databases? no！no！no！

You don't need to know programming at all, and you don't need to know the database at all, the usage is very similar to excel, but by clicking and dragging the mouse one by one, you can quickly build the system interface you need (how beautiful and completely self-help), and then configure some Chinese formulas (at a glance, you will understand Hengmeng, junior high school students will), set the organizational structure user permission process, etc., so it's good. This very good database management software is just fine.

You can use it to do sales, procurement, ERP, warehouse management, production management, personnel administration of various enterprise management systems, of course, do basic data analysis reports, that is the most basic function, you can also do navigation and BI, APP, in short, use this software colleagues comfortable, leadership satisfaction, hehe, easy to use everyone happy.

Say okay, send the software for free.

1. Of course, if you really think it's a good thing, please take a look at it, or praise it, thank you.

2. Send a private message through the mobile phone headline number: cloud table.

Once you've done that, you'll automatically receive private message replies from Toutiao.

It's not that I have to do this.,It's that the system has limitations.,Can't send links.,Please understand.。