Database 2018-02

Class Information

	Class Info
Class	ETA00137 - 데이터베이스
Lecturer	Seongjin Lee
Time and Place	407-507 Tuesday 16:00-18:00 407-507 Thursday 16:00-17:00
Office Hour	Tuesday: 18:00-19:00
Contacts	Office: 407-314
	Email: insight at gnu dot ac dot kr

Course Introduction

In Database Management System (DBMS), we study the database which is organized and structured collection of data. DBMS is a software system which acts as intermediary between user or application and the data. It allows to navigate through the data and analyze the data. In this course, we are going to learn the core mechanism that holds the system together.

Goal

In this course, we are going to learn the essence of data base management system. Students are going to learn the following concepts.

• Relational model
• Entity-relational model
• SQL
• External, conceptual, physical levels of DMBS
• Data definition language, Data manipulation language, query language
• Data structures
• Index
• Transaction and Concurrency

Text Book

Main Textbook

Not necessarily required to buy the book

• Database Systems : the Complete Book (Paperback) | Garcia-Molina, Ullman 지음 |Pearson Education Asia [link ][1판 번역본 ]

Supplementary Textbook

• Database Management Systems 3/E, Ramakrishnan , Gehrke, Johannes 지음 | McGraw-Hill 번역본 교보문고 바로가기
• 만화로 쉽게 배우는 데이터베이스, Takahashi Mana 지음, 홍희정 옮김, Azuma Shouko 그림, 성안당
• 데이터베이스 시스템 (AN INTRODUCTION TO DATABASE SYSTEMS), C.J. Date, Pearson, 2004

Evaluation

Categories	Ratio	Categories	Ratio
Attendance	10	Quiz	10
Assignments	10	Midterm	30
Project	20	Final	30
		Total	100%

• All exams are closed book and closed notes
• Any request for regrade must be made within one week of the time that the paper is returned, with no exception. You should describe in writing why the score is incorrect or graded unfairly. The written argument must be self-contained and can be evaluated based only on what is written on the paper.

Discussion

Please provide your info on this link.

All discussions and assignments are to be submitted in Piazza. Enroll into the class through the following link

Working Environment Setup

Step 1: Installing Jupiter Notebook

Gentle reminder that, jupyter notebook best works at Linux

Option 1: Installation via Anaconda

It is recommended that you install Jupyter Notebook via Anaconda

1. Download & install Anaconda for Python here
2. Run jupyter notebook to confirm that it is properly installed

If Anaconda doesn't have jupyter: you can try running

conda install jupyter

Option 2: Installation via pip

You can also install via the python package manager pip

1. Make sure you have installed
   • python and pip
2. Make sure pip is updated to its latest version

   pip install --user --upgrade pip

3. Install Jupyter Notebook

   pip install --user --upgrade jupyter

Installing other kernels and versions of python

When you are using Python3 and want to switch to Python2 in the notebook,

python2 -m pip install ipykernel

python2 -m ipykernel install —user

After restarting the Jupyter, you can chose different kernel in Jupyter notebook.

Step 2: Installing Other Dependencies

Git

Git is a version control system which we use to store the various course material; you can download from here

• you can download the course material from here
• If you want the up-to-date version of the course material, checkout the course repository from the git by typing the following command
  • git checkout https://github.com/resourceful/lecture_db

IPython-SQL

python-sql allows you to use SQL queries inside jupyter notebooks; install using pip

• pip install --user --upgrade ipython-sql

other modules

you will be needing

• markdown
• numpy
• pandas

Step 3: Getting Started

Getting the latest course materials

You can always access the latest course materials on the course website. You can download all at once and keep them synced by using git. To get started with this, run:

git clone https://github.com/resourceful/lecture_db

Now you should have all the materials in Database; to get the latest version, run the following command in the repository.

git pull

To read the notebook

In the directory where the relevant course materials are, run:

jupyter notebook