Personal tools
You are here: Home Academics New-Syllabi Fall 2014 Syllabi 44043 Brandyberry

44043 Brandyberry

M&IS 44043 - Database Management Systems

Section 001 SYLLABUS Fall 2014

COURSE INFORMATION:

Name of Course:

Database Management Systems

Term:

Fall 2014

Room:

BSA 215

Meeting Time:

2:15 PM - 3:30 PM TuTh

Web Sites:

Course: http://learn.kent.edu

Publisher: http://wps.prenhall.com/bp_kroenke_database_13/

Prerequisites:

Minimum cumulative 2.500 GPA; and 24053 with a minimum C (2.000) grade; and MIS 24065.

Course Description:

The design, implementation and management of database management systems within organizations are studied from an applied perspective.

INSTRUCTOR INFORMATION:

Name of Instructor:

Dr. Alan Brandyberry

Office Address:

BSA A425

Telephone:

(330) 672-1146 (email strongly preferred)

Office Hours:

Mondays 10:45AM-Noon, 1:30PM-3:15PM

Tuesdays 10:00AM-11:00AM

Thursdays 1:00PM-2:00PM

E-mail:

abrandyb@kent.edu (preferred contact method)

COURSE MATERIALS:

Required Text and Equipment:

David M. Kroenke; David J. Auer, Database Processing: Fundamentals, Design and Implementation, 13th Edition, Prentice Hall, 2013 (ISBN-13: 978-0-13-305835-2)

Note for those opting for an electronic version of the book (if available): The required lockdown browser will not allow you to have your text open while taking quizzes (and they are open book). The work around is to use two computers – one for the quiz and one for the text. If you have only one computer available, you are advised to not opt for the electronic version.

Access to a scanner is necessary to submit some materials electronically (this is optional for sections with traditional classroom meetings, assignments may also be submitted on paper in class – electronic submission is required for web-based sections).

The university labs generally have scanners available and many/most of you probably already have one at home. If you choose to purchase one, there are some low cost scanners available. I endorse no website or products and include the following links as examples only. Read the reviews and make your own decision (I have not used these particular scanners).

 http://www.rakuten.com/prod/visioneer-onetouch-9420-usb-flatbed-scanner-usb-visioneer-onetouch/10403646.html

 http://www.rakuten.com/prod/xerox-7600i-flatbed-scanner-48-bit-color-8-bit-grayscale-usb/227825538.html

 http://www.amazon.com/Canon-CanoScan-4507B002-LiDE110-Scanner/dp/B003VQR1UC/ref=sr_1_1?ie=UTF8&qid=1370295830&sr=8-1&keywords=flatbed+scanner

Finally, a digital camera is also suggested as an emergency backup. If something is due that you need to submit electronically and your scanner malfunctions or you cannot get to class you may take a digital picture of your submission that is clear enough to at least demonstrate it was completed in time and submit it instead. A clearer, gradable document (original paper or properly scanned) would then be submitted as soon as possible and must look identical to the photos – just more legible.

COURSE OBJECTIVES, REQUIREMENTS & EVALUATION:

Learning Outcomes:

Upon completion of this course, students will:

1. Understand the role of databases in business and other environments.

2. Be acquainted with various concepts associated with designing, implementing, and using databases.

3. Understand the use of relevant analysis and design tools (e.g. entity relationship diagrams).

4. Obtain a working understanding of structured query language (SQL), normalization, transaction management and concurrency control.

5. Be acquainted with current issues concerning data and database management (e.g. XML and ‘Big Data’).

Class Format:

Students will read text chapters, participate in classroom lecture/discussion, complete and submit homework for most chapters, and take a competency quiz online for each chapter in the text. A deeper understanding of the material will be assessed via a series of three practicums (see later section).

The university and instructor are responsible for the technologies used in the course. If adjustments need to be made because some technology fails (such as the database server going down for extended periods), they will be. However, I cannot be responsible for the technologies used by the student. If your computer, network, or Internet connection fails you are still responsible for meeting deadlines and requirements. I suggest you have a contingency plan in place for such occurrences. Know where there are cybercafés or libraries that you can access the Internet from. Talk to friends that may allow you to use their equipment if yours fails, etc.

Homework:

