2018-12-04

2.4系统数据库设计

1.描述抽象数据库表的过程，绘制流程图

image.png

2.绘制智慧商超系统的ER图

image.png

3.给出智慧商超涉及到的数据库表的各个字段
USE [cc2017270391]
CREATE TABLE [dbo].[销售表](
[工号] varchar PRIMARY KEY NOT NULL,
[数量] [int] NULL,
[时间] [datetime] NULL,
PRIMARY KEY CLUSTERED
CREATE TABLE [dbo].[收银员](
[工号] varchar NOT NULL,
[姓名] varchar NULL,
[密码] varchar NULL,
[电话] varchar NULL,
PRIMARY KEY CLUSTERED

CREATE TABLE [dbo].[商品](
[名称] varchar NOT NULL,
[编号] varchar NULL,
[价格] [varchar] (50)NULL,
PRIMARY KEY CLUSTERED

CREATE TABLE [dbo].[录入表](
[id] varchar NOT NULL,
[spsl] [int] NULL,
[time] [datetime] NULL,
PRIMARY KEY CLUSTERED

CREATE TABLE [dbo].[库管员](
[工号] varchar NOT NULL,
[姓名] varchar NULL,
[密码] varchar NULL,
PRIMARY KEY CLUSTERED

CREATE TABLE [dbo].[供货商](
[代码] varchar NOT NULL,
[名称] varchar NULL,
[地点] varchar NULL,
[联系人] varchar NULL,
[电话][varchar]（15）NULL,
PRIMARY KEY CLUSTERED