modern database management 8th edition PHẦN 5

Hãy suy nghĩ trường học hoặc công ty của bạn có thể hưởng lợi từ việc sử dụng cuốn sách này? Nói với nó để mua các bản sao hoặc giấy phép bị ràng buộc cuốn sách này ở định dạng điện tử. Tổ chức, chẳng hạn như trường học và các tập đoàn, phải mua hoặc Visibooks giấy phép sử dụng của sinh viên và nhân viên của họ. | CHAPTER 5 LOGICAL DATABASE DESIGN AND THE RELATIONAL MODEL Attorney Figure 5-35 Relations for Problem and Exercise 15 AttorneyJD Name Address City State ZipCode Special ity_T AttorneyJD Speciality Bar AttorneyJD Bar Client ClientJD Name Address City State ZipCode Telephone DOB Case CaseJD Description CaseType CourtJD Retains AttorneyJD CaseJD ClientJD Date Court CourtJD Judge Court_Name City State Zipcode JudgeJD Name Years CourtJD Figure 5-36 EER diagram for university dining services Date4 Last_Customer_Name Customer_Namel Cus-tomer_Name2 Customer_Name3 Customer_Name4 Assume that we want to track all purchase and inventory data such as who bought the fish the date that it was purchased the date that it was delivered and so on. The present file format allows only the tracking of the last purchase and delivery as well as four prior purchases and deliveries. We can assume that a type of fish is supplied by one supplier. a. Show all functional dependencies. b. What normal form is this table in c. Design a normalized data model for these data. Show that it is in 3NF. 17. For Problem and Exercise 16 draw the ER diagram based on the normalized relations. FIELD EXERCISES 233 Tempest Investment Services 12832 Parkside Drive Boston MA 02110 800 232-1322 Figure 5-37 Brokerage account summary Brokerage Account Summary Statement Date 9 2 2006 Period 8 1 2006 - 8 31 2006 Client Name Harold Smith Jr. Account Number 392-21342 Agent K. Weld Symbol Type Description Shares Price Total T Stock ATT Common 1900 20 38 000 vz Stock Verizon 2000 40 80 000 PG Stock Proctor and 10000 90 900 000 Gamble Portfolio Total 1 018 000 18. How would Problems and Exercises 16 and 17 change if a type of fish could be supplied by multiple suppliers 19. Figure 5-36 shows an EER diagram for a university dining service. This organization provides dining services to a major university. a. Transform the EER diagram to a set of relations and develop a relational schema. b. Diagram the functional .