Homework will be assigned for most chapters. All assignments are to be individual efforts. Assignments must be submitted prior to the due date/time for that assignment to receive credit. The solutions for the homework will be released immediately at that time so late submissions cannot generally be accepted. All assignments must be submitted electronically through Learn (Blackboard) or submitted on paper in class (I strongly encourage electronic submission when possible for the contribution to sustainability initiatives). A few of the assignments will be graphical in nature (such as diagramming). The easiest way to submit these specific assignments online is to draw them by hand and scan into a pdf file. Since these assignments are easiest to complete by hand and on paper, you can also submit the paper version in class. Most homework can be simply submitted as a text file. Read each assignment’s submission instructions carefully – not following directions may result in points being deducted – do not submit word processing documents. All homework will be due at the beginning of class on the date due whether submitting on paper or electronically. See specific instructions for each homework on Learn.

If you have an excused absence you must turn in the assignment before the due date when the absence allows for planning ahead (weddings, group trips, interviews, athletics, etc.). Excused absences that are true emergencies and do not allow planning ahead will be dealt with individually. No makeups will be given to compensate for a missed assignment once the due date has passed.

All homework combined will be worth 50 pts of the total points for the course. Each assignment will be given a grade representing the percentage correct of the assignment according to the criteria given for that assignment. The assignments will all be weighted equally so your overall assignment % will determine your assignment grade; 100% = 50 pts., 90% = 45 pts, etc.

As I believe that homework is best used as a learning experience rather than an evaluation of learning, homework will be graded on an effort basis. Homework will generally not be ‘corrected’ but rather will have solutions provided for the student to compare their answers to.

Readings:

Students should read the book material prior to class lectures for best results.

Chapter Quizzes:

Quizzes will be online and multiple choice (one per chapter). Since there is no way that I can ensure students are not accessing their texts during these quizzes I have designed this as open book. I am certain you understand that a M/C, open-book exam has little value if you can simply look up all the answers. Therefore, this necessitates implementing a time-limit for taking the quiz. The time-limit will be sufficient to answer each question from your own knowledge (generally 20 questions in 15 minutes). I am sure most of you will have sufficient time to look up a few answers but you will not be able to look up most or all of the answers during the quiz time. This means you should prepare for the quiz as if it were closed-book to maximize your score. The quizzes will use the ‘lockdown browser’ available on Learn to enhance security. You should not discuss question content with any other students (this would fall into the academic dishonesty section below). Also note that doing so may damage your own grade by making a grading curve less likely or at least higher. You may complete the quizzes any time prior to the deadline.

Chapters

Deadline for Completion

1, 2, 3 & Syllabus Quiz

September 26th

4, 5, 6

October 24th

7, 8, 9, 12

December 05th

Similar to homework, the quizzes will all be weighted equally so your overall quiz % will determine your quiz grade; 100% = 150 pts., 90% = 135 pts, etc.

Practicums:

This course employs three applied practicums. The three practicums will ask you to: 1) demonstrate database design skills; 2) demonstrate your ability to implement a database in an enterprise database environment database - using the database you create in practicum 1; 3) demonstrate structured query language (SQL) skills necessary to implement and interact with a database - using the database you implement in practicum 2.

Practicums 1 & 3 are in a closed-book format and will be taken in-class. Practicum 2 utilizes more of a project rather than an exam format. Each of these is detailed below.

Oracle Implementation Practicum (Practicum 2):

All Practicums will be done individually. Any help provided to other students will likely lower your grade by raising theirs on any potential curve. It is easy to identify those who have worked together on these and this would be a serious academic honesty offense. Just don’t do it. Note that giving or receiving help is considered an equal offense.

Each student will implement a small database. Students should access these materials as soon as they are available. You have the entire time window to work on this practicum since it is project based. The practicum instructions will be available soon after the design practicum is completed (early-October) and the practicum must be complete and submitted by November 14th at 9pm. Details will be announced soon after the database

design practicum (the problem scenario used in the design practicum will be utilized for all other practicums – the solution for the design practicum will be the basis for the implementation practicum). Practicums will be graded on overall quality and the meeting of specific requirements.

Design and SQL Practicums (Practicums 1 & 3):

I have called these ‘practicums’ instead of exams because they will target very specific skills and knowledge rather than being a general examination on everything we have covered up until that point.

The first practicum will be a database design problem. Students will need to read a problem scenario and create an entity relationship diagram. Other ERD related problems may also be included.

The third practicum (practicum 2 was discussed above this section) is on structured query language (DML and DDL). Students will write SQL statements associated with a problem scenario.

Students may feel free to inquire into any aspect of practicums or their scores. However, to encourage quick resolution of problems or concerns that may arise, issues must be raised with the instructor within one week following return of the exam grade. If the instructor is not contacted prior to that time the examination will be considered closed and grades finalized.

GRADES:

Homework (8)

50 pts.

Practicums (3 x 100 pts. each)

300 pts.

Chapter Quizzes (11)

150 pts.

