ISC 361 Database for Information Systems

1. ISC 361 Database for Information Systems Jeffrey P. Landry, Ph.D.

2. Course Description • The course builds on relational database and programming concepts by exploring the analysis, design, and implementation of more complex database systems. Topics include advanced data modeling, advanced query design, and application development in a database programming environment. ISC-361-Fall 2005

3. Course Objectives Upon completion of the course, the student will be able to … • Demonstrate trustworthiness in all matters relating to the course. • Develop and diagram data models as ER diagrams depicting recursive and supertype/subtype relationships, based on given problem scenarios. • Design and implement databases with advanced design characteristics to implement a document of transaction based on requirements stories. • Using the DDL and DML of the Structured Query Language and MS SQL-Server, write advanced queries. • Use the SELECT statement to join multiple tables, using aliasing, aggregation, and correlated and uncorrelated subqueries. • Write DML queries to insert, update, and delete rows from tables. • Write DDL commands, including scripts that create tables, stored procedures, triggers, and views. • List three ways that a nested query (subquery) can be constructed. • Differentiate between stored procedures and triggers, selecting the correct way to solve a given database programming problem. • Use triggers to implement: audit files, lazy deletes, and business and data rules. • Develop a row-editor application that follows good design principles and that runs in two environments: Windows Form and ASP Form. ISC-361-Fall 2005

4. Teaching Philosophy • I will strive to be learner-centered • Your success is important to me • What is “success” in this course? • syllabus contains some obvious clues • What about your concept of success? ISC-361-Fall 2005

5. Grading Final grade based on percentage of total points possible, using this scale: • A=90-100% of possible points • B=80-89% of points possible • C=70-79% of points possible • D=60-69% of points possible • F<=59% of points possible ISC-361-Fall 2005

6. Text books • Required: • Bradley, J. C., and Millspaugh, A. C., Advanced Programming Using Visual Basic.NET, Second Edition, ISBN: 0-07-251239-3, 2003, McGraw-Hill, New York, NY. (we will use this one first) • Rob, P., and Coronel, C., Database Systems Design, Implementation & Management, Fifth Edition, ISBN: 0-619-21323-X, 2004, Course Technology – Thompson Learning, Boston, MA. (This is also the current book used in CIS 324). ISC-361-Fall 2005

7. Software Tools • Microsoft Tools • Visual Basic .NET Professional 2003 • SQL-Server 2000 • ACM VB.Net Install CDs for $15 • Downloadable from MSDNAA: http://msdn04.e-academy.com/usouthal_cis/ ISC-361-Fall 2005

8. E-mail • Use your university e-mail account, available at:  http://jaguar1.usouthal.edu or on PAWS • Make sure CIS has your up-to-date account: http://www.cis.usouthal.edu/email ISC-361-Fall 2005

9. Office hour policy • Although you should use this free learning resource, I may actually have to require you to attend! ISC-361-Fall 2005

10. Share Drive • http://www.cis.usouthal.edu/share/ • Go to landry | ISC-361 ISC-361-Fall 2005

11. Computer Ownership Policy • This course is affected by the School of CIS computer ownership policy (http://www.cis.usouthal.edu/~laptop/) • Bring your laptop to class if we have wet ports, or if Visual Studio.NET not installed • You may bring laptop to out-of-class meetings ISC-361-Fall 2005

12. Exams • 1-3 exams, including final exam • Variety of question formats ISC-361-Fall 2005

13. Cheating • Academic misconduct is serious • Your work must be your own • Penalty may be as severe as ‘F’ for the course • Two Level 1 offenses may result in dismissal from the program ISC-361-Fall 2005

14. Other details • Follow lab policies • Attendance is important • Changes to this syllabus • Late work – 10% per day • Disabilities ISC-361-Fall 2005