University at Albany, State University of New York



ITM520 Home



ITM520 Database Management  - Syllabus Spring 2010

 

       

Lecturer: Dr. Guy J. Cortesi [email protected] Office Hours: by appointment

Course Description:  ITM 520 examines various facets of database systems. These will include the role of data as a corporate resource, data models (relational model in particular), elements of database design and implementation. The final discussion will be focused to the position of a database management system within the firm’s network and information system. Experience with Database Management Systems (DBMS) will be achieved via hands on use of Microsoft's database product ACCESS and elements of SQL.

Prerequisite: Working knowledge of MS Office.

Course Objectives:

By the end of the course you should be able to:
•    Develop and demonstrate your technical skills through developing Access objects and macros, and end-user level of Access
•    Extend your analytic skills in the areas of data and decision making
•    Practice reflective thinking through analysis of various requirements in business oriented problems
•    Be able to easier participate in discourse in your business environment and in other courses

Textbook

1. Kroenke: Database Concepts, Prentice Hall, 2009

The textbook is required and will be used in class.  You must have this textboard no later than the second class.  It is available at the MaryJane Bookstore.

E-mail 

It is important for all course students to have an Internet-based e-mail account for this class. Students may use a university account or their own personal account.

Course Website and Blackboard

<>This course has its own web site, containing assignments and readings. Please consult this site for the latest information regarding this course. It is located on the Internet at: <https://www.albany.edu/~gc227838/itm520>.  The course also uses Blackboard.  Lecture notes and data files will be posted there.  Assignments will also be posted and must be submitted to Blackboard.
<>
Assessment

ITM 520 is a graded course. Your grade is based on four assignments (max 20 points each) and one test (max 20 points).

Total possible points = 100. 

Grading Scale

A: 100-95 points A-: 94-90 points

B+: 89-87 points B: 84-86 points B-: 80-83 points

C+: 79-76 points C: 75-70 points

D: 69-60 points

F: 59 points and below

Participation

Each student is expected to participate in every class. Positive participation means speaking so everyone can hear; asking appropriate questions; replying to questions, contributing ideas and participating in discussion without dominating it; and helping others.  Positive participation creates a supportive learning environment in which other students feel comfortable asking questions and everyone contributes to the discussion. 

Positive participation requires that students come prepared for class.  This means distilling the terminology and major concepts of assigned readings; having points of personal interest in mind for discussion; having questions in mind for ideas that are unclear; knowing what the day’s topics will be and what assignments are due; and bringing appropriate texts, materials, and tools for the day’s class. 

Written and Verbal Expression

Being able to communicate effectively with all sorts of people is necessary for  sustained success in managing information systems.   Students are expected to use proper spelling and grammar and to adapt their speaking and writing to their audience.  Those who habitually use words, phrases, abbreviations or acronyms that may be unfamiliar to the audience without proactively explaining them in an understandable way, will have points deducted in written assignments and in class participation as applicable.

Class Attendance/Lateness

There will be a 15 minute break during each class. Students are expected to attend every scheduled class.  Students are responsible for all assignments, handouts, and work done in classes that are missed.

Academic Honesty

Students are expected to understand and abide by the “Standards of Academy Integrity” in the Graduate Bulletin at:

https://www.albany.edu/grad/requirements_general_admissions.html#standards_integrity

Class Schedule

The class meets on Wednesdays from 5:45-8:35PM in BA222.  The schedule of classes as well as the other information in this syllabus is subject to change.  The latest, authoritative version is the current one posted this website. All necessary changes will be announced in class.  Test date will not be changed.

Date/Class#

Activities

Readings / Assignments


2/24 (1)

  • Introduction to Database Environment
  • Building databases: Relational model and Normalization


Get Text book Chapter 1, 2, Do Assignment 1


3/3 (2)

  • Structured Query Language


Read Chapters 3 Do Assignment 2
Assignment 1 Due (submit to Blackboard)


3/10 (3)
      <>
  • Data Modeling

Read Chapters 4 Do Assignment 3
Assignment 2 Due (submit to Blackboard)



3/17 (4)

  • Database Design


Read Chapters 5, Do Assignment 4
Assignment 3 Due (submit to Blackboard)


3/24 (5)

  • Summary / Test


Assignment 4 Due (submit to Blackboard)

Assignments

There are four assignments for the course.
  • Assignments will be identified in Blackboard.
  • Assignments results must be uploaded to Blackboard for grading.

Updated 2/28/2010  gjc