Database Design and Applications for Business
Professor:Dr. Margaret R. Garnsey
Office:Siena Hall 433
Office Hours:Office Hours:Mon., Wed., and Fri. 8:15AM – 9:15AM and 10:30PM – 11:25PM or by appointment
Text:Database Processing, 11th edition by, David Kroenke & David Auer,Prentice Hall, 2010.
Note:The course is up on Blackboard (https://Blackboard.siena.edu/Blackboard/).The syllabus and tentative schedule are on the site at this time, and you are expected to check Blackboard and your email frequently for announcements, etc.
The concept of academic integrity lies at the very heart of any college. This is particularly true of Siena with its strong Franciscan tradition and its dedication to fostering sound moral growth. In such an environment, academic dishonesty cannot be tolerated. Students who commit such acts expose themselves to punishment as severe as dishonorable dismissal from the college.
Academic dishonesty can take several forms, including, but not limited to, cheating [dishonesty in a test situation], plagiarism [dishonesty in the presentation of materials in a paper or report], and computer abuse. All work you submit for this course must be entirely your own. Although students are encouraged to study together, you are required to produce your own solutions to all work you submit (including, obviously, exams). In any situation in which a student is unsure what constitutes academic dishonesty, it is the student’s responsibility to raise the question with his or her instructor. It is also the student’s responsibility to be familiar with the student guidelines on academic dishonesty, “Academic Integrity and the Siena Student” and to read the Computer Science department’s Academic Integrity web page, http://www.cs.siena.edu/Academic_Programs/Academic_Integrity.php
The student is expected to be comfortable with working on a PC and to be generally familiar with the Windows office suite of products.
The student should be able to:
Communicate comfortably and intelligently with systems professionals.
To understand and be able to use an Entity – Relationship diagram to conceptually describe a database.
To be able to effectively translate an E-R diagram into a relational schema
Develop specifications for business systems using structured systems analysis and design.
Analyze a relational schema and normalize it if necessary.
Use query languages to produce desired results.
Understand some of the common applications of database systems, including various ways of making the data available to users.
Understand enough of how a DBMS works to make informed decisions regarding the various tradeoffs available in database design
Lectures on each topic incorporating illustrations and examples to enhance understanding.
Class exercises and participation.
Discussion of assignments and projects.
If I need to get a message to you or make any announcements outside of class I will use e-mail and/or Blackboard, so you are expected to monitor these frequently.
Students are expected to attend all classes. The teacher reserves the option that any student missing more than 2 classes will have their final grade dropped by a full letter grade and any student missing more than 3 classes will fail the course.
Students are expected to read the assigned chapters prior to class. Students must complete a chapter exercise prior to the first class to be taught on a chapter. This class format requires you to be prepared for each class. This is very important, and your classmates and I will be counting on you to have read the assignments!
Power point slides used in the class are available on Blackboard. Students are strongly encouraged to print out the slides prior to the classes they pertain to.
Homework: There will be 6 homework assignments, roughly one every two weeks. The lowest of your homework grades will be ignored. Some of the assignments will be written and some will also involve using the computer. Nothing late will be accepted for grading unless there is an illness or situation that can be documented. Written excuses (e.g., a note from a doctor) are required
Projects: These are longer-term database design and implementation activities in which you will have the opportunity to use a wide range of skills to take a database through its various phases (conceptual design, relational implementation, queries, etc.). Nothing late will be accepted for grading unless there is an illness or situation that can be documented. Written excuses (e.g., a note from a doctor) are required.
Exams: All exams will be closed-book and cumulative. The first two will be held during a scheduled class period.
Course Accounts: These will be given to you later in the semester for the use of the Access relational DBMS and possibly other uses.
The course grade will be a weighted average based upon the following percentage weighting factors:
Beg of Chap Exercises
90% or above
80 to 89
70 to 79
60 to 69
There are no curves or extra credit in this course. Plus and minus grades will be given to those students who either just missed the next grade or who were very close to dropping down to the next letter grade.
TENTATIVE SCHEDULE OF TOPICS
9/6 (Wed, Fri only)
Introduction, Introduction to SQL
Introduction to SQL
Intro. to SQL, Data Modeling with the E-R model
Data Modeling with the E-R model
Transforming Data Models into DB Designs
10/11 (Mon, Wed only)
Review for Exam 1,EXAM 1
The Relational Model and Normalization
Database Design using Normalization
SQL for Database Construction and Application Processing (Additional SQL statements UNION, EXISTS)
DB Processing for Business Intelligence Systems
DB Processing for Business Intelligence Systems
11/22 (Mon only)
Multiuser Database Processing
Multiuser Database Processing, Database Processing with XML (if time permits)