database

dist資料夾中的index.html是主頁，進入主頁後，可以依照要查詢的內容選擇：

1. Serch by Package ID：利用包裹編號查詢，查詢結果包含包裹的相關資料
2. Serch Sent Out：利用日曆查詢客戶當天寄出的包裹(建議搜尋#幾月幾號)
3. Delay：查詢延誤送達的包裹(僅該客戶)
4. Search MVP Customer：包含查詢年度運費最多及年度寄件最多的客戶(降序排列)
5. Serch Delivery：可以依照卡車查詢包裹現在的狀態 (以上頁面如果要回到主頁，請按上一頁)
6. Profile：能夠看到客戶自己的相關資訊

E-R Model

Relational schema

select count(*)

The code for each queries

• Find the customer who has shipped the most packages in the past year. • Find the customer who has spent the most money on shipping in the past year. • 查詢卡車 • 查詢倉庫 • 查詢國際航班 • delay

queries in section 4

• 查詢卡車編號，沒有送達時間的就是尚未送達，然後因為它是出事了，所以就是出事了，然後前一個送達時間就是前一筆運送的包裹 • Find the customer who has shipped the most packages in the past year.

• Find the customer who has spent the most money on shipping in the past year.

• Find those packages that were not delivered within the promised time

• 包裹編號查詢，因為有輸入所以只有一筆