1.根据上述语义画出ER图

图片.jpg

2.将ER模型转换成数据表，并指出每个数据表的主键

2.png

3.根据建立的数据表，在SQL Server 2008中建表

CREATE DATABASE malin2017270087;

USE malin2017270087;

create table users(

//id 为主关键字

id int primary key ,

name varchar(50),

passwords varchar(50),

phone varchar(15)

)

insert into users values

(1001,'老赵','123','13333333333'),

(1002,'老钱','123','13444444444'),

(1003,'老孙','123','13555555555'),

(1004,'老李','123','13666666666')

select * from users;

private void Form1_Load(object sender, EventArgs e)

        SqlConnection conn; 

        string conStr = "Data Source=.;Initial Catalog=malin2017270087;Integrated Security=True";

        conn =new SqlConnection(conStr);

        conn.Open();

        string strsql = "select * from users";

        SqlDataAdapter adapter = new SqlDataAdapter(strsql, conn);

        DataSet ds =new DataSet();

        adapter.Fill(ds, "users");

        dataGridView1.DataSource = ds.Tables[0].DefaultView;