Database Creation, How to Database Database Creation Steps

If you are using SQL Server, open Enterprise Manager.

1.Create a database.

Open the node on the tree structure:

Microsoft SQL Servers ->local) (Windows NT) -database.

Right-click -> create database -> enter the database name, studentmanagement -> OK.

Since then, there have been multiple databases called studentmanagement under the data folder.

2.Create a table.

Create a student table:

Open the node of the StudentManagement database.

Click Table. In the window on the right, a number of system tables are displayed.

Then right-click -> create a new table in the blank space of the window on the right.

Open the table creation view.

Fill in the column name and data type.

stud_id int

stud_accounts varchar(20)stud_password varchar(40)stud_name varchar(20)stud_dept varchar(10)stud_job varchar(10)

stud time varchar(20) establishes a primary key on the stud id, which is self-incrementing.

Save. Fill in the form name: students

Other tables can be created in the same way.

It depends on what watch you need.

Hehe, let me briefly say that there are two tables in total.

Table 1 shows the basic information of student leaders.

Table 2 is the part of all cadre management, and this table should have a field associated with Table 1.

The following is an example of building a database with AESS as follows:

Click "Start" "All Programs" "MicrosoftOffice" "MicrosoftAESSss 2010" to open the MicrosoftAESS2010 software.

In the open Microsoft AESS 2010 software, select "Empty Database" and double-click to create a town. Or hit the "Create" command button to create, and you can choose to specify a specific file name and path at the Chinese file name.

After you create a blank database, you can see a new data table named Table 1, and its fields are displayed on the right side of the page. To add a field, you can click the inverted triangle arrow next to Click to add a file and select the type of field you want to add.

At this time, the cursor will be positioned on the field name, you can rename the field name, and press the enter key to continue the next field addition operation.

By following the steps above, you can create a simple blank database with a single data table.