ISC361Database for Information Systems

Fall2008

Section 101:11:00 am - 12:15 pm TR FCE 0019; CRN: 11762

Prerequisites:Professional Component, CIS 324

Credits:3

Instructor:Harold Pardue, Ph. D.

Phone:461-1600

Office:FCE-9

E-mail:

Office Hours:Tuesday and Thursday 2:30 – 4:30; Wednesday 12:00-2:00 pm,

by appointment, and when available during the day

Course description (USA Bulletin 2007-2008):

Analysis, design, and implementation of more complex database systems. Prerequisite: Professional Component, CIS 324.

Detailed 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. Prerequisite: Professional Component, CIS 324.

Course objectives:

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

  1. Demonstrate trustworthiness in all matters relating to the course.
  2. Develop and diagram data models as ER diagrams depicting recursive and supertype/subtype relationships, based on given problem scenarios.
  3. Design and implement databases with advanced design characteristicsto implement a document of transaction based on requirements stories.
  4. Using the DDL and DML of the Structured Query Language and MS SQL-Server, write advanced queries.
  5. Use the SELECT statement to join multiple tables, using aliasing, aggregation, and correlated and uncorrelated subqueries.
  6. Write DML queries to insert, update, and delete rows from tables.
  7. Write DDL commands, including scripts that create tables, stored procedures, triggers, and views.
  8. Differentiate between stored procedures and triggers, selecting the correct way to solve a given database programming problem.
  9. Use triggers to implement: audit files, lazy deletes, and business and data rules.
  10. Develop a web-based, distributed applicationusing an n-tier architecture and current technologies such as AJAX and XML.

ISC 361 - Fa2008

Important dates:

Classes begin / August 18 / Monday
100% refund period begins on dropped courses and complete
withdrawals (including housing) / August 18 / Monday
Late Registration and Drop/Add (ends at 5:59 p.m. on August 20) / August 18-20 / Monday-Wednesday
Last Day to Add a Course (5:59 p.m.)
Last Day to Change to Audit (5:59 p.m.) / August 20 / Wednesday
No Refunds after this date / August 31 / Sunday
Labor Day Holiday for students, faculty, staff and administration / September 1 / Monday
Spring Semester 2009 advising for continuing and readmitted students / September 29-October 10 / Monday-Friday
Last day for faculty reports on incomplete grades (undergraduate and graduate) / October 10 / Friday
Last day to drop from a course (4:59 p.m.)
Last day to withdraw from University (4:59 p.m.) / October 24 / Friday
Thanksgiving Holidays for Students (Includes weekend classes) / November 26-30 / Wednesday - Sunday
Thanksgiving Holidays begins at noon on Wednesday for faculty, staff, and administration / November 26-28 / Wednesday – Friday
Last Day of Classes / December 2 / Tuesday
Final Examinations / December 4-9 / Thursday-Tuesday
Commencement / December 6 / Saturday
ISC 361 Final Exam / December 4 / Thursday 10:30am
Final grade web entry due by 10:00a.m. / December 12 / Friday

Texts:

Bradley, J. C., and Millspaugh, A. C., Advanced Programming Using Visual Basic 2005, ISBN: 0073517178, McGraw-Hill, New York, NY.

And other materials I will provide.

Grading:

Exam 1...... 20%

Exam 2...... 20%

Final Exam ...... 30%

Quizzes...... 10%

Course Project...... 20%

Grading Scale

A=90- 100

B=80-89

C=70-79

D=60-69 F<=59

Technology used:

We will make use of Microsoft technologies, available for free:

  • Visual Basic .NET Professional 2005
  • SQL-Server 2005

The School of Computer and Information Sciences is a member of the Microsoft Developer Network Academic Alliance (MSDNAA). Part of the benefits of our membership is that our students can get access to a great deal of software from Microsoft for no charge. In order to be eligible to receive this software, you need to register. Go to the School of CIS web site at and follow the “Links for students”link to “Software” at the bottom of the subsequent page. In order for you to receive the software that is available in the program, you must be a student registered in at least one course in the School of CIS. Your information will be verified before you are given access to the software.

