在智慧社區(qū)商超管理系統(tǒng)中，通常有多種不同角色的人員使用該系統(tǒng)，超市里面有各種各樣不同的商品，商品都有不同的供應(yīng)商。
.1、根據(jù)上述語義畫出ER圖。
.2、將ER模型轉(zhuǎn)換成數(shù)據(jù)表，并指出每個數(shù)據(jù)表的主鍵。
收銀員數(shù)據(jù)表
?名稱? ?類型? ?備注? ?是否為空
Id? ?工號? ?Int? ?主鍵，否
Name? ?姓名? ?Varchar(15)? ?否
Password? ?密碼? ?Varchar(15)? ?否
Tel? ?電話? ?Int? ?否
商品數(shù)據(jù)表
?名稱? ?類型? ?備注? ?是否為空
Id? ?商品號? ?Int? ?主鍵，否
Name? ?商品名稱? ?Varchar(20)? ?否
Price? ?單價? ?Int? ?是
庫管員數(shù)據(jù)表
?名稱? ?類型? ?備注? ?是否為空
Id? ?工號? ?Int? ?主鍵，否
Name? ?姓名? ?Varchar(15)? ?否
Password? ?密碼? ?Varchar(15)? ?否
Tel? ?電話? ?Int? ?否
供應(yīng)商數(shù)據(jù)表
?名稱? ?類型? ?備注? ?是否為空
Name? ?供應(yīng)商名? ? Varchar(50)主鍵，否
Label? ?代碼? ?Varchar(50)? ?是
Time? ?時間? ?Varchar(20)? ?是
Contacts??聯(lián)系人? ?Varchar(15)? 否
Tel? ?電話? Int? 是
商超系統(tǒng)數(shù)據(jù)表
?名稱? ?備注? 是否為空
Cashier??收銀員? ?否
Commodity??商品? 否
Administrator??庫管員? 否
Suoolier??供應(yīng)商? 否
USE [tdc2017270371]
GO
/****** Object:? Table [dbo].[銷售表]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[銷售表](
[id] [varchar](10) NOT NULL,
[xssl] [int] NULL,
[time] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:? Table [dbo].[收銀員]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[收銀員](
[id] [varchar](10) NOT NULL,
[name] [varchar](10) NULL,
[xb] [varchar](10) NULL,
[mm] [varchar](10) NULL,
[tel] [varchar](15) NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:? Table [dbo].[商品]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[商品](
[spid] [varchar](20) NOT NULL,
[spname] [varchar](20) NULL,
[spprice] [float] NULL,
[scrq] [datetime] NULL,
[sccj] [varchar](20) NULL,
PRIMARY KEY CLUSTERED
(
[spid] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:? Table [dbo].[錄入表]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[錄入表](
[id] [varchar](10) NOT NULL,
[spsl] [int] NULL,
[time] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:? Table [dbo].[管理員]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[管理員](
[id] [varchar](10) NOT NULL,
[name] [varchar](10) NULL,
[xb] [varchar](10) NULL,
[mm] [varchar](10) NULL,
[tel] [varchar](15) NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:? Table [dbo].[供貨商]? ? Script Date: 11/04/2018 16:09:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[供貨商](
[id] [varchar](10) NOT NULL,
? ? ? ? ? ? ? ? [label] [varchar](10) NOT NULL,
[spname] [varchar](10) NULL,
[lxr] [varchar](10) NULL,
[tel] [varchar](10) NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX? = OFF, STATISTICS_NORECOMPUTE? = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS? = ON, ALLOW_PAGE_LOCKS? = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
