| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/_Archive/Notes/ |
Upload File : |
CST1600_wk06_20180213_part1 View lecture part 1 CST1600_wk06_20180213_part2 View lecture part 2 CST1600_wk06_20180213_part3 View lecture part 3 (Lab 4) * = primary key (unique identifier) @ = foreign key (points to a primary key or unique identifier in another table) ^ - unique field. Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade) 00007968, Jim Martinson, CST AAS, CST1600, Relational Database Design, 00007968, Jim Martinson, rm327b, NULL) 12345678, Jane Doe, CP AAS, CST1600, Relational Database Design, 00007968, Jim Martinson, rm327b, NULL) 00007968, Jim Martinson, CST AAS, CST1602, Advanced Databases, 00007968, Jim Martinson, rm327b, NULL) 00007968, Jim Martinson, CST AAS, CST1600 & CST1602, Relational Database Design & Advanced Databases, 00007968, Jim Martinson, rm327b, NULL & NULL) 1NF Student (StudentNo*, StudentName, Major) 00007968, Jim Martinson, CST AAS 12345678, Jane Doe, CP AAS StudentCourse (StudentNo*@, CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade) 00007968, CST1600, Relational Database Design, 00007968, Jim Martinson, rm327b, NULL 12345678, CST1600, Relational Database Design, 00007968, Jim Martinson, rm327b, NULL 00007968, CST AAS, CST1602, Advanced Databases, 00007968, Jim Martinson, rm327b, NULL 2NF Student (StudentNo*, StudentName, Major) 00007968, Jim Martinson, CST AAS 12345678, Jane Doe, CP AAS CourseGrade (StudentNo*@, CourseNo*@, Grade) 00007968, CST1600, NULL 12345678, CST1600, NULL 00007968, CST AAS, NULL CourseInstructor (CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation) CST1600, Relational Database Design, 00007968, Jim Martinson, rm327b CST1602, Advanced Databases, 00007968, Jim Martinson, rm327b 3NF Student (StudentNo*, StudentName, MajorId@) 00007968, Jim Martinson, 1 12345678, Jane Doe, 2 CourseGrade (StudentNo*@, CourseNo*@, Grade) 00007968, CST1600, NULL 12345678, CST1600, NULL 00007968, CST1602, NULL 12345678, CST1021, NULL Course (CourseNo*, CourseName, InstructorNo@) CST1600, Relational Database Design, 00007968 CST1602, Advanced Databases, 00007968 CST1021. HTML, 01010101 Instructor (InstructorNo*, InstructorName, InstructorLocation) 00007968, Jim Martinson, rm327b 01010101, Allen Benusa, rm327d Major ( MajorId*, MajorCode, MajorName ) 1, CST AAS 2, CP AAS Example with Ridgewater class schedule ClassId Class # Sec Class Title Cr Enr Max Meeting Dates Days Time Bldg Rm Instructor Footnotes 001041 ACCT1816 41 Prin Acct 2 4 15 33 01/08/18 - 05/11/18 MTWH Arranged ON Online Wagner, Charlotte 001045 ACCT1834 51 Comp Acct I 3 15 33 01/08/18 - 05/11/18 Arranged ON Online Gauer, Michelle Class( ClassId*, ClassNo@, Sec, Enr, Max, MeetingDates, Days, Time, RmId@, InstructorId@, Footnotes ) Course( ClassNo*, ClassTitle, Cr ) Bldg( BldgId, BldgName ) Rm ( RmId, Rm, BldgId ) Instructor ( InstructorId, Instructor ) 1NF - No repeating groups Customer( CustId, TrID ) 1, 12890;12904 Customer( CustId, TrID1, TrID2, TrID3 ) 1, 12890, 12904, NULL Customer ( CustId* ) 1 CustTrans ( CustId@, TrID ) 1, 12890 1, 12904 emp_id emp_name emp_address emp_dept 101 Rick Delhi D001 101 Rick Delhi D002 123 Maggie Agra D890 166 Glenn Chennai D900 166 Glenn Chennai D004 3NF emp ( emp_id emp_name emp_address ) 101 Rick Delhi 101 Rick Delhi 123 Maggie Agra 166 Glenn Chennai 166 Glenn Chennai dept ( dept_id ) D001 D002 D004 D890 D900 emp_dept ( emp_id@ dept_id ) 101 D001 101 D002 123 D890 166 D004 166 D900 1NF emp_id emp_name emp_address emp_mobile 101 Herschel New Delhi 8912312390 102 Jon Kanpur 8812121212 102 Jon Kanpur 9900012222 103 Ron Chennai 7778881212 104 Lester Bangalore 9990000123 104 Lester Bangalore 8123450987 3NF emp ( emp_id*, emp_name, emp_address ) emp_mobile ( empid@*, mobile* )