Skip to content
CS340: Introduction to Database Systems
التجربة المجانية
Sample Lesson
Collapse
التجربة المجانية
8 Topics
1.1 what will you learn in this course
1.4 how to get an A+
2.2 attriubtes part 1
3.1 intro to EERD, super and sub classes
4.1 introduction to relational model
5.1 mapping ERD steps 1 and 2 and DDL
6.2 SELECT and WHERE clauses and examples
Topic
Chapter 1
Expand
Chapter 1
4 Topics
1.1 what will you learn in this course
1.2 what is a database-1
1.3 DBMS functions and design
1.4 how to get an A+
Chapter 2
Expand
Chapter 2
7 Topics
2.1 erd intro
2.2 attriubtes part 1
2.3 attributes continued and keys corrected
2.4 relationships and cardinality
2.5 participation constraints and weak entities
2.6 erd conventions and min max notation
2.7 higher degree relationships
Chapter 3
Expand
Chapter 3
6 Topics
3.1 intro to EERD, super and sub classes
3.2 super class and sub class notation
3.3 constraints on super and sub classes
3.4 specialization and generalization
3.5 hierarchies, lattices, shared subclasses, and categories
3.6 category inheritance and aggregation
Chapter 4
Expand
Chapter 4
8 Topics
4.1 introduction to relational model
4.2 DBMS languages and schema
4.3 schema and characteristics of relations
4.4 tuple notation and different types of constraints
4.5 relational schema states and constraints
4.6 update violations
4.7 DBMS component module and centralized DBMS
4.8 2 and 3 tier server client
midterm solution
Expand
midterm solution
4 Topics
Q1 part 1
Q1 part 2 and 3
Q1 part 4 and 5
Q2 and Q3
Chapter 5
Expand
Chapter 5
5 Topics
5.1 mapping ERD steps 1 and 2 and DDL
5.2 more DDL and step 3 (binary 1 to 1)
5.3 mapping binary (contd.), multi valued, and n-ary relationships cor
5.4 mapping unary relationships, and specialization_generalization
5.5 mapping categories and shared sub classes
Chapter 6
Expand
Chapter 6
9 Topics
6.1 basic SQL intro
6.2 SELECT and WHERE clauses and examples
6.3 joins, sets and multisets and set operations
6.4 renaming, pattern matching
6.5 arithmetic op, BETWEEN, and ORDER BY
6.6 inserting
6.7 delete and update
6.8 relational algebra select and project
6.9 end of basic sql and relational algebra
Chapter 7
Expand
Chapter 7
6 Topics
7.1 intro to advanced SQL
7.2 correlated nested queries and joins
7.3 outer joins
7.4 other joins and aggregation
7.5 group by, having, assertion, and trigger
7.6 views
Chapter 8
Expand
Chapter 8
16 Topics
8.1 relational database design
8.2 guideline 1 and anomolies
8.3 guidelines 2 3 and 4
8.4 functional dependency
8.5 assumptions about functional dependencies
8.6 defining normalization
8.7 candidate keys and types of dependency
8.8 first and second normal forms
8.9 third normal form
8.10 normalization considering candidate keys
8.11 types of keys and third normal form considering candidate keys
8.12 BCNF intro
8.13 BCNF by decomposition
8.14 structuring decomposed relations
8.15 functional dependency closure
8.16 attribute closure and proving keys
Chapter 9
Expand
Chapter 9
3 Topics
9.1- intro to NOSQL and OODB
9.2- MONGODB and JSON
9.3- CRUD operations and extra info
252 midterm 1 solution
Expand
252 midterm 1 solution
5 Topics
question 1
question 2 part 1
question 2 part 2
question 2 part 3
question 3
handwritten slides
Expand
handwritten slides
1 Topic
all chapters
mapping erd to relational tutorial
Expand
mapping erd to relational tutorial
4 Topics
question 1
question 2
question 3
question 4
midterm 2 solution
Expand
midterm 2 solution
4 Topics
midterm 251 question 1 part 1
midterm 251 question 1 part 2
midterm 251 question 1 part 3
midterm 251 question 2
252 final stream
Expand
252 final stream
1 Topic
FINAL REVIEW
Previous Topic
Next Topic
3.1 intro to EERD, super and sub classes
⏱ 05:03
CS340: Introduction to Database Systems
499.00
اشترك الآن