數(shù)據(jù)庫(kù)設(shè)計(jì)模板進(jìn)銷存管理系統(tǒng)-預(yù)覽頁(yè)
【正文】 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ù)庫(kù)設(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ù)庫(kù)系統(tǒng)安全性設(shè)計(jì) a) 安全管理 安全管理中采取分權(quán)管理。 b) 維護(hù) 安全性 8．?dāng)?shù)據(jù)庫(kù)優(yōu)化 9．?dāng)?shù)據(jù)庫(kù)管理與維護(hù)說(shuō)明 。不同的登錄名具有對(duì)數(shù)據(jù)庫(kù)操作不同的權(quán)限，因此 該管理員不同的使用權(quán)限（數(shù)據(jù)庫(kù)超級(jí)管理員不屬于此列）。), [Empl_Age] [int] NOT NULL CONSTRAINT [DF_emplyees_Empl_Age] DEFAULT ((0)), XXXXXX 管理系統(tǒng) 數(shù)據(jù)庫(kù)設(shè)計(jì)者： XXXXX 19 [Depar_Id] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [Identifi] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Empl_Date] [datetime] NOT NULL, [Contract] [text] COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_emplyees_Contract] DEFAULT (39。 c) 字段 命名：全部采用英文結(jié)合數(shù)字，字母在前，數(shù)字在后，單詞首字母采用英文大寫字母，長(zhǎng)單詞取單詞縮寫，縮寫單詞之間采用下劃線連接，名稱取 _Na,編號(hào) _Id，時(shí)間取 _Ti 等。其中數(shù)據(jù)庫(kù) SQL Server 2020 的登錄模式是采用混合身份驗(yàn)證，超級(jí)用戶的用戶名均為 sa， SQL Server 服務(wù)器的端口號(hào)： 1433。數(shù)據(jù)庫(kù)設(shè)計(jì)過(guò)程采用的是 PowerDesignr 進(jìn)行數(shù)據(jù)庫(kù)建模，使用 SQL Server***創(chuàng)建數(shù)據(jù)庫(kù)腳本文件。如訂單表： order 等。男 39。對(duì)于不同的部門操作員，在數(shù)據(jù)庫(kù)創(chuàng)建 不同的登錄名
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1