趙延芳xxxx12120262數(shù)據(jù)庫人事管理系統(tǒng)(編輯修改稿)
2025-05-05 05:02 本頁面
【文章內(nèi)容簡介】 句如下：CREATE TABLE [職稱表] ( [職稱名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [工資級(jí)別] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [基本工資] [money] NULL , [職務(wù)補(bǔ)助] [money] NULL , [房補(bǔ)] [money] NULL , CONSTRAINT [PK_職稱表] PRIMARY KEY CLUSTERED ( [職稱名] ) ON [PRIMARY] ) ON [PRIMARY]GO管理員表的創(chuàng)建：CREATE TABLE [管理員表] ( [登錄賬號(hào)] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [密碼] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , CONSTRAINT [PK_管理員表] PRIMARY KEY CLUSTERED ( [登錄賬號(hào)] ) ON [PRIMARY] ) ON [PRIMARY]GO工齡表的創(chuàng)建語句如下：CREATE TABLE [工齡表] ( [工齡年數(shù)] [int] NOT NULL , [工齡津貼] [money] NULL , CONSTRAINT [PK_工齡表] PRIMARY KEY CLUSTERED ( [工齡年數(shù)] ) ON [PRIMARY] ) ON [PRIMARY]GO獎(jiǎng)懲表的創(chuàng)建語句如下：CREATE TABLE [獎(jiǎng)懲] ( [編號(hào)1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [金額] [money] NULL , [內(nèi)容] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_獎(jiǎng)懲] PRIMARY KEY CLUSTERED ( [編號(hào)1] ) ON [PRIMARY] , CONSTRAINT [FK_獎(jiǎng)懲_職工表] FOREIGN KEY ( [編號(hào)1] ) REFERENCES [職工表] ( [編號(hào)] )) ON [PRIMARY]GO洗理費(fèi)表的創(chuàng)建語句如下：CREATE TABLE [洗理費(fèi)] ( [性別] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [金額] [money] NULL , CONSTRAINT [PK_洗理費(fèi)] PRIMARY KEY CLUSTERED ( [性別] ) ON [PRIMARY] ) ON [PRIMARY]GO3數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計(jì)根據(jù)數(shù)據(jù)庫的需求分析和概念結(jié)構(gòu)設(shè)計(jì)，設(shè)計(jì)了名稱為職工的數(shù)據(jù)庫表。表的設(shè)計(jì)結(jié)果如下面各表所示：表31 職工表列名數(shù)據(jù)類型長度是否允許為空編號(hào)varchar50否姓名varchar50是性別char10是出生日期datetime8是參加工作日期datetime8是住址varchar50是電話varchar50是來本單位的時(shí)間datetime8是職稱名varchar50是評(píng)定時(shí)間datetime8是工齡年數(shù)int4是編號(hào)1varchar50是表32 管理員表列名數(shù)據(jù)類型長度是否允許為空登錄賬號(hào)char10否密碼char10否表33職稱表列名數(shù)據(jù)類型長度是否允許為空職稱名varchar50否工資級(jí)別varchar50是基本工資money8是職務(wù)補(bǔ)助money8是房補(bǔ)money8是表34工齡表列名數(shù)據(jù)類型長度是否允許為空工齡年數(shù)int4否工齡津貼money8是表35洗理費(fèi)列名數(shù)據(jù)類型長度是否允許為空性別char10否金額money8是表36獎(jiǎng)懲列名數(shù)據(jù)類型長度是否允許為空編號(hào)1varchar50否金額money8是內(nèi)容varchar50是4功能分析下圖為職工信息表的截圖，利用此表可以查詢、修改、更新等相關(guān)信息：圖41 職工表管理員登錄賬號(hào)需要輸入賬號(hào)及密碼，當(dāng)然必須符合以下表對(duì)賬號(hào)和密碼的設(shè)計(jì)要求：圖42 管理員表下面的這個(gè)登錄界面可提供職工和管理員登錄，分別
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1