倉庫管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)本科畢業(yè)論文(編輯修改稿)
2024-07-21 19:24 本頁面
【文章內(nèi)容簡介】 借出單（借出單號，用戶號，商品名稱，生產(chǎn)廠家，型號，規(guī)格，數(shù)量，借出日期，歸還日期，借出人姓名）商品（商品號，商品名稱，生產(chǎn)廠家，型號，規(guī)格，數(shù)量）倉庫管理員（倉庫管理員號，姓名，性別，年齡，電話）倉庫（倉庫號，商品名稱，商品號，數(shù)量，地址） 數(shù)據(jù)庫物理設(shè)計(jì)倉庫管理系統(tǒng)的數(shù)據(jù)表如下所示：用戶表（Users）列名數(shù)據(jù)類型長度備注UserIDInt用戶號UserNameChar20姓名SexChar16性別TelChar16電話入庫單表（Receipt table）列名數(shù)據(jù)類型長度備注ReceiptIDInt入庫單號UserIDInt用戶號TradeNameChar100商品名稱ManufacturerChar100生產(chǎn)廠家ModelChar30型號StandardChar20規(guī)格QuantityInt數(shù)量DateChar20日期SUNameChar100入庫單位名稱DeliverymanNameChar20送貨人姓名出庫單表（Outbound table）列名數(shù)據(jù)類型長度備注OutboundIDInt出庫單號UserIDInt用戶號TradeNameChar100商品名稱ManufacturerChar100生產(chǎn)廠家ModelChar30型號StandardChar20規(guī)格QuantityInt數(shù)量DateChar20日期OUNameChar100出庫單位名稱PgNameChar20提貨人姓名借出單（Lend out table）列名數(shù)據(jù)類型長度備注LendoutIDInt借出單號UserIDInt用戶號TradeNameChar100商品名稱ManufacturerChar100生產(chǎn)廠家ModelChar30型號StandardChar20規(guī)格QuantityInt數(shù)量BorrowdateChar20借出日期ReturndateChar20歸還日期LendersNameChar20借出人姓名商品表（Goods table）列名數(shù)據(jù)類型長度備注GoodsIDInt商品號TradeNameChar100商品名稱ManufacturerChar100生產(chǎn)廠家ModelChar30型號StandardChar20規(guī)格QuantityInt數(shù)量倉庫管理員表（Warehouse keeper table）列名數(shù)據(jù)類型長度備注WarehouseKeeperIDInt倉庫管理員號WarehouseKeepernameChar20姓名SexChar16性別AgeInt年齡TelChar16電話倉庫表（Storage table）列名數(shù)據(jù)類型長度備注WarehouseIDInt倉庫號Trade nameChar100商品名稱GoodsIDInt商品號QuantityInt數(shù)量AddressChar100地址4 系統(tǒng)實(shí)現(xiàn) 數(shù)據(jù)庫的建立 用SQL語言建立數(shù)據(jù)庫用SQL語言具體實(shí)現(xiàn)下述內(nèi)容的編寫：： CREATE TABLE [dbo].[Users]( [UserID] [int] NOT NULL, [UserName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sex] [char](16) COLLATE Chinese_PRC_CI_AS NULL, [Tel] [char](16) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [UserID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Receipt_table]( [ReceiptID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Date] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [SUName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [DeliverymanName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Receipt_table] PRIMARY KEY CLUSTERED ( [ReceiptID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Outbound_table]( [OutboundID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Date] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [OUName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [PgName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Outbound_table] PRIMARY KEY CLUSTERED ( [OutboundID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Lend_out_table]( [LendoutID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Borrowdate] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Returndate] [cha
外語相關(guān)推薦
鄂ICP備17016276號-1