#Note that the data given below may have to be broken into several #tables depending on your conceptual schema. I have presented most #related info in one row, but the tables shown below are not #necessarily the schemas you should to have. USERS #------------------------------------------ ID NAME PASSWORD STATUS 100000001 Zaki, Mohammed yjtthtye Faculty 100000002 Adali, Sibel xpppaaay Faculty 100000003 Moten, Rod poyumpal Faculty 100000004 Kettnaker, Vera dkihkfhj Faculty 100000005 Akella, Srinivasan mfdinmdi Faculty 100000006 Musser, Dave mkdsdksj Faculty 100000007 Freedman, Dan kldskdsd Faculty 100000008 Spooner, David sdskhsdk Faculty 100000009 Stewart, Charles ghfdksjs Faculty 100000010 Alexander, Samuel ctfsqyjs Student 100000011 Beaty, Kevin kutgrrxt Student 100000012 Croak, David gabdwkeg Student 100000013 Campbell, Hamilton urxnysqk Student 100000014 Garfunkel, James mbuukaad Student 100000015 Green, Brad pkntvrxd Student 100000016 Jing, Rongrong vthsfgcv Student 100000017 Lam, Mitchell vkshcxau Student 100000018 Little, Jeremy tnpbccwq Student 100000019 Montaigne, Marian pekvugxd Student 100000020 Gupta, Mukund rnxkyhqj Student 100000021 Keller, Diana xkjysvnx Student 100000022 Westing, John xmmmfdtf Student 100000023 Wolpert, Desmond nswhhwsu Student 100000024 Yahoo, Nathan wjyxsjrw Student 100000025 Ying, Nan nktwkvqv Student 100000026 Zhong, Chun nymefxgf Student 100000031 Kalyanaraman, Shiv fdhjgdss Faculty 100000032 Perlman, William reyuydsk Faculty 100000033 Abouzeid, Alhussein fdhjshds Faculty TRANSCRIPT #------------------------------------------ ID CRSCODE SEM YR GRADE 100000015 CS1100 SPRING 2001 A 100000016 CS1100 FALL 2000 A 100000017 CS1100 FALL 2001 B 100000018 CS1100 SPRING 1999 C 100000019 CS1100 SPRING 1998 A 100000020 CS1100 FALL 1997 C 100000018 CS1200 SPRING 2000 B 100000019 CS1200 SPRING 1999 B 100000020 CS1200 FALL 1998 A 100000021 CS1100 SPRING 2000 C 100000022 CS1100 SPRING 2000 B 100000021 CS1200 FALL 2000 C 100000022 CS1200 FALL 2000 B 100000021 CS2300 SPRING 2001 A 100000022 CS2300 FALL 2001 B 100000023 CS1100 SPRING 1999 B 100000024 CS1100 FALL 1999 A 100000023 CS1200 SPRING 2000 A 100000024 CS1200 FALL 2000 C 100000023 CS2300 SPRING 2001 A 100000024 CS2300 FALL 2001 B 100000025 CS1100 SPRING 2000 C 100000025 CS1200 FALL 2000 C 100000025 CS2300 SPRING 2001 B 100000025 CS4380 FALL 2001 A 100000025 CS4390 FALL 2001 A 100000026 CS1100 SPRING 1998 C 100000026 CS1200 FALL 1999 C 100000026 CS2300 SPRING 2000 A 100000010 CS1100 SPRING 2002 100000011 CS1100 SPRING 2002 100000012 CS1100 SPRING 2002 I 100000013 CS1100 SPRING 2002 100000014 CS1100 SPRING 2002 100000015 CS1200 SPRING 2002 C 100000016 CS1200 SPRING 2002 100000017 CS1200 SPRING 2002 100000018 CS2300 SPRING 2002 100000019 CS2300 SPRING 2002 A 100000020 CS2300 SPRING 2002 B 100000021 CS4020 SPRING 2002 100000022 CS4020 SPRING 2002 100000023 CS4380 SPRING 2002 100000024 CS4380 SPRING 2002 100000026 CS4020 SPRING 2001 B 100000026 CS6460 SPRING 2002 #MAX is the max allowed registration or enrollment #CNT is the actual enrolled or registered students #For time, we have MTWRF as the days of the week and time slot like 2PM or 10AM #The domain for class time is as follows: MR or TF at 8AM, 10AM, 12PM, 2PM # 8 values in all. Each class is for 2 hours total. TEACHING #------------------------------------------ CRSCODE NAME HRS TIME INSTRUCTOR CLSRM MAX CNT SEM YR PREREQ CS1100 CS-I 4 MR2PM 100000003 308 4 1 FALL 1997 CS1100 CS-I 4 MR2PM 100000003 308 4 2 SPRING 1998 CS1100 CS-I 4 MR2PM 100000003 308 4 2 SPRING 1999 CS1100 CS-I 4 MR2PM 100000003 308 4 1 FALL 1999 CS1100 CS-I 4 MR2PM 100000003 308 4 3 SPRING 2000 CS1100 CS-I 4 MR2PM 100000003 308 4 1 FALL 2000 CS1100 CS-I 4 MR2PM 100000003 308 4 1 SPRING 2001 CS1100 CS-I 4 MR2PM 100000003 308 4 1 FALL 2001 CS1200 CS-II 4 MR12PM 100000004 303 6 1 FALL 1998 CS1100 CS1200 CS-II 4 MR12PM 100000004 303 6 1 SPRING 1999 CS1100 CS1200 CS-II 4 MR12PM 100000004 303 6 1 FALL 1999 CS1100 CS1200 CS-II 4 MR12PM 100000004 303 6 2 SPRING 2000 CS1100 CS1200 CS-II 4 MR12PM 100000004 303 6 4 FALL 2000 CS1100 CS2300 DSA 4 TF10AM 100000005 303 5 1 SPRING 2000 CS1200 CS2300 DSA 4 TF10AM 100000005 303 5 3 SPRING 2001 CS1200 CS2300 DSA 4 TF10AM 100000005 303 5 2 FALL 2001 CS1200 CS4380 DBSYS 4 TF12PM 100000002 351 10 1 FALL 2001 CS2300 CS4390 DMINE 4 TF10AM 100000001 112 4 1 FALL 2001 CS2300 CS1100 CS-I 4 MR2PM 100000003 308 5 5 SPRING 2002 CS1200 CS-II 4 MR12PM 100000004 303 6 3 SPRING 2002 CS1100 CS2300 DSA 4 TF10AM 100000005 303 5 3 SPRING 2002 CS1200 CS4020 ALG 4 MR10AM 100000006 112 5 1 SPRING 2001 CS2300 CS4020 ALG 4 MR10AM 100000006 112 5 2 SPRING 2002 CS2300 CS4380 DBSYS 4 TF10AM 100000001 351 10 2 SPRING 2002 CS2300 CS6460 ADV-DB 3 MR2PM 100000002 101 4 1 SPRING 2002 CS4380,CS4020 CS1100 CS-I 4 MR8AM 100000008 332 5 0 FALL 2002 CS1200 CS-II 4 TF12PM 100000009 308 6 0 FALL 2002 CS1100 CS2300 DSA 4 MR2PM 100000007 303 5 0 FALL 2002 CS1200 CS4380 DBSYS 4 TF12PM 100000002 351 10 0 FALL 2002 CS2300 CS4390 DMINE 4 TF10AM 100000001 112 4 0 FALL 2002 CS2300,CS4020 CLASSROOM #------------------------------------------ CLSRM SEATS 101 5 112 5 303 6 308 6 332 5 351 10 COURSES #------------------------------------------ CRSCODE SEM YR TEXTBOOK CS1100 FALL 1997 Intro to Programming, Savitch CS1100 SPRING 1998 Intro to Programming, Savitch CS1100 SPRING 1999 Intro to Programming, Savitch CS1100 FALL 1999 Intro to Programming, Savitch CS1100 SPRING 2000 Intro to Programming, Savitch CS1100 FALL 2000 Intro to Programming, Savitch CS1100 SPRING 2001 Intro to Programming, Savitch CS1100 FALL 2001 Intro to Programming, Savitch CS1200 FALL 1998 Data Structure in C++, Budd CS1200 SPRING 1999 Data Structure in C++, Budd CS1200 FALL 1999 Data Structure in C++, Budd CS1200 SPRING 2000 Data Structure in C++, Budd CS1200 FALL 2000 Data Abstraction and Problem Solving With C++, Carrano and Pritchard CS2300 SPRING 2000 Data Structures and Algorithm Analysis in C++, Weiss CS2300 SPRING 2001 Data Structures and Algorithm Analysis in C++, Weiss CS2300 FALL 2001 Data Structures and Algorithm Analysis in C++, Weiss CS4380 FALL 2001 Databases, O'Neil CS4390 FALL 2001 Data Mining, Han and Kamber CS1100 SPRING 2002 Intro to Programming, Savitch CS1200 SPRING 2002 Data Abstraction and Problem Solving With C++, Carrano and Pritchard CS2300 SPRING 2002 Data Structures and Algorithm Analysis in C++, Weiss CS4020 SPRING 2001 Intro to Algorithms, Cormen, Leiserson and Rivest CS4020 SPRING 2002 Intro to Algorithms, Cormen, Leiserson and Rivest CS4380 SPRING 2002 Databases and Transaction Processing, Lewis, Bernstein and Kifer CS6460 SPRING 2002 Databases and Transaction Processing, Lewis, Bernstein and Kifer CS1100 FALL 2002 Problem Solving and Program Design, Hanly and koffman CS1200 FALL 2002 Data Structure in C++, Budd CS2300 FALL 2002 Algorithms in C++, Sedgewick CS4380 FALL 2002 Databases, O'Neil CS4390 FALL 2002 Data Mining, Han and Kamber COURSEINFO #------------------------------------------ CRSCODE WHENOFFERED DEPTID NAME CS1100 BOTH CSCI COMP SCI I CS1200 BOTH CSCI COMP SCI II CS2300 BOTH CSCI DATA STRUCT ALGO CS4020 SPRING CSCI COMP ALG CS4210 SPRING CSCI OPER SYS CS4380 BOTH CSCI DATABASES CS4390 FALL CSCI DATA MINING CS6460 SPRING CSCI ADV DBMS EE2010 BOTH ECSE ELEC CIR EE2060 BOTH ECSE DIGITAL ELEC PROFESSORS #------------------------------------------ ID NAME DEPTID 100000001 Zaki, Mohammed CSCI 100000002 Adali, Sibel CSCI 100000003 Moten, Rod CSCI 100000004 Kettnaker, Vera CSCI 100000005 Akella, Srinivasan CSCI 100000006 Musser, Dave CSCI 100000007 Freedman, Dan CSCI 100000008 Spooner, David CSCI 100000009 Stewart, Charles CSCI 100000031 Kalyanaraman, Shiv ECSE 100000032 Perlman, William ECSE 100000033 Abouzeid, Alhussein ECSE INPUT_COMMANDS #------------------------------------------ AUTHENTICATE 100000001 yjtthtye #this will succeed AUTHENTICATE 100000021 xkjysvnx #this will fail (why?) REGISTER CS4380 #this will fail (why?) GETENROLLED 100000010 #this will succeed, show required output GETENROLLED 100000001 #this will fail (why?) CLASSROSTER ENROLLED CS4380 #this will succeed SETGRADE 100000010 CS1100 SPRING A #this will fail (why?) SETGRADE 100000010 CS1100 SPRING A #this will fail (why?) SETGRADE 100000015 CS4380 SPRING A #this will fail (why?) SETGRADE 100000023 CS4380 SPRING A #this will succeed USERINFO DELETE 100000026 #this will succeed CLASSINFO ADD 303 10 #this will fail (why?) CLASSINFO DISPLAY 332 #this will succeed ENDSESSION #this will succeed AUTHENTICATE 100000023 nswhhsss #this will fail (why?) AUTHENTICATE 100000023 nswhhwsu #this will succeed COURSEINFO ADD CS4330 CrsName=PERL #this will fail (why?) OLAP "SELECT * FROM STUDENT" #this will fail (why?) GETGRADES 100000025 #this will fail (why?) GETGRADES #this will succeed GETENROLLED 100000023 #this will succeed ENDSEMESTER #this will fail (why?) ENDSESSION #this will succeed AUTHENTICATE 100000011 kutgrrxt # this will succeed REGISTER CS2300 #this will fail (why?) REGISTER CS1200 #this will succeed ENDSESSION #this will succeed AUTHENTICATE 100000015 pkntvrxd #this will succeed REGISTER CS2300 #this will succeed ENDSESSION #this will succeed AUTHENTICATE 100000011 kutgrrxt # this will succeed DEREGISTER CS1200 #this will succeed ENDSESSION #this will succeed #A different input file will be used for testing your code. Your job is #to make sure all failure/success conditions mentioned in the #requirements document are met.