Course Information
| Course Title | Database Management Systems |
| Course Number | CS 5200 |
| Semester | Summer 1 2019 |
| Location |
NEU Silicon Valley Campus 6024 Silver Creek Valley Rd. San Jose, CA 95138 |
| Lectures |
Monday, Tuesday, 12pm - 3pm IoT Classroom, NEU Silicon Valley Campus |
| Prerequisites |
|
| Instructor | Philip Gust |
| Teaching Assistants |
Qing Liao Suhas Mohan |
Office Hours
Instructor Office Hours
|
Philip Gust p.gust@northeastern.edu |
| Day | Time | Location |
|---|---|---|
| Monday |
9.00am–11.30am 3pm–5pm |
NEU Silicon Valley Campus |
| Tuesday |
9.00am–11.30am 3.00pm–5.30pm |
TA Office Hours
|
Qing Liao liao.qing@husky.neu.edu |
| Day | Time | Location |
|---|---|---|
| Monday | 3.00pm–6.00pm |
NEU Silicon Valley Campus |
| Friday | 3.00pm–6.00pm |
|
Suhas Mohan mohan.su@husky.neu.edu |
| Day | Time | Location |
|---|---|---|
| Thursday | 1.00pm–4.00pm |
NEU Silicon Valley Campus |
Course Description
This course introduces database management systems as a class of software systems. Students will study and gain experience with two of todays dominant types of database management systems: Relational Database Management Systems (RDBMS) and Non-Relational or NoSQL databases. The goal is to prepare students to analyze the requirements of a given applicaton and select the appropriate type of database, and to gain competentency in the major features of each.
Grading Policy
The class includes individual assignments, quizzes, and two projects.
| Individual Assignments | 50% |
| Quizzes | 15% |
| RDBMS project | 30% |
| Instructor's discretion | 5% |
The final grade for a student is calculated as the weighted average of the preceding list and rounded up to the nearest integer. The mapping to a letter grade uses the following scale
| A | [95, 100] |
| A- | [90, 94] |
| B+ | [85, 89] |
| B | [80, 84] |
| B- | [75, 79] |
| C+ | [70, 74] |
| C | [65, 69] |
| C- | [60, 64] |
| D | [0, 59] |
Extensions
Late assignments will not be accepted unless you have explicit instructions from the instructor. If you are to miss lectures or require an extension for a deadline, ensure you inform the course staff in advance. The earlier we are informed the easier it will be to accommodate your request.
Attendance
You are expected to attend all lectures and all code walks.
Missing Lectures
If you have to miss a lecture please inform the course staff. Materials covered for each lecture, readings, tutorials, assignments, are available on the course web page.
Assignment Extensions
Assignment extensions are at the discretion of the instructors. If you would like to discuss a possible extensions talk to the course instructors in advance (minimum of 48 hours).
Academic Honesty
You are expected to read, understand, and follow the University’s policies on Academic Integrity. You should also review and understand the Academic Integity presentation that was made at the orientation session.
During assignments you are encouraged to discuss the problem with classmates on piazza or other forums. You are however not allowed to share solutions.
Working Individually
All work submitted for assignments expected to be completed individually must be your own work. You are not allowed to share code. Code that is identical or similar will be penalized and reported to the appropriate University authorities.
Working in Teams
All work submitted for assignments expected to be completed as a team must be the team’s work. You are not allowed to share code with people outside your team or with another team. Code that is identical or similar will be penalized and reported to the appropriate University authorities.
Tips for Success
You cannot learn everything you need to know in lectures or homeworks. You must:
- Read the required material and as much supplemental material as
possible.
Try to stay ahead of the game and read material before it is covered in class. If you have questions, write them down. If these questions don't get covered, ask in class or meet with the tutors, lab coordinator, or professor.
- Attempt to solve additional problems.
Try to solve as many exercises as possible as you read sections in the book. If you can't do them, read the material again.
- Attend lectures.
Lectures accentuate the material you should have already read from the book. Take advantage of the extra explanations and examples during the lectures to ensure you comprehend the material. Prepare questions to ask, but also listen to questions asked by your classmates.
- Talk to the course staff.
If the lecture and the notes leave you with questions on the material, see your teacher(s) during office hours or make an appointment. Mark the passages in the book(s) that you do not understand, and prepare questions that express what you do not understand.
- Keep up.
Experience proves that students who fall behind quickly drop out. So, keep up with the readings, tutorials, and the homeworks. Ask for additional problems, if the homeworks failed to make a point.
Diversity/Disability Statements
If you require support during the course due to a disability please ensure that you are already registered with the University’s Disability Center, and contact your course instructors to coordinate any support needed during the course.
Software
The course will be making heavy use of the following software
- Eclipse Java Development Environment (JDE)
- Apache Derby RDBMS MariaDB open-source fork of the MySQL database.
- MariaDB open-source fork of the MySQL RDBMS.
- MongoDB NoSQL DBMS Community edition.
- CCIS GitHub instance (NOTE: This is not the public GitHub, but rather the Department's own GitHub instance.)
Helpful Links
Browser Compatibility
This website has been tested with the following browsers- Internet Explorer version 10 (or above)
- Chrome version 44 (or above)
- Firefox version 40 (or above)
- Safari version 7 (or above)