Skip to content

CS340: Introduction to Database Systems

التجربة المجانية Sample Lesson

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

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+

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

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

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

Q1 part 2 and 3

Q1 part 4 and 5

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

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.7 delete and update

6.8 relational algebra select and project

6.9 end of basic sql and relational algebra

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

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

9.1- intro to NOSQL and OODB

9.2- MONGODB and JSON

9.3- CRUD operations and extra info

252 midterm 1 solution

question 2 part 1

question 2 part 2

question 2 part 3

handwritten slides

mapping erd to relational tutorial

midterm 2 solution

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

Previous Lesson

1.1 what will you learn in this course

⏱ 05:07

CS340: Introduction to Database Systems 499.00

اشترك الآن