Transcript Slide 1

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.
4.
5.
6.
7.
8.
9.
10.
11.
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
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: 0619-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

ACM VB.Net Install CDs for $15
Downloadable from MSDNAA:

• Visual Basic .NET Professional 2003
• SQL-Server 2000
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