Office hour policy:

Office hours can play a key role in the learning process for this class. I will see anyone during office hours, whether you are doing extremely well, or if you are totally lost. Don't let the fact that you are lost or falling behind discourage you from seeking help. If you cannot find me, ask for me in the CIS Office (FCW-20). You are welcome to seek me outside of posted office hours, or call me on my cell phone.

E-mail:

E-mail is an excellent way to reach me. The School of CIS requires that you have an e-mail account and that you check your e-mail frequently for important announcements. Please visit the web page at to make sure we have a correct e-mail address for you. You are strongly encouraged to activate your university e-mail account.This e-mail account will be used by university faculty and administrators to send official university correspondence such as financial aid notifications, grade information, university bills, course information, etc. Students may activate their e-mail account at the following address/URL: or from the opening page of PAWS.

Computer ownership policy:

This course is affected by the School of CIS computer ownership policy ( I may require you to bring your laptop computer to class whenever we have an opportunity to work on a homework or in-class assignment, and when we are not meeting in a laboratory that has computers. You may also be required to bring your laptop for appointments outside of scheduled class time.

Attendance:

Regular attendance is expected. Cases of illness or emergencies which make it impossible to attend class should be reported to me as soon as possible. It is your responsibility to make up all missed work. The pace of this class will make attendance especially important.

Late work:

Late work is subject to severe penalties. Typically, if an assignment is turned in on the due date but after the due time, I will deduct ten percent of total points possible. An assignment turned in on the day after the due date will be deducted 20%, and so on. You are best advised to manage your time wisely so that you can turn in assignments on time. Get an early start and inform the instructor of any situations that may cause you to miss an assignment due date. Even if your work is incomplete and late, it is best to submit it, because the highest grade you can earn for work not turned in is a zero.

Course project:

The requirements for the course project are detailed in a separate document.

Presentation:

As communication is an important IS skill, you are encouraged to speak up in class and will be required to do so.

Each team/individual will make a course presentation at the end of the semester.

Exams:

There will be at least onetest and a final exam. These exams may contain questions of an objective nature (multiple choice, true/false, fill in the blank, or matching), short answer questions, essay questions, and problems. You may be asked to write code or draw part of a graphical user interface as part of an exam question. You may be asked to draw a database diagram or write queries. You will be responsible for all material covered in class and in readings. No make up exams will be given except for a valid, documented reason. Notice must be given prior to the exam except in case of emergency.

Cheating:

The School of Computer and Information Sciences Policy on cheating is:

Unless otherwise stated by your instructor, all work submitted for grading must be your own work. This means that the work you submit for grading must be designed and implemented by one and only one person, and that person must be you. Any deviation from this policy may result in a failing grade for the course for all parties involved. This policy applies to examinations, programming assignments, quizzes, and homework assignments. Multiple incidents of academic misconduct are grounds for dismissal from the Computer and Information Sciences program.

Disability:

In accordance with the Americans with Disabilities Act, students with bona fide disabilities will be afforded reasonable accommodation. If you have a disability and need a reasonable accommodation, you should contact the instructor early in the semester. You are encouraged to register with the Office of Special Student Services, located in the Student Center, Room 270, phone 460-7212. The Office of Special Student Services will certify a disability and advise faculty members of reasonable accommodations.

Changes to course requirements:

Since all classes do not progress at the same rate, the instructor may wish to modify the above requirements or their timing as circumstances dictate. For example, the instructor may wish to change the number and frequency of exams, or the number and sequence of assignments. However, the students must be given adequate notification. Moreover, there may be non-typical classes for which these requirements are not strictly applicable in each instance and may need modification. If such modification is needed, it must be in writing and conform to the spirit of this policy statement.