《網(wǎng)絡(luò)數(shù)據(jù)庫(kù)開發(fā)技術(shù)》全套PPT電子課件教案第4章 數(shù)據(jù)庫(kù)管理

《《網(wǎng)絡(luò)數(shù)據(jù)庫(kù)開發(fā)技術(shù)》全套PPT電子課件教案第4章 數(shù)據(jù)庫(kù)管理》由會(huì)員分享，可在線閱讀，更多相關(guān)《《網(wǎng)絡(luò)數(shù)據(jù)庫(kù)開發(fā)技術(shù)》全套PPT電子課件教案第4章 數(shù)據(jù)庫(kù)管理（39頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

1、n主要內(nèi)容：n介紹數(shù)據(jù)庫(kù)的存儲(chǔ)結(jié)構(gòu)及數(shù)據(jù)庫(kù)的建立與維護(hù)方法。圖圖4-1 選擇向?qū)?duì)話框選擇向?qū)?duì)話框圖圖4-2 歡迎使用創(chuàng)建數(shù)據(jù)庫(kù)向?qū)?duì)話框歡迎使用創(chuàng)建數(shù)據(jù)庫(kù)向?qū)?duì)話框 圖圖4-3 輸入數(shù)據(jù)庫(kù)名稱和文件位置對(duì)話框輸入數(shù)據(jù)庫(kù)名稱和文件位置對(duì)話框 圖圖4-4 定義數(shù)據(jù)庫(kù)文件邏輯名稱及初始大小對(duì)話話框定義數(shù)據(jù)庫(kù)文件邏輯名稱及初始大小對(duì)話話框圖圖4-5 定義數(shù)據(jù)庫(kù)增長(zhǎng)信息對(duì)話框定義數(shù)據(jù)庫(kù)增長(zhǎng)信息對(duì)話框 圖圖4-6 定義事務(wù)日志文件名稱及初始大小對(duì)話框定義事務(wù)日志文件名稱及初始大小對(duì)話框 圖圖4-7 定義事務(wù)日志文件增長(zhǎng)信息對(duì)話框定義事務(wù)日志文件增長(zhǎng)信息對(duì)話框 圖圖4-8 確認(rèn)創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框確認(rèn)創(chuàng)建數(shù)

2、據(jù)庫(kù)對(duì)話框 圖圖4-9 創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的常規(guī)頁(yè)框創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的常規(guī)頁(yè)框圖圖4-10 創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的數(shù)據(jù)文件頁(yè)框創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的數(shù)據(jù)文件頁(yè)框圖圖4-11 創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的事務(wù)日志頁(yè)框創(chuàng)建數(shù)據(jù)庫(kù)對(duì)話框中的事務(wù)日志頁(yè)框各參數(shù)說明如下：各參數(shù)說明如下： create database companyon primary(name=company_data,filename=d:mssql7datacompany.mdf,size=10,maxsize=unlimited,filegrowth=10%)log on(name=company_log,filename=d:mssq

3、l7datacompany.ldf,size=1,maxsize=5,filegrowth=1) create database employeeson primary(name=employee1,filename=d:mssql7dataemployee1.mdf,size=10,maxsize=unlimited,filegrowth=10%),(name=employee2,filename=d:mssql7dataemployee2.mdf,size=20,maxsize=100,filegrowth=1)log on (name=employeelog1,filename=d:mssql7data employeelog1.ldf,size=10,maxsize=50,filegrowth=1),(name=employeelog2,filename=d:mssql7dataemployeelog2.ldf,size=10,maxsize=50,filegrowth=1)