CE384: Database Design

Spring 2024, Group 1; Computer Engineering Department, Sharif University of Technology, Tehran, Tehran Province, Iran

Classes: Sundays and Tuesdays, 16:30-18:00, Class 102

This course delves into the principles of database management, focusing on essential concepts applicable across various domains. Database management is a crucial discipline that explores the organization and manipulation of data within information systems. The course covers fundamental topics such as entity relationships, SQL query, relational algebra, normalization, NoSQL query, and optimizations. Proficiency in database management is vital in fields like software development, business intelligence, data analysis, cybersecurity, and information technology. Given its pervasive relevance, database management is a cornerstone of academic programs, reflecting its significance in contemporary technological landscapes.

Syllabus

Instructor

Maryam Ramezani

PhD, Guest Lecturer

Office CE803 and CE802

maryam.ramezani@sharif.edu

Teaching Assistants

Shayan Shabani

Lead TA

shayan.shabani5814@gmail.com

Amirmahdi Meighani

Lead TA

Amirmm71382@gmail.com

Hossein Aghaei

SQL Workshop

h.aghaei.araei@gmail.com

Shahab Hosseini

NoSQL Workshop

s.hosseini306@gmail.com

Materials

Course Description

Bahman 15, 1402

Slide

Introduction

Bahman 24, 1402

Slide Notes

Database Architecture

Bahman 29, 1402

Slide Notes

Data Modeling Introduction

Esfand 1, 1402

Slide

Entity Relationship (ER) Model

Esfand 12, 1402

Slide Notes

Enhanced Entity Relationship (EER) Model

Esfand 15, 1402

Slide

Logical Design Introduction

Esfand 20, 1402

Slide Notes

Reducing ER Diagrams to Relational Schemas

Esfand 22, 1402

Slide Notes

Reducing EER Diagrams to Relational Schemas

Esfand 27, 1402

Slide Notes

Introduction to SQL

Farvardin 21, 1403

Slide Notes

DDL SQL Statements

Farvardin 21, 1403

Slide Notes

DML SQL Statements

Ordibehesht 2, 1403

Slide

DCL SQL Statements

Ordibehesht 2, 1403

Slide

View

Ordibehesht 9, 1403

Slide Notes

Three-Schema Architecture and Data Independence

Ordibehesht 9, 1403

Slide

TCL

Ordibehesht 11, 1403

Slide

Integrity, Assertion, Procedure, Function, and Trigger

Ordibehesht 11, 1403

Slide Notes

Relational Algebra

Khordad 8, 1403

Slide Notes

Relational Calculus

Khordad 8, 1403

Slide Notes

Functional Dependencies

Khordad 8, 1403

Slide Notes

Normalization

Khordad 8, 1403

Slide Notes

Optimizing Database Performance

Khordad 8, 1403

Slide

Assignments

Mongo DB

HW4-Practical

100 Points, Submission Deadline: 1403/04/06

Jupyter Notebook Mongo DB Workshop

Normalization, Index, Partition

HW4-Theory

110 Points, Submission Deadline: 1403/03/29, late submission until 1403/04/02

Question Set Q6-Database

Assertion, Trigger, Relational Algebra and Calculus

HW3

210 Points, Submission Deadline: 1403/03/17, late submission until 1403/03/21

Question Set

SQL & View

HW2

160 Points, Submission Deadline: 1403/02/15, late submission until 1403/02/19

Question Set Q3-Database Q4-Database Solution Set

Entity Relationships & Logical Design

HW1

210 Points, Submission Deadline: 1403/01/22, late submission until 1403/01/24

Question Set Solution Set

Problem sets

No Problem sets has been posted yet.

CE384: Database Design

Instructor

Maryam Ramezani

Teaching Assistants

Shayan Shabani

Amirmahdi Meighani

Hossein Aghaei

Shahab Hosseini

Ehsan Rahmani

Parham Rezaei

Kiarash Kianian

Fatemeh Esbati

Ali Alvandi

Erfan Jafari

Asemaneh Nafe

Niki Sepasian

Farhad Esmail Zadeh

AmirReza Abotalebi

Zahra Rahmani

Reza Heidari

Amirhossein Alamdar

Haniye Mollaei

Taraneh Khosrojerdy

Alireza Farshi

Mohammaderfan Salima

Mahan Bayhaghi

Amirmahdi Daraie

Helia Akhtarkavian

Pedram Sadeghian

Arshia Dadras

Danial Gharib

Amirhossein Azizi

Ali Bakhtiari

Mohammad Mahdi Akbar

Materials

Course Description

Bahman 15, 1402

Introduction

Bahman 24, 1402

Database Architecture

Bahman 29, 1402

Data Modeling Introduction

Esfand 1, 1402

Entity Relationship (ER) Model

Esfand 12, 1402

Enhanced Entity Relationship (EER) Model

Esfand 15, 1402

Logical Design Introduction

Esfand 20, 1402

Reducing ER Diagrams to Relational Schemas

Esfand 22, 1402

Reducing EER Diagrams to Relational Schemas

Esfand 27, 1402

Introduction to SQL

Farvardin 21, 1403

DDL SQL Statements

Farvardin 21, 1403

DML SQL Statements

Ordibehesht 2, 1403

DCL SQL Statements

Ordibehesht 2, 1403

View

Ordibehesht 9, 1403

Three-Schema Architecture and Data Independence

Ordibehesht 9, 1403

TCL

Ordibehesht 11, 1403

Integrity, Assertion, Procedure, Function, and Trigger

Ordibehesht 11, 1403

Relational Algebra

Khordad 8, 1403

Relational Calculus

Khordad 8, 1403

Functional Dependencies

Khordad 8, 1403

Normalization

Khordad 8, 1403

Optimizing Database Performance

Khordad 8, 1403

Assignments