Hide Notes 

Slide 1: University of Wisconsin-Whitewater Curriculum Proposal Form #3 New Course Effective Term: 2041 (Spring 2004) Cross-listing:       Subject Area - Course Number: MCS 314 (See Note #1 below) Course Title: (Limited to 65 characters) 25-Character Abbreviation: Sponsor(s): Department(s): College(s): Advanced Database Design and Administration Advanced Database Bob Horton, Bob Leitheiser and Bob Siemann Management Computer Systems (MCS) Interdisciplinary $ Consultation took place: Programs Affected: $ NA MCS major Yes (list departments and attach consultation sheet) Departments:       Is paperwork complete for those programs? (Use "Form 2" for Catalog & Academic Report updates) NA $ Yes MCS 214 $ will be at future meeting Prerequisites: Grade Basis: Course will be offered: College: Instructor: Conventional Letter Part of Load On Campus S/NC or Pass/Fail Above Load Off Campus - Location       Dept/Area(s): MCS $ $ Interdisciplinary Staff Note: If the course is dual-listed, instructor must be a member of Grad Faculty. Check if the Course is to Meet Any of the Following: Computer Requirement Diversity Writing Requirement General Education Option: Select one: Credit/Contact Hours: (per semester) Total lab hours: Number of credits: 0 3 Total lecture hours: Total contact hours: 48 48 Can course be taken more than once for credit? (Repeatability) $ No Yes If "Yes", answer the following questions:             No of credits in major: No of credits in degree:             No of times in major: No of times in degree: Revised 10/02 1 of 5
Slide 2: Proposal Information: (Procedures can be found at http://acadaff.uww.edu/Handbook/Procedures-Form3.htm) Course justification: Database technology is central to most modern information systems. A solid grounding in the concepts and practice of using this technology is, therefore, essential for future information systems professionals. In the past we have tried to cover the material in one course. Originally an upper level course (MCS 320) and then later a lower level course (MCS 210). At the urging of our Advisory Board, we are expanding coverage of the material over three new courses. Introductory material in a new required Computer Science course (CompSci 181). Coverage of the process of developing and using a database in a new MCS course (MCS 214). And finally, treatment of advanced database concepts and technologies in this proposed new course, (MCS 314) Advanced Database Design and Administration. These changes will assure that the MCS program continues to meet the needs of organizations for highly trained entry-level IS professionals. Relationship to program assessment objectives: The following MCS program objectives are at least partially addressed by this course: Subject matter: To provide students with • Technical, analytic, problem solving skills required for an initial, entry-level position. • Hands on experience with appropriate technology. • System analysis and design skills for continued growth beyond the initial position. Cognitive Development: To provide students with a/an • High level of adaptability to new technology and a commitment to continual learning. Students understand the need for innovation, creativity and change. Budgetary impact: no additional staffing is required – this course replaces an existing course in the MCS program and will be taught with existing faculty. New hardware and software will need to be acquired to support the course. MCS will look to its industrial partners to fund this acquisition. Course description: This course covers advanced topics in database analysis, design, access, integrity control, and implementation as well as a variety of emerging topics. The course is intended for students who already have a good understanding of database systems and relational database concepts. Students should have proficiency in using the SQL language. Course requisites: Prerequisite: MCS 214 If dual listed, list graduate level requirements for the following: 1. Content (e.g., What are additional presentation/project requirements?) 2. Intensity (e.g., How are the processes and standards of evaluation different for graduates and undergraduates? ) 3. Self-Directed (e.g., How are research expectations differ for graduates and undergraduates?) Revised 10/02 2 of 5
Slide 3: Course objectives and tentative course syllabus: Course Objectives: On completion of this course students will: • understand the differences in database applications and models, and know the advantages and disadvantages of different models, • be able to write advanced SQL queries against a relational database, • understand the processes involved in physical database design and be able to convert a logical design into an appropriate physical design, • be able to create and load a database using SQL and supporting tools, • understand the concept of relational integrity and know how to apply it, • understand the concept of database transactions and know how to define them, • understand the roles and responsibilities of database administration, • understand the issues involved with database backup and recovery and know how to do it with a relational database management system, • know the concepts of distributed databases and the operational and design issues involved in them, • understand issues of database security and procedures used to address them, • know a procedural SQL language and how to use it to define stored procedures and triggers, • be able to tune SQL queries to improve performance, • understand basic concepts behind data warehousing and data mining. Tentative Course Breakdown Week Topic 1 Overview of database technology Database applications: OLTP vs. OLAP 2 Database models: conceptual, logical and physical Logical database model alternatives 3 Data retrieval Advanced SQL SELECT queries 4 Physical Database Design 5 Database creation SQL Data Definition Language 6 Data loading, data updating, data scrubbing SQL Data Manipulation Language; data loader tools 7 Transaction management; Concurrency control SQL transaction management commands 8 Exam Database Administration 9 Database backup and recovery Backup and recovery tools 10 Distributed database concepts SQL replication and distributed queries 11 Database security SQL privilege assignment 12 Database stored procedures and triggers Procedural SQL 13 Query tuning 14 Data warehousing Star schemas 15 Data mining Multidimensional data structures Revised 10/02 3 of 5
Slide 4: Bibliography: (Key or essential references only. Normally the bibliography should be no more than one or two pages in length. Indicate current library holdings by placing an asterisk [*]) *Database modeling & design, 3rd ed./Teorey, Toby J. San Francisco : Morgan Kaufmann, c1999. *Database--principles, programming, performance / Patrick O'Neil, Elizabeth O'Neil. San Francisco : Morgan Kaufmann Publishers, c2001. *SQL Server 2000 : stored procedure programming / Dejan Sunderic, Tom Woodhead. Berkeley, Calif. : Osborne/McGraw-Hill, c2001. *Database systems : design, implementation, and management / Peter Rob, Carlos Coronel. Cambridge, MA : Course Technology, c2000. *Database tuning : principles, experiments, and troubleshooting techniques / Dennis Shasha, Philippe Bonnet. Amsterdam ; Boston : Morgan Kaufmann, c2003. *Databases on the Web : designing and programming for network access / Patricia Ju. New York, N.Y. : M&T Books, 1997. *Object-oriented modeling and design for database applications / Michael Blaha, William Premerlani. Upper Saddle River, N.J. : Prentice Hall, c1998. *Readings in database systems / edited by Michael Stonebraker, Joseph M. Hellerstein. San Francisco : Morgan Kaufmann, 1998. *Advanced database systems / Carlo Zaniolo ... [et al.] San Francisco, Calif. : Morgan Kaufmann Publishers, c1997. *Building, using, and managing the data warehouse / Ramon C. Barquin, Herbert A. Edelstein. Upper Saddle River, N.J. : Prentice Hall PTR, c1997. *Data stores, data warehousing, and the Zachman Framework : managing enterprise knowledge / W.H. Inmon, John A. Zachman, Jonathan G. Geiger. New York : McGraw-Hill, c1997. *Data warehouse : from architecture to implementation / Barry Devlin. Reading, Mass : Addison-Wesley, c1997. *Data warehouse : practical advice from the experts / Joyce Bischoff and Ted Alexander [with] Sid Adelman ... [et al.] ; foreword by John A. Zachman. Upper Saddle River, N.J. : Prentice Hall, c1997. Database system concepts / Silberschatz, Korth, Sydarshan. New York : McGraw-Hill, c2002. Fundamentals of database systems / Ramez Elmarsri, Navathe. Reading, Mass : Addison-Wesley, c2000. Object-oriented multi-database systems: A solution for advanced applications / Omran Bukhres and Ahmed Elmagarmid (eds.) Upper Saddle River, N.J. : Prentice Hall, c1996. Modern Database Systems: The Object Model, Interoperability, and Beyond / Won Kim (ed.). Reading, Mass : Addison-Wesley, c1995. Notes: 1. Contact the Registrar's Office (x1570) for available course numbers. A list of subject areas can be found at http://acadaff.uww.edu/Handbook/SubjectAreas.html 2. The 15 and 25 character abbreviations may be edited for consistency and clarity. 3. Please submit electronically when approved at the college level - signature sheet to follow in hard copy. Revised 10/02 4 of 5
Slide 5: Revised 10/02 5 of 5