tailieunhanh - Databases Demystified a self teaching guide phần 6

Tiêu chuẩn SQL ủy ban đã được thành lập bởi ANSI (Viện tiêu chuẩn Quốc gia Hoa Kỳ) vào năm 1986 và ISO (Tổ chức tiêu chuẩn quốc tế) vào năm 1987. Hai năm sau, đặc điểm kỹ thuật tiêu chuẩn đầu tiên, được biết đến như SQL-89, được xuất bản. Tiêu chuẩn này đã được mở rộng ba năm sau đó vào SQL-92, nặng trong lúc | CHAPTER 6 Logical Database Design Using Normalization effort is underway which includes building integrated application and database systems to perform basic business functions. The User Views UTLA wishes to construct a system to track their academic activities including course offerings instructor qualifications for the courses course enrollment and student grades. The following illustrations show the desired output reports with sample data these are the user views that should be normalized . Student report ID Name Mailing Address Home Phone 45Ể7 Helen Wheels 127 Essex Drive Hayward CA 94545 510-555-2859 49 7 3 Barty Bookworm . Box 45 Oakland CA 94ỂŨ1 510-555-9403 6758 Carla Coed South Hall 23 Berkeley CA 94Ể23 51Ũ-555-DORM Course report ID Title No. Credits Prerequisite Courses Description XI00 Concepts of Data Proc. 4 none This course X3Ũ1 COBOL I 4 XI00 blah blah. X3Ũ2 COBOL II 6 X3Ũ1 Continuation of. X422 Systems Analysis 6 X3Ũ1 Introduction to. X4Ũ8 Concepts of DBMS 6 X3Ũ1 X422 more blah blah Instructor report ID Name Home Address 75Ể WerdnaLeppo 12 Main St. Alameda cA 94501 Home Phone 51Ũ-97Ể-CLAS Office Phone X-74Ể3 Courses X408 X422 795 Cora Coder 32767 Binary Way Abend CA 21304 510-555-1010 x-5382 X3Ũ1 X3Ũ2 801 Tillie Talker 123 Forms Rd. 510-555-BLAB x-3547 XI00 Paperwork CA 95Ể84 Databases Demystified Section report Year 1994 Semester Spr Building Evans Room 70 Day s Tu Time s 7-10 Instructor 7 5 6 Wetdna Lepp 0 Course X4ŨS Credits Student ID 4ÍỂ7 Ể758 Student N ame Helen Wheels Carla Coed Grade B Ể Year 1994 Semester spr Building SFO Room 70 Instructor 756 Werdna Leppo Course X4Ũ8 Day s We Time s 7-10 Credits Ể Student ID Student N ame Grade 4973 Barry Bookworm B One cannot design a database without some knowledge of the business rules and processes of an organization. Here are a few such items to keep in mind Only one mailing address and one contact phone number are kept for each student. Each course has a fixed number of credits that is there are