TOTAL

500 pts.

The following scale indicates the minimum course percentage required for each letter grade:

Letter-grade determinations will be made on the following percentage basis (your score rounded to the nearest whole number): A >93; A- 90-92; B+ 87-89; B 83-86; B- 80-82; C+ 77-79; C 73-76; C- 70-72; D+ 67-69; D 60-66 F <60. A lower curve may be substituted at the discretion of the instructor. Do not try to anticipate the curve - target the score that will get you the desired grade on the straight scale above.

TENTATIVE SCHEDULE and REQUIRED DUE DATES: Day Topics Chapter Readings

Aug 26

 Course Introduction

 Introduction to the Database Environment

Syllabus

Chapter 1

No Homework

Aug 28

 Introduction to Oracle SQL Developer and the Oracle Environment, preface to SQL

 May introduce Chapter 2.

Sep 02, 04, 09

 Introduction to Structured Query Language (SQL)

Chapter 2

HW Due: 9/11

Sep 11, 16

 The Relational Model and Normalization

Chapter 3

HW Due: 9/18

Sep 18, 23

 Finish Normalization if necessary.

 Database Design Using Normalization

Chapter 4

HW Due: 9/25

Sep 25, 30

Oct 02

 Data Modeling and the Entity-Relationship Model

 Quizzes for Syllabus and Chapters 1, 2, 3 must be complete by the end of the day of Friday, Sep 26th .

Chapter 5

HW Due: 10/07

Oct 07

 Catch-up and/or Review for Design Practicum

Oct 09

 Design Practicum

Oct 14, 16, 21

 Transforming Data Models into Database Designs

Chapter 6

HW Due: 10/23

Oct 23, 28, 30

 SQL for Database Construction and Application Processing

 Quizzes for Chapters 4, 5, 6 must be complete by the end of the day of Friday, Oct 24th.

Chapter 7

HW Due: 11/04

Nov 04, 06

 Database Redesign (Nov 04 and ½ of class on Nov 06)

 Catch-up and/or Implementation Practicum Help Session

Chapter 8

HW Due: 11/13

Nov 13, 14

 Class time on Thursday: Implementation Practicum Help Session

 Implementation Practicum Deadline – Oracle access will be shutdown at 9pm on Friday, November 14th.

Nov 18, 20

 Managing Multiuser Databases

Chapter 9

Dec 02, 04

 Big Data, Data Warehouses, and Business Intelligence Systems

Chapter 12

HW Due: 12/05, midnight

Dec 04

 Catch-up and/or Review for SQL Practicum

Dec 05

 Quizzes for Chapters 7, 8, 9, 12 must be complete by the end of the day of Friday, Dec 05th.

Dec 12

 SQL Practicum: 12:45 - 3:00 p.m., Fri., December 12th

The Following Policies Apply to All Students in this Course:

A. Students attending the course who do not have the proper prerequisite risk being deregistered from the class.

B. Students have responsibility to ensure they are properly enrolled in classes. You are advised to review your official class schedule (using Student Tools on FlashLine) during the first two weeks of the semester to ensure you are properly enrolled in this class and section. Should you find an error in your class schedule, you have until Sunday, September 7, 2014 to correct the error. If registration errors are not corrected by this date and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester for any class in which you are not properly registered.

C. Academic honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit. In addition, it is considered to be cheating when one cooperates with another in any such misrepresentation. The use of the intellectual property of others without giving them appropriate credit is a serious academic offense. It is the University's policy that cheating or plagiarism result in receiving a failing grade for the work or course. Repeat offenses may result in dismissal from the University.

D. For Fall 2014, the course withdrawal deadline is Sunday, November 2, 2014.

E. Students with disabilities: University policy 3342-3-01.3 requires that students with disabilities be provided reasonable accommodations to ensure their equal access to course content. If you have a documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments. Please note, you must first verify your eligibility for these accommodations through Student Accessibility Services (contact 330-672-3391 or visit http://www.kent.edu/sas for more information on registration procedures).

F. Graduation: If you are eligible to graduate, it is your responsibility to apply for graduation before the set deadline (May Graduation: Apply before September 15th; August Graduation: Apply before December 15th; December Graduation: Apply before March 15th). If you apply after the deadline you will be assessed a $200 late fee. Please see your academic advisor as soon as possible if you are uncertain as to your progress toward graduation. To apply for graduation complete the following steps: Log onto your Flashline account 1. Click on the Student Tools tab, 2. Look in the Graduation Planning Tool Box, 3. Click on Application for Graduation. If an error message appears, you must contact your advisor.

Document Actions