modern database management 8th edition PHẦN 2

Chọn cơ sở dữ liệu mặc định của bạn và kích Next. 7. Điền vào các thiết lập cuối cùng, và nhấn Finish. 8. Kiểm tra kết nối ODBC mới của bạn. SQL Native Client cung cấp một tính năng rất hữu ích để giúp xác nhận rằng kết nối của bạn đã được thiết lập một cách chính xác. Chỉ cần nhấp vào nút Test Data Source (thể hiện trong hình B-8) để khởi động này | CHAPTER 1 THE DATABASE ENVIRONMENT PATIENT Patient Number Patient Last Name Patient First Name Patient Address 8379 Dimas Selena 617 Valley Vista 4238 Dolan Mark 818 River Run 3047 Larreau Annette 127 Sandhill 5838 Wiggins Brian 431 Walnut 6143 Thomas Wendell 928 Logan MVCH Figure 1-1 Two database tables from Mountain View Community Hospital PATIENT CHARGES Item Description Item Code Patient Number Amount Room Semi Priv 200 4238 1600 Speech Therapy 350 3047 750 Radiology 275 4238 150 Physical Therapy 409 5838 600 EKG Test 500 8379 200 Room Semi-Priv 200 3047 800 Standard IV 470 8379 150 EEG Test 700 4238 200 6. How are data in the PATIENT and PATIENT CHARGES tables related That is how can a user find the relevant charges for a particular patient 7. Give an example of how the hospital could use each of the types of databases described in this chapter personal workgroup departmen tai divisional enterprise and Web-enabled 8. How could the hospital use Web-based applications What are some of the benefits and risks associated with Web-based applications for the hospital CASE EXERCISES 1. Using the notation introduced in this chapter draw a diagram showing the relationship between the entities PATIENT and PATIENT CHARGES. 2. Develop a metadata chart for the data attributes in the PATIENT and PATIENT CHARGES tables using at minimum the columns shown in Table 1-1. You may include other metadata characteristics that you think are appropriate for the management of data at Mountain View Community Hospital. 3. One of the important database views for the hospital is the Patient Bill MVCH Figure 1-2 . Following is a highly simplified version of this view. Fill in the missing data in this view using the data from MVCH Figure 1-1. 4. Using the notation introduced in this chapter draw a single diagram that represents the following relationships in the hospital environment. A HOSPITAL has on its staff one or more PHYSICIANS. A PHYSICIAN is on the staff of only one HOSPITAL. A .