word版可編輯-檔案管理系統(tǒng)課程設(shè)計(jì)報(bào)告精心整理-免費(fèi)閱讀
【正文】 在設(shè)計(jì)的過(guò)程中遇到問(wèn)題，可以說(shuō)得是困難重重，畢竟第一次做數(shù)據(jù)庫(kù)設(shè)計(jì)，同時(shí)也要加上相應(yīng)的系統(tǒng)設(shè)計(jì)，難免會(huì)遇到過(guò)各種各樣的問(wèn)題，在設(shè)計(jì)的過(guò)程中發(fā)現(xiàn)了自己的不足之處，對(duì)一些前面學(xué)過(guò)的知識(shí)理解得不夠深刻，掌握得不夠牢固，通過(guò)這次課程設(shè)計(jì)之后，我把前面所學(xué)過(guò)的知識(shí)又重新溫故了一遍。 檔案管理是隨著人事制度改革應(yīng)運(yùn)而生的一項(xiàng)新的工作。雖然檔案學(xué)面臨信息化的沖擊與挑戰(zhàn)，但是我們必須清醒地看到，新一代檔案學(xué)尚未產(chǎn)生，檔案管理信息化還存在大量未解決的難題。文檔類型已存在39。添加失敗39。添加成功39。4. 數(shù)據(jù)庫(kù)的實(shí)施1) 創(chuàng)建數(shù)據(jù)庫(kù)：Files 2) 創(chuàng)建表a. Users表創(chuàng)建腳本USE [Files]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Users]( [Users_ID] [int] NOT NULL, [Users_UserName] [varchar](50) NOT NULL, [Users_Password] [char](20) NOT NULL, [Users_Name] [varchar](50) NOT NULL, [Users_Department] [varchar](50) NOT NULL, [Users_Page] [int] NOT NULL, [Roles_Name] [varchar](50) NOT NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [Users_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]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[Users] WITH CHECK ADD CONSTRAINT [FK_Users_Departments] FOREIGN KEY([Users_Department])REFERENCES [dbo].[Departments] ([Dept_ID])GOALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Departments]GOALTER TABLE [dbo].[Users] WITH CHECK ADD CONSTRAINT [FK_Users_Roles] FOREIGN KEY([Roles_Name])REFERENCES [dbo].[Roles] ([Roles_Name])GOALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Roles]GOb. Departments表創(chuàng)建腳本USE [Files]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Departments]( [Dept_ID] [varchar](50) NOT NULL, [Dept_Name] [varchar](50) NOT NULL, CONSTRAINT [PK_Departments] PRIMARY KEY CLUSTERED ( [Dept_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]GOSET ANSI_PADDING OFFGOFiles表創(chuàng)建腳本USE [Files]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Files]( [Files_ID] [varchar](50) NOT NULL, [Files_Num] [varchar](50) NOT NULL, [FilesManage_ID] [varchar](50) NOT NULL, [Files_Title] [varchar](50) NOT NULL, [Files_StartTime] [date] NULL, [Files_EndTime] [date] NULL, [Files_StorageTime] [int] NULL, [Files_TotalPackages] [varchar](50) NULL, [Files_TotalPage] [varchar](50) NULL, [Files_FilingNumber] [char](10) NULL, [Files_ArchivalCode] [char](10) NULL, [Files_Agent] [varchar](50) NULL, [Files_Situation] [varchar](50) NULL, [Files_Archives] [varchar](50) NULL, [Files_Examiner] [varchar](50) NULL, [Files_FiliDate] [date] NULL, CONSTRAINT [PK_Files] PRIMARY KEY CLUSTERED ( [Files_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]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_FilesManage1] FOREIGN KEY([FilesManage_ID])REFERENCES [dbo].[FilesManage] ([FilesManage_ID])GOALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_FilesManage1]GOc. F
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1