問題詳情
二、假設某一企業的關聯資料庫(Relational Database)中有三個表格(Table): 員工 Table E(E_num, E_name, E_age)(欄位依序代表員工編號、員工姓名、 員工年齡,其中{E_num}為主鍵(Primary Key)) 部門 Table D(D_num, D_name, D_leader_num, D_city)(欄位依序代表部門代 號、部門名稱、部門主管編號、部門所在城市,其中{D_num}為主鍵, 部門主管也是員工) 任務派遣 Table J(J_num, J_name, Je_num, Jd_num, J_date)(欄位依序代表任務代號、任務名稱、被派遣員工編號、派遣至部門代號、派遣日期,其中{J_num, Je_num, Jd_num, J_date}為主鍵) 假設每個員工除了部門主管外,不是固定歸屬在某一部門工作,而是每天都有可能被派遣去支援任何部門之工作任務:
⑴為求維持資料的一致性,請問應該建置那些外來鍵(Foreign Keys)?(6 分)如果沒有建置這些外來鍵,請列出所有可能會發生的問題?(7 分)
⑴為求維持資料的一致性,請問應該建置那些外來鍵(Foreign Keys)?(6 分)如果沒有建置這些外來鍵,請列出所有可能會發生的問題?(7 分)
參考答案
答案:B
難度:簡單0.732308
統計:A(35),B(238),C(10),D(13),E(0)
內容推薦
- 七、請寫出 Tamoxifen 與 Raloxifene 之構造與臨床用途,並解釋為何其同樣作用於雌性接受體(estrogen receptor)卻有不同之藥理作用?(15 分)
- ⑸找出有演出過被評為最爛電影,但是沒有演出過被評為最佳電影的男女演員。
- 16 The shortsighted effort to protect against every attempt by the government to enter an individual
- 24 Which of the following descriptions about chimpanzees is NOT true?(A)Chimps remember the posi
- ⑷找出同時屬於動作與恐怖類,但是沒有戰爭這個關鍵字的電影名稱。
- 四、圖四放大器之電晶體以直流電源 I 偏壓,其他部分偏壓電路業經省略。電路元件與電晶體小訊號參數:RB = 10 kΩ, RC = 20 kΩ, Rsig = 0.5 kΩ, RL = 10 kΩ,
- 15 (A)if only (B)even when (C)so that (D)only because
- 23 What can be inferred from the fact that chimps obtain food through competition or cooperation
- 三、當資料庫管理系統允許交易(Transactions)同步(Concurrent)執行,但資料庫管理系統卻沒有進行任何同步控制(Concurrent Control)的情形下: ⑴請舉例說明
- 30 According to the passage, which of the following statements is true?(A)All the self-narrative
內容推薦
- 33 Who was the first that turned growing grapes into a business in Napa Valley?(A)George Crane (
- 35 Based on this passage, when is the prime time of the wine industry in Napa Valley?(A)Before 1
- ⑵何謂 Locking 機制?為何可避免上述⑴三個可能發生的問題,請分別說明之?(6 分)
- ⑶上述 Locking 機制可能會造成 Transactions 發生 Deadlock。請說明何謂 Two-phaseLocking Protocol?(5 分)
- 38 (A)When we make new changes, we step outside our comfort zone.(B)This is where creativity and
- Based on the practice of chromotherapy in ancient China and Egypt, patients suffering from s
- ⑵請問何謂功能相依(Functional Dependency)?(5 分)
- ⑷請問如何處理關聯綱目 R,使它符合第(n+1)正規化型式(須詳述原因)。(8 分)
- 36 According to the passage, which of the following statements is true?(A)The wine business of N
- What can we infer from the article?(A) Younger people have better memory.(B) A catchy phrase
- 一、如圖一所示電路為由一 CS(共源)放大器串接一 CG(共閘)放大器所構成的疊接(Cascode)放大器,其偏壓電路略去未繪。設各電晶體具相同特性,其 gm = 1 mA/V,ro→∞;又 Rsig
- 三、英文作文:(20 分) Write an English essay in NO MORE THAN 250 words on the following topic:Do you agree o
- This article is most likely found in_____ .(A) a literary journal(B) a travel guidebook(C) a
- [Afriend loves at all times, and a brother is born foradversity.]---Proverbs 17:17 Alot of people go
- Success belongs to the d t students, not to the lazy ones.
- This movie contains too many violent scenes, so it is not s e for kids to watch.
- Red is the color which usually i es danger; thus, hot-water faucets are often labeled red.
- 第 37 題至第 40 題為篇章結構,各題請依文意,從四個選項中選出最合適者,各題答案內容不重複 Habits are a funny thing. We reach for them mindles
- Which of the following is NOT the author’s point of view toward friends?(A) Friends are abso
- As time went by, John g ly accepted the fact that his father had passed away.
- 一、如 圖 所 示 為 一 由 理 想 OP 放 大 器 所 構 成 之 電 路 。 分 別 求 v 01 、 v 02 以 及 增 益A=(v01-v02)/(v1-v2)。(20 分)
- 連貫式翻譯(12%): 一格不限一字。 不用說,學生上課參與課堂活動越多,就學得越好。為了要改善學習,學生需要聽老師、寫筆記,甚至還要問問題。大部分的學生都主動參與,但是有些
- When it comes to having perfectmemory, sometimes we can’t help but wonder whether there’s somefault
- 39 (A)When we make new changes, we step outside our comfort zone.(B)When we make a decision, bas
- Seeing a house on fire, Kenny called 911 i y. The fire engine came right away.