數(shù)據(jù)庫原理課程設(shè)計報告--基于sqlserver設(shè)計與應(yīng)用(編輯修改稿)
2025-02-14 22:23 本頁面
【文章內(nèi)容簡介】 物理結(jié)構(gòu)設(shè)計(1)對收入管理表在各家庭成員的收入情況、發(fā)金時間上建立非聚集索引。(2)對支出管理表在各家庭成員的支出情況、支出時間、支出內(nèi)容上建立非聚集索引。(3)對家庭成員信息管理表在各家庭成員個人信息上建立非聚集索引。(4)對家庭理財管理表在各家庭成員的股票、基金、存款、債券以及外匯上建立非聚集索引。用戶登錄模塊流程圖如下圖所示：圖41 用戶登錄流程圖系統(tǒng)管理模塊流程圖如下圖所示：圖42 系統(tǒng)管理流程圖信息查詢模塊流程圖如下圖所示：圖43 信息查詢流程圖家庭成員信息管理模塊流程圖如下所示：圖44 家庭成員信息管理流程圖用戶管理模塊流程圖如下圖所示：圖45 用戶管理流程圖第5章 代碼CREATE DATABASE [s]CONTAINMENT = NONEON PRIMARY ( NAME = N39。s39。, FILENAME = N39。E:\Program Files\Microsoft SQL Server\\MSSQL\DATA\39。 , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )LOG ON ( NAME = N39。s_log39。, FILENAME = N39。E:\Program Files\Microsoft SQL Server\\MSSQL\DATA\39。 , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GO(1)用戶表：CREATE TABLE [dbo].[userinfo]( [User_Name] [nvarchar](50) NOT NULL, [Password] [nvarchar](50) NULL, CONSTRAINT [PK_userinfo] PRIMARY KEY CLUSTERED ( [User_Name] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO(2)支出表：CREATE TABLE [dbo].[zhichu]( [T_ID] [nchar](10) NOT NULL, [T_Name] [nchar](10) NULL, [T_Date] [datetime] NULL, [T_Money] [nvarchar](50) NULL, [T_Content] [nvarchar](50) NULL, CONSTRAINT [PK_zhichu] PRIMARY KEY CLUSTERED ( [T_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]GO(3)收入表：CREATE TABLE [dbo].[shouru]( [EP_ID] [nchar](10) NOT NULL, [EP_Name] [nchar](10) NULL, [EP_Salary] [nvarchar](50) NULL, [EP_Bonus] [nvarchar](50) NULL, [EP_Date] [datetime] NULL, [EP_Remark] [nvarchar](50) NULL, CONSTRAINT [PK_shouru] PRIMARY KEY CLUSTERED ( [EP_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]GO(4)家庭理財表：SET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[wageinformation]( [W_ID] [nchar](10) NOT NULL, [W_Name] [nchar](10) NULL, [W_BasicWage] [nvarchar](50) NULL, [W_Boon] [nvarchar](50) NULL, [W_Bonus] [nvar
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1