【正文】 .......................3. 數(shù)據(jù)的共享與獨立性 ...........................................................................................................3. 事物需求 ........................................................................................................................................3. 數(shù)據(jù)字典 ........................................................................................................................................3. users 表（用戶表） ..............................................................................................................3. ticketsinf 表 (車次詳細信息表 ) .............................................................................................4. putongliechejiage 表（普通列車價格表） ..........................................................................4. putongliechewopujiage 表（普通列車臥鋪價格表） .........................................................4. kongtiaoliechejiage 表（空調列車價格表） .......................................................................5. kongtiaoliechewopujiage 表（空調列車臥鋪價格表） ......................................................5. dingpiao 表 (訂票紀錄表 )......................................................................................................53. 方案圖表設計 ................................................................................................................................6. 關系模式 ........................................................................................................................................6. ER 圖 .............................................................................................................................................6. 數(shù)據(jù)流程圖 ....................................................................................................................................7. 關系圖： ........................................................................................................................................74. 數(shù)據(jù)庫源代碼 ................................................................................................................................8. 數(shù)據(jù)庫建立 ....................................................................................................................................8. 創(chuàng)建數(shù)據(jù)庫 ...........................................................................................................................8. users 表（用戶表）建立 ......................................................................................................8. ticketsinf 表 (車次詳細信息表 )建立 .....................................................................................8. putongliechejiage 表（普通列車價格表）建立 ..................................................................9. putongliechewopujiage 表（普通列車臥鋪價格表）建立 .................................................9. kongtiaoliechejiage 表（空調列車價格表）建立 ...............................................................9. kongtiaoliechewopujiage 表（空調列車臥鋪價格表）罰款單表建立 ..............................9. dingpiao 表 (訂票紀錄表 )建立 ............................................................................................102 / 24. 數(shù)據(jù)初始化 ..................................................................................................................................10. 將用戶加入 users 表中 .......................................................................................................10. 將車次信息加入 ticketsinf 表中 .........................................................................................11. 將普通列車價格加入 putongliechejiage 表中 ...................................................................14. 將普通列車臥鋪價格加入 putongliechewopujiage 表中 ..................................................14. 將空調列車價格加入 kongtiaoliechejiage 表中 ................................................................15. 將空調列車臥鋪價格加入 kongtiaoliechewopujiage 表中 ...............................................15. 將訂票記錄加入 dingpiao 表中 .........................................................................................165. 結果數(shù)據(jù)處理 ...............................................................................................................................16. 單表查詢 ......................................................................................................................................16. 表 users 中查詢 .................................................................................................................