Transcript Document
INTRODUCING E-R Diagrams – Entity relationship SCHEDULE Class Id CLASS_NAME PROFESSOR ROOM_NUM DAY TIME CAMPUS MAJORID H_SSTUDENT Student Id LAST_NAME FIRST_NAME ADDRESS CITY STATE ZIP SCORE RANK H_SCHOOL CLASSES Professor CLASS_ID CLASS_NAME STU_SSN MAJORID WCCC_STUDENT Stu_ssn LAST FIRST MAJORID ACCEPTANCE REJECTION LOGIC start IF THEN If score = (90 – 100) and rank >= 75% ELSE THEN IF If score = (80 – 89) and rank >= 50% ELSE IF THEN If score = (70-79) and rank >= 25% REJECTION ELSE ACCEPTANCE SUPERB AGENDA LIST ALL HIGH SCHOOL STUDENTS CREATE ACCEPTANCE LIST ORDERED BY HIGH SCHOOL CREATE REJECTION LIST ORDERED BY HIGH SCHOOL LIST ALL WWWC3 STUDENTS DO A SINGLE STUDENT REPORT H_S STUDENT TABLE STUDENT ID 7098 7890 6756 8975 5634 6231 7998 8652 1243 8970 7568 6731 1111 6668 6675 7008 7078 7755 7112 4456 LAST_NAME 'Bester' Stockdale Reynolds Powell Strong Jackson McClendon Fraiser Faivre Tyson Sanders Moffitt Prince Daniel Patel Jones Benson Currie Ahmed Ferguson FIRST_NAME Sherritha Cynthia Marya Clinton Vanessa Kyle Reece Jason Antoine Donald Juanita Saeree Angel Tamika Dinesh Susan George Blake Musa Sara ADDRESS 624Randall 1635 Cochrand 2943 Lewis 1756 12th 3467 Burns 7765 Steel 2134 Argo 246 Godwin 1000 Mercury 465 Enoch 767 Scott 627 Hardy 777 Butternut 1256 Woodward 12300 Freud 12349 8 Mi Rd 17145 Mack 9594 Dix 3501 Chene 6242 Parkview CITY Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit Detroit STATE MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI MI ZIP '48206' 48208 48202 48207 48278 48209 12366 48289 48222 48206 48267 48289 48204 48209 48215 48206 48224 48212 48207 48214 SCORE 97 89 79 71 82 99 91 85 77 80 92 84 73 81 78 95 74 94 87 93 RANK 75 50 25 50 75 75 50 25 25 75 75 50 50 75 25 50 75 75 50 25 H_SCHOOL CASS TECH HS PERSHING HS COOLEY HS CASS TECH HS OSBORN HS PERSHING HS CASS TECH HS OSBORN HS PERSHING HS COOLEY HS CASS TECH HS COOLEY HS CASS TECH HS PERSHING HS OSBORN HS CASS TECH HS CASS TECH HS COOLEY HS PERSHING HS OSBORN HS WCCC_STUDENT TABLE STU_SSN 380-58-6052 380-58-5850 380-52-2985 380-65-3322 380-87-9587 380-41-5471 380-58-6242 380-52-7896 380-11-2111 380-66-3694 LAST Jacob Doe Bishop Smith Curry White Williams Rucker Howse Hart FIRST Joe Jane Kisha Sam Blake Sue Clarence Keith Chanell Jeff MAJOR_ID 335 421 200 720 335 720 530 335 720 421 SCHEDULE TABLE CLASS_ID 63857-301 29753-302 50631-301 00266-302 73925-301 46674-301 25020-302 42323-10 46212-107 05534-101 91429-301 91429-305 63857-306 63857-307 63857-309 63857-303 63851-301 CLASS_NAME ENG110 ACC110 ALH105 BIT100 CIS210 MAT105 SOC100 BIO150 BUS150 BUS221 PSY101 PSY101 ENG110 CIS 110 MATH 113 TCM 200 ENG120 PROFESSOR CAMPBELL, ROBERT BYRON, THOMAS HALL, BILL HANES, APRIL KNOX, ELLIS DIAMOND, JEWELL WATERS, JOSEPH HENRY, WATTS GORDON, LULA JOHNSON, JOHN MONROE, RHONDA WILSON, MARY CAMPBELL, TRINEEN PERSON, ROBERT GREER, ROBERT BELL ,ROBERTA LEWIS, FIONA ROOM_NUM 242 233 123 330 340 222 321 244 122 249 251 302 125 152 325 342 246 DAY S TTR MW MW T F TR MW S F S M TR W T MW MW TIME 1:00P-3:00P 8:00A-10:00A 8:00A-10:30A 9:00A-11:00A 5:00P-8:00P 7:00P-10:00P 11:00A-2:00P 10:00A-12:00P 8:00A-11:00A 11:00A-2:00P 7:00P-11:00P 11:00A-1:00P 6:00P-9:00P 7:00P-10:00P 6:30P-9:30P 8:00A-11:00A 3:00P-5:00P CAMPUS DOWNTOWN DOWNRIVER DOWNTOWN NORTHWEST DOWNTOWN EASTERN NORTHWEST DOWNTOWN WESTERN NORTHWEST DOWNTOWN DOWNTOWN DOWNRIVER EASTERN NORTHWEST NORHTWEST EASTERN MAJORID 335 200 530 421 421 720 720 720 335 335 530 421 421 421 530 421 421 CLASSES TABLE PROFESSOR CAMPBELL, ROBERT LEWIS, FIONA BYRON, THOMAS HALL, BILL HANES, APRIL KNOX, ELLIS DIAMOND, JEWELL WATERS, JOSEPH HENRY, WATTS GORDON, LULA JOHNSON, JOHN CLASS_ID 63857-301 63851-301 29753-302 50631-301 00266-302 73925-301 46674-301 25020-302 42323-10 46212-107 05534-101 CLASS_NAME ENG110 ENG120 ACC110 ALH105 BIT100 CIS210 MAT105 SOC100 BIO150 BUS150 BUS221 STU_SSN 380-58-6052 380-58-5850 380-52-2985 380-65-3322 380-87-9587 380-66-3694 380-66-3694 380-66-3694 380-66-3694 380-66-3694 380-66-3694 MAJORID 335 421 200 720 421 421 720 720 720 335 335