Information

Instructor: Chris Sexton

Office: LF122, M/W 15:30-17:00

Phone: 812-341-3465 (This is an answering machine.)

Email: cwsexton@ius.edu (Email is best!)

Meetings: M/W 13:00-14:50 in LF-143

Text: Fundamentals of Database Systems by Elmasri and Navathe, Pearson Higher Education. ISBN: 978-0133970777

Course

B461 Database Concepts (4 cr.) Prerequisites: CSCI C343

Introduction to database concepts and systems. Topics include database models and systems: hierarchical, network, relational, and object-oriented; database design principles; structures for efficient data access; query languages and processing; database applications development; views; security; concurrency; recovery. Students participate in a project to design, implement, and query a database, using a standard database system.

Schedule

Note: Many of these links may be dead. They will be live when we reach the content represented. Please ask via email if there is a particular file missing from the course that should be live.

Day Topics Notes

1

Introduction

2

Concepts & Architecture

3

Entity Relationships

4

Enhanced ER

5

Data Formats

6

Data Formats

7

Relational Data

8

Test 1

9

SQL

10

More SQL

11

More SQL

12

Relational Algebra

13

Using SQL on the web

14

Relational Design

15

Physical Storage

16

Indexing Systems

17

Test 2

18

Document Databases

19

Distributed Databases

20

Graph Databases

21

MapReduce/Hadoop

22

Transactions

23

Optimizations

24

Database Security

25

Database Security

26

Test 3

Assignments

Given Due Date Assignment

01-13

01-15

Student Profile: Survey

01-15

01-22

Homework 1: Architecture

01-22

01-29

Homework 2: ER Diagrams

01-29

02-05

Homework 3: Data Formats

02-10

02-10

Test 1:

02-17

02-24

Homework 4: Relational Data; CSLabs VM

02-24

03-02

Homework 5: SQL

03-02

03-09

Homework 6: Relational Algebra

03-11

03-11

Test 2:

03-04

03-25

Homework 7: Relational Design

03-25

04-01

Homework 8: NoSQL

04-01

04-08

Homework 9: Graph Databases

04-08

04-15

Homework 10: Transactions

04-15

04-22

Homework 11: Security

04-29

04-29

Final:

These events are in a public calendar you may add to your own calendar software: Published iCal Link

This schedule is tentative.

Some F# resources

Grading Scale

Grade Percentage

Letter Grade

90-100

A

80-89

B

70-79

C

60-69

D

0-59

F

A +/- will be added for the upper/lower two points of each grade respectively.

Note that a C is the minimum grade accepted for Natural Science Degrees.

Course Evaluation

Homework

35%

Exams

55%

In-Class

10%

Homework

  1. Homework assignments cover areas you need to know and practice.

  2. Submit homework at the beginning of class or by time posted in Canvas if online.

  3. Your submission must be your own work.

In-Class

  1. Each class may have an in-class element that counts towards the in-class evaluation.

  2. These assignments will not be graded, but participation points will be awarded.

  3. Class participation will also be assigned in this category.

Code of Student Rights, Responsibilities and Conduct

You are responsible for knowing the IU Code of Student Rights, Responsibilities, and Conduct. http://www.iu.edu/~code/

Student responsibilities outlined in the code include Academic Misconduct and Personal Misconduct. Academic Misconduct includes cheating, fabrication, plagiarism, interference, violation of course rules, and facilitating academic dishonesty. Personal Misconduct includes acts of personal misconduct both on and off university property. Ignorance of the rules is not a defense.

Plagiarism

Plagiarism is defined as presenting someone else’s work, including the work of other students, as one’s own. Any ideas or materials taken from another source for either written or oral use must be fully acknowledged, unless the information is common knowledge. What is considered "common knowledge" may differ from course to course.

A student must not adopt or reproduce ideas, opinions, theories, formulas, graphics, or pictures of another person without acknowledgment. A student must give credit to the originality of others and acknowledge indebtedness whenever: Directly quoting another person’s actual words, whether oral or written; Using another person’s ideas, opinions, or theories; Paraphrasing the words, ideas, opinions, or theories of others, whether oral or written; Borrowing facts, statistics, or illustrative material; or Offering materials assembled or collected by others in the form of projects or collections without acknowledgment. Cheating:

Cheating is considered to be an attempt to use or provide unauthorized assistance, materials, information, or study aids in any form and in any academic exercise or environment.

Penalties

  • Cheating on homework assignments - loss of all points for that homework and if severe, a failing grade for the course.

  • Cheating on quizzes - loss of all points for that quiz and if severe, a failing grade for the course.

  • Cheating on exams - loss of all points for that exam and if severe, a failing grade for the course.

Course Policies

  • Please do not hesitate to email me at cwsexton@ius.edu if you need to get in touch outside of campus or outside of office hours. I will be happy to resolve issues via email or set up a video call. I will do my best to respond to your emails within 24 hours during business hours Monday through Thursday. It may take me longer to respond on the weekends.

  • Feel free to use your laptop during class. Taking notes and following along with exercises is a great way to stay engaged with class. Please avoid allowing any technology use to become a distraction. Participation points may be lowered in this case.

  • Please keep your personal computing devices on silent or vibrate.

  • If problems occur or if you become ill, please contact me immediately so we can determine your best options.

  • If you have problems with equipment, please let me know but you should also contact a person at the computer helpdesk immediately at (812) 941-2447. Technical issues are not an excuse for late work. Assignments are given with plenty of lead time to proactively solve technical issues.

  • Please proof all assignments and email messages to ensure the use of Standard English, proper grammar, and correct spelling. You will lose points for problems in this area. If you have concerns about your writing, contact the Writing Center for a consultation.

  • Class Attendance: At IU Southeast, attendance is required. Participation points are non-recoverable for absences.

  • You’re probably used to seeing many policy statements on a syllabus.  Faculty include these statements to ensure you understand course expectations so that you can succeed in your courses.  At IU Southeast, we have placed all university policies on a single website easily accessed from every Canvas course site. Simply look at the left navigation bar and click on Succeed at IU Southeast. You can find links to sites with a great deal of useful information including

    • How to avoid plagiarism and cheating

    • Disability Services

    • FLAGS

    • Tutoring centers

    • Canvas Guides

    • Financial Aid

    • Sexual Misconduct

    • Counseling

    • Writing Center and much more!  

      My expectation is that you review university policies carefully to ensure you understand the policy and possible consequences for violating the policy.  Please contact me if you have any questions about any university policy.

  • All labs/assignments/forums/quizzes/tests/etc. will be open for a time window, at least a number of hours and in many cases a number of days.

    Documented illness is the only acceptable excuse for not completing an assignment during its open window. Other reasons for not completing labs/assignments/forums/quizzes/tests/etc. must be explained to the satisfaction of the instructor, who will decide whether missed assignments may be made up. Being sick on the last few days of an assignment’s due date is NOT an excuse.

Disclaimer

Although every effort has been made to make the above listing complete and accurate, minor adjustments to the schedule are sometimes necessary due to weather, or other problems that crop up. The quantity of assignments and tests will not increase. In-Class work may change. The grading scale and late policy will remain constant.