物應(yīng)1705 付超 2017270396
題目
在智慧社區(qū)商超管理系統(tǒng)中，通常有多種不同角色的人員使用該系統(tǒng)，超市里有各種各樣不同的商品，商品都有不同的供應(yīng)商。
一．根據(jù)上述語義畫出ER圖。
二．將ER模型轉(zhuǎn)化成數(shù)據(jù)表。
三．根據(jù)建立的數(shù)據(jù)表，在SQL Sever 2008中建表。
1.收銀員
USE [FUCHAO]
GO
/****** Object: Table [dbo].[收銀員] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[收銀員](
[工號(hào)] varchar NOT NULL primary key,
[姓名] varchar NOT NULL,
[密碼] varchar NOT NULL,
[電話] varchar NOT NULL
) ON [PRIMARY]
GO
2.商品銷售清單
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[商品銷售清單] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[商品銷售清單](
[流水號(hào)] varchar NOT NULL primary key,
[收銀員工號(hào)] varchar NULL,
[商品號(hào)] varchar NOT NULL,
[銷售時(shí)間] varchar NOT NULL
) ON [PRIMARY]
GO
3.商品錄入清單
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[商品錄入清單] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[商品錄入清單](
[流水號(hào)] varchar NOT NULL primary key,
[收銀員工號(hào)] varchar NOT NULL,
[商品號(hào)] varchar NOT NULL,
[錄入時(shí)間] varchar NOT NULL
) ON [PRIMARY]
GO
4.商品
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[商品] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[商品](
[商品號(hào)] varchar NOT NULL primary key,
[商品名稱] varchar NOT NULL,
[價(jià)格] varchar NOT NULL,
[供應(yīng)商] varchar NOT NULL
) ON [PRIMARY]
GO
5.庫管員
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[庫管員] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[庫管員](
[工號(hào)] varchar NOT NULL primary key,
[姓名] varchar NOT NULL,
[密碼] varchar NOT NULL,
[電話] varchar NOT NULL
) ON [PRIMARY]
GO
6.供應(yīng)商
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[供應(yīng)商] Script Date: 10/30/2018 22:27:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[供應(yīng)商](
[代碼] varchar NOT NULL primary ke ,
[名稱] varchar NOT NULL,
[地點(diǎn)] varchar NOT NULL,
[聯(lián)系人] varchar NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
