说出3个会发生的问题如所有资料用单一资料表储存.docVIP

Identify three problems in updating if all the information is placed in a single table. Hence, explain why a database usually consists of more than one table. 說出3個會發生的問題如所有資料用單一資料表儲存，並解釋為何資料表通常以多於一個資料表去儲存。 In a RDBMS, tables are logically linked together. Explain the terms “logical linked”. 在RDBM 資料表是邏輯的關關，解釋何謂邏輯關聯。 In Visual FoxPro, multiple tables can be open simultaneously in different work areas. Write command to 在Visual FoxPro 中，多個資料表是可以同時在不同的工作區開啟，寫出執行下列工作的指令 assign an alias to a work area 在工作區加入別名 choose a specified work area for a table 選取資料表工作區 switch between different work areas 選取不同的工作區 access information from a remote work area. 取得其他工作區的資料 4. Consider the following commands: 下列指令 SELECT A SET RELATION TO B INTO C Identify the parent table, the child table and the common key expression. 說出父母資料表，子女資料表，及關鍵欄位 A computer game records the results of the players in two files: 電腦遊戲用下列資料表去記錄結果 We have to open the files in two work areas and set up relation so that every record in the table result could be mapped to the corresponding record in player. 假設兩資料表需做到互相關聯去取得每項資料 What are the two commands to assign exercise23-5-player in work area and give alias splayer for the work area. 那兩句指令可將exercise23-5-player 資料表用別名splayer 建立工作區 Add two commands to assign exercise23-5-result in another work area and give alias sresult for the work area. 加多兩句指令去將資料表exercise23-5-result用別名sresult建立另一工作區 Add the command to select splayer and set index key playcode 加入指令去將splayer成為索引檔案，索引鍵為playcode Add command to set relationship with splayer and sresult. Parent is sresult, child is splayer 加入指令去將splayer及sresult作關聯， sresult 作為父母資料表，child作為子女資料表。 Write down the results for the following: 寫出下列指令的結果 List splayer.name, points for points250 A fashion company stores the sales records of the customers in four related files: 一間服裝店用四個資料表儲存銷售記錄，顧客記錄，點存記錄，購貨記錄 SALES.DBF CUSTOMER.DBF STOCK.DBF Fields Name Type Width Dec SaleCode Character 10 Description Character 30 PURCHASE.DBF F