Transcript Introduction to Software Engineering

CSE202 : Fundamentals of Database Systems
Vikram Goyal
Indraprastha Institute of Information Technology, Delhi (IIIT-D), India
FROM : Slides from CSE202 taught by Dr. Ashish Sureka last winter
Course Name
Database Systems Concepts
Course Number
CSE 202
Instructor
Vikram Goyal
Teaching Assistants
[email protected] and others
Semester
Winter 2015 [Jan – May]
Credits
4
Class Timings
Wednesday, Fri : 11:00 AM – 12:30 PM
Location
C21
Number of Lectures
28
Audiences
BTech 2nd Year Students [4th Semester]
Number of Students
Around 130
Instructor Office Hours
Friday 12:30 AM – 01:30 PM – Send an email before coming
TA Office Hours
Course Website
Usebackpack.com
Course Mailing List
[email protected]
Text Books
• Database Systems: The Complete Book
– Hector Garcia Molina, Ullman, Widom
• Database System Concepts:
– Silberschatz, Korth, Sudarshan
Introduction to DBMS Course
Application-Oriented
Systems-Oriented
Application Oriented
In this Course, We will take
 How to use databases to construct applications.
 Details of database internals are kept to the minimum the application-oriented
approach
Systems-Oriented
 Implementation techniques used in database systems
Database System Concepts, Sixth Edition
Key people
Intro to Databases
 DBMS implementer
 Database designer
 Database application developer
 Database administrator
FROM : Introduction to Databases : Jennifer Widom : Stanford University
http://openclassroom.stanford.edu
Learning Objectives
DBMS are central component of a modern computing environment
Knowledge about database systems has become an essential part of an education in
Computer Science
Prerequisites
 Data Structures
High-level programming language such as Java, C, C++, Python
Objectives
 First course in databases
 Fundamental concepts of database management
 Aspects of Database design
 Aspects of Database languages
 Some aspects of Database-system implementation
Concepts and algorithms in a general setting that is not tied to one particular database system
Database System Concepts, Sixth Edition
Topics to be Covered
 Introduction to the Relational Model
 Design Theory of Relation Databases
 Database Design: The Entity-Relationship Approach
 Database Language SQL
 Relational Database Design
 Application Design (including JDBC)
 Indexing and Hashing
 Query Processing
 Transactions
 Concurrency Control and more ……
Post Objectives
• Ability to develop an efficient solution to a
problem using RDBMS concepts
• Ability to write SQL queries
Grading Policy
• Mid-term Exam: 25%
– Syllabus covered till mid-term
• End-term Exam: 25%
– Complete syllabus
• Quizzes: 10 % (Best 2 out of 3 quizzes)
• Home Assignments (5): 10%
• Lab: 30%
TA’s
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Nikita Jain
Jyoti Leeka, [email protected]
Siddharth Dawar, [email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
Discussion of Assignment Doubts
• Tutorials fortnightly
– Four groups of size 30 each
Lab Assignment
•
•
•
•
•
•
•
Problem Statement
ER Model
Normalization
Relational Schema
Schema Implementation in MySQL
SQL Queries
GUI and database access using Python, PHP,
Javascript
Intro to Databases
Whether you know it or not,
you’re using a database every day
FROM : Introduction to Databases : Jennifer Widom : Stanford University
http://openclassroom.stanford.edu
Some Ways you May Use Databases
Slide from : https://sites.google.com/a/cs.berkeley.edu/cs186-sp11/