數(shù)據(jù)庫設(shè)計(jì)模板進(jìn)銷存管理系統(tǒng)-資料下載頁
2024-11-12 16:40本頁面
【導(dǎo)讀】系統(tǒng)建立并維護(hù)。數(shù)據(jù)庫設(shè)計(jì)過程采用的是PowerDesignr進(jìn)行數(shù)據(jù)庫建模，使用SQL. Server***創(chuàng)建數(shù)據(jù)庫腳本文件。其中數(shù)據(jù)庫SQLServer2020的登錄模式是采用混合身。份驗(yàn)證，超級(jí)用戶的用戶名均為sa，SQLServer服務(wù)器的端口號(hào)：1433。單詞縮寫，各個(gè)縮寫單詞間采用下劃線連接。寫字母，長單詞取單詞縮寫，縮寫單詞之間采用下劃線連接，名稱取_Na,編號(hào)_Id，
【正文】 者： XXXXX 20 )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [FK_products_emplyees1] FOREIGN KEY([Eml_No]) REFERENCES [dbo].[emplyees] ([Empl_NO]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [FK_products_sell_ord] FOREIGN KEY([Sell_Id]) REFERENCES [dbo].[sell_ord] ([Sell_Id]) 表格 providers CREATE TABLE [dbo].[providers]( [Pro_Na] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Area] [char](15) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Addr] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Tel] [text] COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Site] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Fax] [varchar](9) COLLATE Chinese_PRC_CI_AS NOT NULL, [Mater_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_providers] PRIMARY KEY CLUSTERED ( [Pro_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[providers] WITH CHECK ADD CONSTRAINT [FK_providers_material] FOREIGN KEY([Mater_Id]) REFERENCES [dbo].[material] ([Mater_Id]) 表格 purchase_ord CREATE TABLE [dbo].[purchase_ord]( [Purch_Id] [char](15) COLLATE Chinese_PRC_CI_AS NOT NULL, [Purch_Date] [datetime] NOT NULL, [Purch_Class] [int] NOT NULL, [Purch_Na] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_No] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Pro_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Purch_Sum] [bigint] NOT NULL, [Purch_Price] [float] NOT NULL, [Receipt_Date] [datetime] NOT NULL, [Discount] [float] NOT NULL, CONSTRAINT [PK_purchase_ord] PRIMARY KEY CLUSTERED ( [Purch_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[purchase_ord] WITH CHECK ADD CONSTRAINT [FK_purchase_ord_emplyees] FOREIGN KEY([Pro_Id]) REFERENCES [dbo].[providers] ([Pro_Id]) GO ALTER TABLE [dbo].[purchase_ord] WITH CHECK ADD CONSTRAINT [FK_purchase_ord_emplyees1] FOREIGN KEY([Empl_No]) XXXXXX 管理系統(tǒng) 數(shù)據(jù)庫設(shè)計(jì)者： XXXXX 21 REFERENCES [dbo].[emplyees] ([Empl_NO]) 表格 sell_ord CREATE TABLE [dbo].[sell_ord]( [Sell_Id] [char](15) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sell_Date] [datetime] NOT NULL, [Sell_Area] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_NO] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Clie_Id] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Prod_Id] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Deliver_Date] [datetime] NOT NULL, [Discount] [float] NOT NULL, CONSTRAINT [PK_sell_ord] PRIMARY KEY CLUSTERED ( [Sell_Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[sell_ord] WITH CHECK ADD CONSTRAINT [FK_sell_ord_client] FOREIGN KEY([Clie_Id]) REFERENCES [dbo].[client] ([Clie_Id]) GO ALTER TABLE [dbo].[sell_ord] WITH CHECK ADD CONSTRAINT [FK_sell_ord_emplyees] FOREIGN KEY([Empl_NO]) REFERENCES [dbo].[emplyees] ([Empl_NO]) GO ALTER TABLE [dbo].[sell_ord] WITH CHECK ADD CONSTRAINT [FK_sell_ord_products] FOREIGN KEY([Prod_Id]) REFERENCES [dbo].[products] ([Prod_Id]) b) 應(yīng)用代碼 7．?dāng)?shù)據(jù)庫系統(tǒng)安全性設(shè)計(jì) a) 安全管理 安全管理中采取分權(quán)管理。對(duì)于不同的部門操作員，在數(shù)據(jù)庫創(chuàng)建 不同的登錄名。不同的登錄名具有對(duì)數(shù)據(jù)庫操作不同的權(quán)限，因此 該管理員不同的使用權(quán)限（數(shù)據(jù)庫超級(jí)管理員不屬于此列）。不同部門的操作員可以對(duì)部分表格或者視圖有查詢，修改，刪除，更新等操作，同時(shí)不同的部門操作員操作該部門所具有的功能模塊的部 分?jǐn)?shù)據(jù)庫中的數(shù)據(jù)。 b) 維護(hù) 安全性 8．?dāng)?shù)據(jù)庫優(yōu)化 9．?dāng)?shù)據(jù)庫管理與維護(hù)說明
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1