ISC 361 Database for Information Systems

Jeffrey P. Landry, Ph.D.

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 2

Course Objectives

Upon completion of the course, the student will be able to … 1.

2.

3.

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.

4.

5.

6.

7.

8.

9.

10.

11.

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 3

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 4

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 5

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 6

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 7

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 8



Office hour policy

Although you should use this free learning resource, I may actually have to

require

you to attend!

ISC-361-Fall 2005 9

Share Drive

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

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 11

Exams

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

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 13

Other details

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