COSC 3480 Projects & Homeworks Fall 2003PowerPoint PresentationCOSC 3480 Lab Projects ICOSC 3480 Lab Projects IIAnnouncementsCOSC 3480 Projects & HomeworksFall 2003Learn how todefine tablesLearn how to loadand create an Oracle databaseLearn how to define user viewsData WarehousingOLAPConceptualSchema DesignGenerate SQL Plus reportsLearn PL/SQLbasics PL/SQLCursorsPL/SQL FunctionsProcedures and PackagesPL/SQLTriggersDeveloper 2000 Datablock FormsDeveloper2000 reportsODL/OQLbasicsLearn how to writecomplex SQL QueriesData MiningMS SQL 2000Analysis ServerDecision TreesClusteringOracle8/9iRelationalDatabase DesignLab 2003 ActivitiesObject-Relational featuresSupport for XMLJava/C++ InterfacesElements of COSC 3480, Christoph F. EickCOSC 3480 Lab Projects IThere will be 6 lab projects; 5 will be programming projects, one will be a design project.The TU/TH Lab (Sessions 5:30-7:00p) in 200 PGHInstructor Aditya ToomulaThe lab sessions will be help in 200 PGH; that host 45 stand-alone computers that are connected to the internet (no floppy, no CD).Vision: Usually, there will be a short lecture and then students will be given a task that is similar to the tasks in the 6 lab projects and each student tries his best to solve the task on his lab computer. Moreover, sometimes the will be just QA-sessions; other activities include discussions of homework / exams, student presentations, makeup classes during the lab time; occasionally, there will be no lab at all. A lab schedule will be available on the web soon.Elements of COSC 3480, Christoph F. EickCOSC 3480 Lab Projects IILab projects can be performed by accessing the departmental Oracle server; accounts are currently created. It is also okay, if you install Oracle 8i, 9i, 8.17 on your own computer and perform the projects on your own computer.As I know the “short lecture-do_tasks_on_lab_computer” approach will be used the first time when teaching COSC 3480; therefore:There likely will be problems at the beginning; it is not 100% certain if what I /we have in mind will work. Your feedback is appreciated.We might adapt our teaching approach based on experiences in the first lab sessions.The lab sessions will hopefully start on Tu., September