INTRODUCTION

TO DATABASE

• Course Overview &

Structure
• Code: 1221024
• Credits: 4
1
 • BASIC DETAILS:
– Course Code: 1221024
– Credits: 4 (Theory: 45h + Practice:
30h + Self-study: 120h)
Course – Duration: 15 weeks

Information – Prerequisite: Introduction to

Programming

• INSTRUCTOR: Pham Minh Dung –

dungpm@[Link]

2
 • Build foundation in database
Course Objectives management systems
• FOUNDATION:
– Database concepts and
architecture
– ER modeling and relational theory
– SQL and query languages
• PRACTICE:
– SQL Server hands-on experience
– Database design projects
– Query optimization
• APPLICATION:
– Real-world database solutions
– Team collaboration on DB
projects

3
 Course Learning Outcomes (CLOs)

KNOWLEDGE (CLO1-4): SKILLS (CLO5-6): ATTITUDE (CLO7):

CLO1: Database concepts, CLO5: Teamwork and Positive, proactive,
organization, and architecture problem-solving responsible, lifelong learning
CLO2: ER model and CLO6: Database design, data mindset
relational model theories organization, and querying
CLO3: SQL language (DDL,
DML, queries, relational
algebra)
CLO4: Integrity constraints in
relational databases 4
 Course Content - 6 Chapters
CHAPTER 1: Database CHAPTER 2: Database CHAPTER 3: Database
Overview (Week 1) Management (Week 2) Querying (Weeks 3-6)
• Introduction, evolution, • SQL Server, data types, • Relational algebra, SQL
characteristics, DDL, DML, constraints queries, joins, grouping,
architecture nested queries

CHAPTER 4: ER CHAPTER 5: CHAPTER 6:

Model Design (Week Relational Model Integrity Constraints
7) (Week 10) (Weeks 12-13)
• Entity-Relationship • ER to relational • Domain, entity,
modeling, ER diagrams conversion, schema referential, user-defined
design constraints
5
 3 Online Sessions on Moodle
• ONLINE SESSION 1 - Week 8:
– Topic: ER Model Design
– Activity: Group project - Build ER diagram
– Deliverable: ER model report
• ONLINE SESSION 2 - Week 11:
– Topic: Relational Model Conversion
– Activity: Group project - Convert ER to relational schema
– Deliverable: Relational model report
• ONLINE SESSION 3 - Week 14:
– Topic: Physical Implementation
– Activity: Group project - Implement database + queries + constraints
– Deliverable: Implementation report (SQL scripts + testing)
• All online sessions contribute to Process assessment (50% of 20%)
6
 Assessment Structure
PROCESS (20%):
• Attendance: 10% (must attend 100% of classes)
• Class participation: 20%
• Online activities (Moodle): 30%
• Midterm exam: 40%
PRACTICE (30%):
• Attendance: 30% (must complete 70%+ labs)
• Lab tests: 30%
• Final practical exam: 40%
FINAL EXAM (50%):
• Multiple-choice exam on Moodle
• 60 minutes, no materials allowed
• Topics: All chapters (Concepts, SQL, ER, Constraints, Algebra) 7
 Group Project (Online Sessions)
TEAM
DELIVERABLES: GRADING:
STRUCTURE:
• 4-5 students per • Week 8 (Online 1): • Each online
group ER Model diagram session contributes
• 1 team leader and report to Process grade
required • Week 11 (Online • Teamwork,
• Registration: First 2): Relational documentation
class session only schema and report quality, technical
• Week 14 (Online accuracy
3): SQL • Individual
implementation + contributions will
testing be evaluated
8
 Practical Labs (SQL Server + ERD Plus)
• WEEKS 1-7: SQL FUNDAMENTALS
– Lab 01: DDL - Define database structures
– Test 01: DDL assessment
– Lab 02: DML - Insert, update, delete operations
– Lab 03 (Parts 1-3): SQL queries (select, join, grouping)
– Test 02: SQL queries assessment

• WEEKS 8-9: ER MODEL

– Lab 04: ER diagram design using ERDPlus
– Test 03: ER model assessment

• WEEK 10: FINAL PRACTICAL EXAM

– Comprehensive database implementation
– Worth 40% of Practice grade (30% total) 9
 Final Exam - Multiple Choice on Moodle
• EXAM FORMAT:
– Platform: Moodle (online)
– Type: Multiple-choice questions
– Duration: 60 minutes
– Materials: NO MATERIALS ALLOWED (closed book)

• EXAM CONTENT:
– Database concepts and characteristics
– DDL, DML, SQL commands
– ER model design
– ER to Relational conversion
– Integrity constraints
– Relational algebra

• WEIGHT: 50% of final grade 10

 • WEEKS 1-2: Database Overview &
Management
– Chapter 1: Database concepts • Chapter 2:
15-Week Course SQL Server basics
• WEEKS 3-6: Database Querying
Timeline
– Chapter 3: SQL queries, joins, grouping,
nested queries
• WEEK 7: ER Model Design
– Chapter 4: Entity-Relationship modeling
• WEEK 8: Online 1 - ER Project Report
• WEEK 9: Midterm Exam
• WEEK 10: Relational Model
– Chapter 5: ER to Relational conversion
• WEEK 11: Online 2 - Relational Model Report
• WEEKS 12-13: Integrity Constraints
– Chapter 6: Constraints and business rules
• WEEK 14: Online 3 - Implementation Report
• WEEK 15: Review 11
 Learning Resources
• MAIN TEXTBOOK:
– Cơ sở Dữ liệu (2020) - Đồng Thị Bích Thủy et al. NXB Khoa học và Kỹ thuật

• REFERENCE BOOKS:
– • Database System Concepts (7th Ed) - Silberschatz et al. A First Course in Database
Systems (3rd Ed) - Ullman

• SOFTWARE TOOLS:
– Microsoft SQL Server (required)
– ERDPlus: [Link] (ER diagram tool)

• ONLINE RESOURCES:
– Moodle: [Link]
– Microsoft SQL Docs: [Link]/sql
– All slides, labs, assignments on Moodle 12
 Important Requirements

ATTENDANCE: ASSIGNMENTS: EXAMS: ACADEMIC

INTEGRITY:
✓ Theory: 100% ✓ Individual: ✓ Midterm: In-class, ✓ No plagiarism, no
attendance required Complete all Chapters 1-4 cheating
Moodle activities
✓ Practice: Must ✓ Final: Moodle, 60 ✓ Cite all sources in
complete 70%+ of ✓ Group: 3 online min, no materials, reports
lab assignments project deliverables all chapters
(Weeks 8, 11, 14)
✓ Absence without ✓ Practical: SQL
permission may ✓ Submit on time Server, hands-on
result in failing (late penalties implementation
grade apply)
13
 • ATTEND ALL CLASSES:
• Theory and practice sessions are essential
• 100% attendance required
Tips for Success • PRACTICE REGULARLY:
• SQL is a skill - practice makes perfect
• Complete all lab exercises
• Experiment with SQL Server

• COLLABORATE EFFECTIVELY:
• Work well with your team on group project
• Share knowledge, ask questions

• PREPARE FOR EXAMS:

• Review slides and textbook
• Practice SQL queries
• Understand concepts, not just memorize

• ASK FOR HELP:

• Email: thaitm@[Link]
• Office hours, Moodle forum 14
 Contact & Questions
INSTRUCTOR
Pham Minh Dung
Information Systems Department
dungpm@[Link]
[Link]
Questions?
Ask now or email me

Welcome to Introduction to Database! Let's learn together!

15