44043-Brandyberry

M&IS 44043 - Database Management Systems SYLLABUS Summer I 2014

(Preview - This syllabus is complete and there are no plans to make changes – however, the instructor reserves the right to modify this syllabus up to the first day of class)

COURSE INFORMATION:

Name of Course:

Database Management Systems

Term:

Summer I 2014

Room:

Asynchronous Web-based Course

Meeting Time:

Asynchronous Web-based Course

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 preferred)

Office Hours:

Since the class is Internet-based, the office hours will be also. All inquiries should begin with an email (put 44043 in subject line) and if I cannot fully respond to your question(s) or issue(s) through that method we will schedule a phone conversation or an office appointment (for those in the Kent area in the summer).

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 some practicums (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. 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.amazon.com/Visioneer-Touch-Smoke-Parallel-Scanner/dp/B000058AL7

 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 and your scanner malfunctions 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 would then be submitted as soon as possible.

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:

Although this is a fully web-based course, it is designed to be as close to an in-class experience as the method currently allows. Students will read text chapters, view or listen to lectures, ask and answer questions on discussion forums 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).

I have heard that some believe that an online course is ‘easier’ than a traditional course (I’m certain that is not a universal perception but I thought I would address it). This class is not designed to be easier – it is also not designed to be more difficult than a traditional class. The primary goal is to make the learning experience as similar as possible to the traditional course.

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).

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. 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 viewing 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

June 20st

4, 5, 6

July 2rd

7, 8, 9

July 12th

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, 3) demonstrate structured query language (SQL) skills necessary to implement and interact with a database (using the database you create in (2)).

Practicums 1 & 3 are in a closed-book format and will have the same time-limits as when taken in-class. All students will use online proctoring (requires some additional equipment such as a webcam that most of you probably already have).

The online proctoring instructions will be published in the practicum folder prior to each practicum. If there is anyone that cannot use the online proctoring or cannot take the exam during the specified time window, for whatever reason, you should contact me as soon as this becomes apparent. 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 (unlike Practicums 1 & 3). 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 and the practicum must be complete and submitted by the date specified on the schedule (see below). 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. Follow the ProctorU instructions that will placed in the practicum folder in Learn prior to the practicum. When using ProctorU, you will need to take the practicum within the published times to take the exam (the available times will always include both afternoon and evening times). The duration of the exam will also be limited to the same amount of time provided to in-class students. Note that you must schedule your proctoring session with ProctorU at least three days prior to the session to avoid a service fee. For more general information on ProctorU services watch the video on this page: http://www.proctoru.com/portal/kent/.

Tentative ProctorU times (see ProctorU instructions in Practicum folder for confirmed times):

Practicum 1 (Design): Mon., Jun 30, 2014, 2:00-10:00pm (90 min time limit).

Practicum 3 (SQL): Sat., July 12, 2014, 2:00-10:00pm (90 min time limit).

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. See practicum study folder on Learn for past practicums.

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. See practicum study folder on Learn for past practicums.

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 four days 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 (7)

50 pts.

Practicums (3 x 100 pts. each)

300 pts.

Chapter and Syllabus Quizzes (10)

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.

SUGGESTED SCHEDULE and REQUIRED DUE DATES: Day Topics Chapter

Jun 09-10

 Course Introduction

 Introduction to the Database Environment

Chapter 1

No Homework

Jun 09-11

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

Jun 10-16

 Introduction to Structured Query Language (SQL)

Chapter 2

HW Due: 6/17

Jun 16-19

 The Relational Model and Normalization

Chapter 3

HW Due: 6/20

Jun 20

 Quizzes for Chapters 1, 2, 3 must be complete by the end of the day of Friday, June 20th.

Jun 19-22

 Database Design Using Normalization

Chapter 4

HW Due: 6/23

Jun 22-27

 Data Modeling and the Entity-Relationship Model

Chapter 5

HW Due: 6/28

Jun 27 – Jul 01

Jun 30

Jun 30

 Transforming Data Models into Database Designs

 Take Design Practicum Monday, June 30th.

 Implementation Practicum is available on July 1st. Due July 10th.

Chapter 6

HW Due: 7/02

Jul 02

 Quizzes for Chapters 4, 5, 6 must be complete by the end of the day of Wednesday, July 2nd.

Jul 01-06

 SQL for Database Construction and Application Processing

Chapter 7

HW Due: 7/07

Jul 05-09

 Database Redesign

Chapter 8

HW Due: 7/10

Jul 10-12

Jul 10

 Managing Multiuser Databases

 Implementation Practicum due Thursday, July 10th.

Chapter 9

No Homework

Jul 12

 Quizzes for Chapters 7, 8, 9 must be complete by the end of the day of Saturday, July 12th.

Jul 12

 Take SQL Practicum Saturday, July 12th.

Chronological list of all due dates:

June 17 (Tuesday) – Chapter 2 homework due.

June 20 (Friday) – Chapter 3 homework due.

June 20 (Friday) – Quizzes for syllabus and chapters 1, 2, 3 due.

June 23 (Monday) – Chapter 4 homework due.

June 28 (Saturday) – Chapter 5 homework due.

June 30 (Monday) – Take Design Practicum.

July 02 (Wednesday) – Chapter 6 homework due.

July 02 (Wednesday) – Quizzes for chapters 4, 5, 6 due.

July 07 (Monday) – Chapter 7 homework due.

July 10 (Thursday) – Chapter 8 homework due.

July 10 (Thursday) – Implementation Practicum due.

July 12 (Saturday) – Quizzes for chapters 7, 8, 9 due.

July 12 (Saturday) – Take SQL Practicum.

NOTES:

 All homework and quiz dates require submission by the end of the day (midnight).

 Homework, Quizzes, and the Implementation Practicum may be submitted any time prior to the due date.

 The Design and SQL Practicums must be submitted during the time window they are available on ProctorU (see section on practicums above).

 Finally, note that though nothing is due before the 17th, it would be a CRITICAL mistake to wait until that is close to get started. There is a lot of material to get through before the first homework is due.

The Following Policies Apply to All Students in this Course:

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

B. Students have responsibility to ensure they are properly enrolled in classes. Students have responsibility to ensure they are properly enrolled in classes. Should you find an error in your class schedule, you need to correct the error with your advising office no later than Tuesday, May 20, 2014 for Intersession 2014 – Thursday, June 12 for Summer I – Sunday, June 15 for Summer II - and Thursday, July 17 for Summer III. If registration errors are not corrected by these dates 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. Summer I 2014 course withdrawal deadline is Sunday, June 29, 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.