數(shù)據(jù)庫原理課程設(shè)計(jì)報(bào)告模板(編輯修改稿)
2025-08-31 00:00 本頁面
【文章內(nèi)容簡介】 的聯(lián)系轉(zhuǎn)換為關(guān)系模式，這種轉(zhuǎn)換一般遵循如下原則：一個(gè)實(shí)體型轉(zhuǎn)換為一個(gè)關(guān)系模式,一個(gè)多對(duì)多的關(guān)系可以轉(zhuǎn)化為一個(gè)關(guān)系模式，而一對(duì)多的關(guān)系可以融合在其他的相關(guān)的關(guān)系模式中。例如： (1) 員工與履歷之間是一對(duì)多的關(guān)系，所以將員工和履歷以及屬于關(guān)系設(shè)計(jì)成以下關(guān)系模式：員工(Worker_ID Worker_Name Department_Name Sex Birthday Native_Place School_Age Major Link_Phone Address)獎(jiǎng)懲記錄(Record_ID Worker_ID Worker_Name Record_date Record_type Record_content Record_reason Allow_unit Remark) 屬于(Worker_ID Worker_Name Department_Name Sex Birthday Native_Place School_Age Major Link_Phone Address Record_ID Record_date Record_type Record_content Record_reason Allow_unit Remark ) (2) 員工與賬號(hào)之間是一對(duì)一的關(guān)系，所以將員工和賬號(hào)以及屬于關(guān)系設(shè)計(jì)成以下關(guān)系模式： 員工(Worker_ID Worker_Name Department_Name Sex Birthday Native_Place School_Age Major Link_Phone Address) 賬號(hào) (User_Name User_pwd Power_level) 屬于(Worker_ID Worker_Name Department_Name Sex Birthday Native_Place School_Age Major Link_Phone Address User_pwd Power_level ) 4物理模型設(shè)計(jì)數(shù)據(jù)庫物理設(shè)計(jì)是將邏輯設(shè)計(jì)影射到存儲(chǔ)介質(zhì)上，利用可用的硬件和軟件功能盡可能快地對(duì)數(shù)據(jù)進(jìn)行物理訪問和維護(hù)。SQL Server 2000數(shù)據(jù)庫文件分為3中類型：主數(shù)據(jù)文件、次數(shù)據(jù)文件和日志文件。通過SQL語言進(jìn)行數(shù)據(jù)庫創(chuàng)建，創(chuàng)建數(shù)據(jù)庫的語句如下：Create database 工資管理系統(tǒng)。 創(chuàng)建表創(chuàng)建員工基本信息表 Base_data CREATE TABLE Base_data ( Worker_ID varchar(15) PRIMARY KEY,/*員工ID ，主碼*/ Worker_Name varchar(8) Not null,/*員工姓名*/ Department_Name varchar(15) Not null,/*部門名稱*/ Sex varchar(2) Not null,/*性別*/ Birthday datetime Not null,/*出生日期*/ Native_Place varchar(25) Not null,/*籍貫*/ School_Age varchar(4) Not null,/*學(xué)歷*/ Major varchar(15) Not null,/*專業(yè)*/ Link_Phone varchar(11) Not null,/*聯(lián)系電話*/ Address varchar(20) Not null,/*住址*/ )?？记谛畔⒂涗洷?Check_info CREATE TABLE Check_info( Months varchar(10) , Worker_ID varchar(15), Months_days int, /*本月天數(shù)*/ Holidays int, /*公休假天數(shù)*/ Work_days int, /*出勤天數(shù)*/ Business_days int,/*出差天數(shù)*/ Absent_days int,/*缺席天數(shù)*/ Leave_days int,/*請(qǐng)假天數(shù)*/ Late_days int,/*遲到天數(shù)*/ Leave_early_times int,/*早退天數(shù)*/ PRIMARY KEY (Months,Worker_ID), FOREIGN KEY (Worker_ID) REFERENCES Base_data(Worker_ID),)。工資信息表 Wage_info CREATE TABLE Wage_info ( Record_ID bigint PRIMARY KEY,/*記錄編號(hào)*/ Worker_ID varchar(15), Worker_Name varchar(8), Base_Wage float,/*基本工資*/ Allowance1 float, /*公共補(bǔ)貼*/ Allowance2 float,/*出差補(bǔ)貼*/ Reward float, /*獎(jiǎng)金*/ Overtime_Money float, /*加班費(fèi)*/ Deduct_Check float, /*扣考核*/ Aged_Money float, /*養(yǎng)老保險(xiǎn)*/ Medical_Money float, /*醫(yī)療保險(xiǎn)*/ Compo_Money float, /*工傷保險(xiǎn)*/ Unemploy_Money float, /*失業(yè)保險(xiǎn)*/ Housing_Money float, /*住房公積金*/ I
外語相關(guān)推薦
鄂ICP備17016276號(hào)-1