| SYLLABUS | | FALL, 2009 | BSAD
144A | Data Base Development and Administration | INSTRUCTOR(s):
| COURSE INFO:
| MEETS: | MW 9:30-10:45 | | LOCATION: | 002 Kalkin |  |
Pre-requisites:
Prereq: BSAD 141;
BSAD, CSIS, EMGT majors or BSAD minors only;
Minimum Junior standing;
Students are req'd to bring laptop w/BSAD software to all
classes;
Required course specific fee of $20;
Degree students only,
CE students should register for BSAD 144 Z1.
Goals & Objectives: Goals: To develop the skills necessary to analyze, design, and implement database applications in a business environment.Objectives:Develop a thorough understanding of database analysis and design theory/methods/techniques based on the relational model.Improve your conceptual database modeling skills with the Extended Entity Relationship model and Crows Foot notation. Increase your knowledge of industry standard ANSI SQL92 for both data definition and data manipulation tasks. Gain exposure to an enterprise level database management system (Microsoft SQL Server 2008). Develop an understanding of managerial issues in developing and administering a database application. See current online version at: http://stampy.uvm.edu/courses/144/Index.htm Course Content: This course will introduce the concepts necessary to understand the relational database model. In addition, an approach for analyzing and designing databases will be presented. This methodology will utilize entity relationship diagrams, data base design practices, and normalization to develop a logical database model that is then implemented in a particular data base management (DBMS) product. We will examine the particular implementations of ANSI SQL 92 found in Microsofts enterprise DBMS product: SQL Server 2008. While the theoretical models and methodologies presented in the course for database analysis and design are applicable to a wide variety of environments, we will examine and develop database applications typically found in a business environment. See current online syllabus at: http://stampy.uvm.edu/courses/144/Index.htm Books & Materials Required Text(s):Required Textbooks:1. Database Processing: Fundamentals, Design, & Implementation, 11th edition, by David Kroenke & David Auer, 2010, ISBN 10: 0-13-607868-0, Publisher: Pearson-Prentice-Hall Inc., available at the UVM Bookstore. Be sure you acquire the new 11th edition of this textbook. Required Software:Access 2007 Activity Logger client software will be installed in class on 9/1. Microsoft SQL Server 2008 (You will have to download Express Advanced version directly from the Microsoft site as a part of a homework assignment). Software Installation Requirements: Supported Operating Systems: Windows Server 2003 Service Pack 2; Windows Server 2008; Windows Vista; Windows Vista Service Pack 1; Windows XP Service Pack 2; Windows XP Service Pack 3 Physical Limitations: 32-Bit Systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended. Only a single processor is supported.) 64-Bit systems: Computer with Intel or compatible 1.4 GHz or higher processor (2 GHz or faster is recommended. Only a single processor is supported.) Minimum of 512 MB of RAM (1 GB or more is recommended) 1.9GB of free hard disk space Download size: 546.5 MB Microsoft Outlook 2007 or Outlook Web Access ( http://bsadmail.uvm.edu/exchange/ ) See current online version at: http://stampy.uvm.edu/courses/144/Index.htm
Grading:
Grading Comments:
Homework Assignments: A series of approximately 20 homework assignments (HW01, HW02, ...) based on the Kroenke textbook (Database Processing) and other on-line documents will be completed electronically using Word but submitted in hard copy before the start of class on the due date indicated in the assignments schedule. Each of these assignments will be done in individually. Penalties for violating this UVM policy are severe. Each homework will be graded by the TA and returned as soon as possible. However, your immediate understanding of the material in the homework will be measured by an in-class quiz. Class discussion of the homework material will also provide general feedback. First Page Format: The first page of each assignment needs to be clearly labeled with the complete first, last name, Course Number (BSAD 144) and course section (A) of the student and with HWXX where XX is the homework number e.g. 01, 02, etc. Unless specifically requested in the homework directions, No email submissions please!!!! NOTE: Past experience suggests that each student needs to understand the homework material in order to do well on the daily quizzes and exams. This means you must read all of the material carefully and attempt all of the homework components.Homework Grading Policy: A. Late Policy (No Late Homework can be Accepted): As an incentive for all of us to keep up with this fast paced course, the tutorial and homework assignments must be turned in by the date and time specified on the tentative class schedule or they will not be corrected and a score of zero will be recorded. If you have not completed the whole homework by the deadline, place a message in the body of your email providing a description of the homework that you did complete before the deadline and then attach any files you used. B. Drops: To allow for computer failures, illness, sports team commitments, funerals, family & friend obligations, religious holidays, computer failures, unexpected events, etc. your final homework average will be calculated after dropping your lowest two (2) scores.In-Class Quizzes: In order to provide an incentive for students to carefully read the assigned materials, there will be a short (5-10 min), unannounced quiz during most class sessions. These quizzes will typically be true or false, multiple choice, or occasionally short answer. Typically, each quiz will be based on the homework and reading material that was assigned for that class. You will need to bring a computer to each class, so that you can take in-class quizzes and exams. This computer must be able to run the Exam View Pro Test Player software. To access this software, you must sign on the BSAD network, map a free drive letter to \\Marge\EVP folder (you only need to do this step once, if you check the box to reconnect at login), launch the Exam View Pro Test Player software from the \\Marge\EVP folder by double clicking the evplay.exe file, enter your name and UVM ID number (you must include the dashes- e.g. 123-45-6789), and then use the test player software to locate (browse) and complete the appropriate quiz. Students arriving more than 5 minutes after the quiz start time will NOT be allowed to take the quiz and will receive a zero for the day's quiz score. Any student absent from class will also receive a zero for the day's quiz. If necessary, each quiz will be curved up to a mean 75% correct based on the scores of all students taking the quiz.NOTE: To allow for computer failure, illness, team commitments, funerals, family & friend obligations, religious holidays, unexpected events, etc., your final in-class quiz average will be calculated after dropping your two (2) lowest curved quiz scores. Your final in-class quiz average will be worth 15% of your final course grade. There are no makeup or special-circumstances in-class quizzes, so please don't ask. See current online version at: http://stampy.uvm.edu/courses/144/Index.htm
Exam Comments:
There will be three exams to help measure your learning of the class material. See the tentative assignments and class schedule page for locations, dates and times. NOTE: The two midterm examination will be held on two evenings in the same week. Please plan ahead because there will be no makeup examination times so please check your schedules before taking the course this semester.Exam 1: Data Modeling, DB Design, Normalization, etc. This part of the exam also will be closed book and closed notes but you may bring a copy of Kraushaar's Normalization algorithm. See the Midterm Exam Review page for details. The format will include a mixture of multiple choice/ true false/ short answer, essay, and problems/cases. The general topic areas to be examined will be presented in the review class prior to the exam. This material includes those topics assigned for reading and/or discussed/presented in class. See the "assignments & class schedule" page for class agendas & notes, PowerPoint presentations, and hot links to the assignments.Exam 2: SQL DML Exam This exam will be a timed, on-line computer examination that will cover SQL ANSI-92. The general topic areas to be examined will be listed in the review class prior to the exam. The multiple choice section and the problem solving section will require you to use a laptop computer with BSAD network connection (see midterm exam review page for details). It is closed notes and closed book. No reference sheets are allowed.Exam 3: Comprehensive Final Exam The final exam will be comprehensive and scheduled according to the UVM final exam schedule. Similar to midterm exams, the final exam will be composed of both on-line and traditional paper-based parts.WARNINGS:All exams are timed tests so any strategy that doesn't allow you time to attempt an answer to all questions is probably not optimal. Exam scores will be curved but the strategy of doing well on a few parts of the exam and not answering other parts of the exam is probably unwise. See current online version at: http://stampy.uvm.edu/courses/144/Index.htm
Academic Honesty
The principal objective of the policy
on academic honesty is to promote an intellectual
climate and support the academic integrity of the University of Vermont. Academic
dishonesty or an offense against academic honesty includes acts that may subvert or
compromise the integrity of the educational process. Such acts are serious offenses that
insult the integrity of the entire academic community.
Offenses against academic honesty are any acts that would have the effect of unfairly
promoting or enhancing one's academic standing within the entire community of learners
which includes, but is not limited to, the faculty and students of the University of
Vermont. Academic dishonesty includes knowingly permitting or assisting any person in
the committing of an act of academic dishonesty.
The policy distinguishes between minor and major offenses. Offenses purely technical in
nature or in which the instructor does not perceive intent to achieve advantage are
deemed minor and handled by the instructor. Major offenses are those in which intent to
achieve academic advantages is perceived. A full statement of the policy can be found in
the Cat's Tale. Each student is responsible for knowing and observing this policy.
Classroom Code of Conduct
Faculty and students will at all times conduct themselves in a manner that serves to
maintain, promote, and enhance the high quality academic environment befitting the University
of Vermont. To this end, it is expected that all members of the learning community will adhere
to the following guidelines:
- Faculty and students will attend all regularly scheduled classes, except for those
occasions warranting an excused absence under the policy detailed in the catalogue (e.g.,
religious, athletic, medical).
- Students and faculty will arrive prepared for class and on time, and they will
remain in class until the class is dismissed.
- Faculty and students will treat all members of the learning community with respect.
Toward this end, they will promote academic discourse and the free exchange of ideas by
listening with civil attention to the comments made by all individuals.
- Students and faculty will maintain an appropriate academic climate by refraining
from all actions which disrupt the learning environment (e.g., making noise, ostentatiously
not paying attention, and leaving and reentering the classroom inappropriately).
- Food and drink are not allowed in classrooms.
Instructors will inform students of any special/additional expectations.
|