1 / 42

HỆ QUẢ TRỊ CƠ SỞ DỮ LIỆU QUẢN LÝ THƯ VIỆN

HỆ QUẢ TRỊ CƠ SỞ DỮ LIỆU QUẢN LÝ THƯ VIỆN. GVHD: Nguyễn Văn Chức SVTH : Nhóm 2 Lớp : C10QT1. 5. 1. 2. 3. 4. Các thực thể trong quản lý thư viện. Sơ đồ thực thể thư viện – quan hệ. Các bảng thuộc tính. Sơ đồ liên kết. NỘI DUNG. Bảng dữ liệu Access.

chloe-bush
Download Presentation

HỆ QUẢ TRỊ CƠ SỞ DỮ LIỆU QUẢN LÝ THƯ VIỆN

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. HỆ QUẢ TRỊ CƠ SỞ DỮ LIỆUQUẢN LÝ THƯ VIỆN GVHD: Nguyễn Văn Chức SVTH : Nhóm 2 Lớp : C10QT1

  2. 5 1 2 3 4 Các thực thể trong quản lý thư viện. Sơ đồ thực thể thư viện – quan hệ Các bảng thuộc tính Sơ đồ liên kết NỘI DUNG Bảng dữ liệu Access Company Logo

  3. Các thực thể trong quản lý thư viện. Nhan vien ( msnv, Luong, QQ ,gioitinh, nsinh, Dchi, Dthoai, makho ) Phieu xuat ( Mspx ,ngayxuat, Tonggt) Nhacung cap (MaNCC , TenNCC, Dchi, Dthoai, Email) Sach ( Masach , Tensach, Soluong, Theloai, Giasach, NamXB, TenTG, Tap ) The ( Mathe, Ngay cap, Loai the, cmnd ) Khach ( cmnd, ten, tuoi , diachi , Mspn ) Quay thu ngan ( Maqtn, Ngay, Gio, Tong, msnv ) makho ( makho , Masach, tenkho , Theloai, mspx) Phieu muon ( Mspm, Masach, Maqtn, Ngay lap, Ttien, Cmnd, Mthe, Hethan, msnv) Company Logo

  4. Sơ đồ thực thể thư viện – quan hệ Sơ đồ thực thể Company Logo

  5. Company Logo

  6. Company Logo

  7. Company Logo

  8. Company Logo

  9. Sơ đồ quan hệ Company Logo

  10. 3. Các bảng thuộc tính Bảng khách Company Logo

  11. Bảng kho Company Logo

  12. Bảng Nhà cung cấp Company Logo

  13. Bảng Nhân viên Company Logo

  14. Bảng Phiếu mượn Company Logo

  15. Bảng Phiêu nhập Company Logo

  16. Bảng phiếu xuất Company Logo

  17. Bảng quầy thu ngân Company Logo

  18. Bảng sách Company Logo

  19. Bảng thẻ Company Logo

  20. 4. Sơ đồ liên kết Company Logo

  21. 5. Bảng dữ liệu Access BẢNG ACCESS Company Logo

  22. Thành viên trong nhóm : • Đinh Phi Dương • Hoàng Việt Dũng • Hoàng Văn Đại • Nguyễn Thị Mỹ Duyên • Trần Phạm Thu Diễm Company Logo

  23. Company Logo

  24. Company Logo

  25. Company Logo

  26. Diagram Title Add your text ThemeGalleryis a Design Digital Content & Contents mall developed by Guild Design Inc. ThemeGalleryis a Design Digital Content & Contents mall developed by Guild Design Inc. Company Logo

  27. Add Your Text Text Text Cycle name Text Text Text Cycle Diagram Company Logo

  28. Text • Add Your • Title Text • Text 1 • Text 2 • Text 3 • Text 4 • Text 5 • Add Your • Title Text • Text 1 • Text 2 • Text 3 • Text 4 • Text 5 Text Text Text Text Diagram Company Logo

  29. Text Text Concept Text Text Text Text Add Your Text Diagram Company Logo

  30. Add Your Text Add Your Text Add Your Text Add Your Text Diagram Add Your Text Add Your Text Add Your Text Add Your Text Company Logo

  31. Diagram Add Your Text Add Your Title Add Your Text Add Your Text Company Logo

  32. Diagram Text Text Text ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. Company Logo

  33. Text Diagram Text Text Add Your Title Text Company Logo

  34. Concept Concept concept Concept Diagram Company Logo

  35. 1 2 3 ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. ThemeGallery is a Design Digital Content & Contents mall developed by Guild Design Inc. Diagram Company Logo

  36. 2004 2001 2002 2003 Diagram Your Text Your Text Your Text Your Text Your Text Your Text Your Text Your Text Company Logo

  37. Phase 1 Phase 2 Phase 3 Progress Diagram Company Logo

  38. Diagram Company History 2003 2000 2003.10 Add Your Text 2003.10 Add Your Text 2003.10 Add Your Text 2002 2000.10 Add Your Text 2000.10 Add Your Text 2000.10 Add Your Text 2002.10 Add Your Text 2002.10 Add Your Text 2002.10 Add Your Text 2001 2001.10 Add Your Text 2001.10 Add Your Text 2001.10 Add Your Text Company Logo

  39. Table Company Logo

  40. 3-D Pie Chart Text2 Text3 Text1 Text4 Text5 Company Logo

  41. Concept concept Concept Concept Block Diagram Add Your Text Add Your Text Company Logo

  42. Thank You ! www.themegallery.com

More Related