Please enable JavaScript.
Coggle requires JavaScript to display documents.
Table (資料表) : (Content (內容) (Key (索引鍵) (Primary key (主索引鍵), foreign key…
Table (資料表) :
Content (內容)
Key (索引鍵)
Primary key (主索引鍵)
foreign key (外部索引鍵)
composite key (複合索引鍵)
Record (資料行)
Field, column(欄位)
Relationship (關係)
One to many relationships (一對多關聯)
One to one relationship (一對一關聯)
Category(類別)
Table (資料表)
Junction Table (聯合資料表)
Definition (定義)
Store data
(儲存資料)
Database Objects
(資料庫元件)
Report (報表) :
Content (內容)
Data from multiple tables
(來自多個資料表的紀錄)
Definition (定義)
analyze or print data in a specific layout.
(分析或在特定版面配置中列印資料)
Application(應用)
mailing labels
(郵寄標籤)
display calculated totals
(顯示計算總和)
show totals in a chart
(顯示圖表中的總計)
Form (表單)
Definition (定義)
view, add, and update data in tables
(檢視或輸入資料)
Content (內容)
A form focuses on one record at a time
(表單一次會集中在一筆記錄)
Display fields from more than one table
(可以顯示多個資料表的欄位)
Display pictures and other objects
(顯示圖片和其他物件)
Contain buttons
(可包含按鈕)
Data from multiple tables (來自多個資料表的紀錄)
Query (查詢)
Meet the condition
(符合指定條件)
Data from multiple tables (來自多個資料表的紀錄)
Content (內容)
Shows searching field
(顯示搜尋欄位)
Definition (定義)
find and retrieve just the data that you want
(擷取資料)