- Видео 12
- Просмотров 205 742
Sarita Ambadekar
Индия
Добавлен 19 фев 2018
DBMS SQL SELECT commands -Part-3
In this video, you can learn various ways to retrieve data from select command. Lile conditions, operators, key words etc.
#dbms #education #computerscience
#dbms #education #computerscience
Просмотров: 30
Видео
DBMS SQL- DML & DCL commands Part-2
Просмотров 102Месяц назад
In this video lecture you can study all Data Manipulation commands and Data Control language commands with examples.#education #dbms #computerscience
DBMS SQL- DDL commands, integrity constraints Part-1
Просмотров 256Месяц назад
In this video you can study DDL commands, MySQL data types , integrity constraints#dbms #computerscience
DBMS - Relational Algebra oprations
Просмотров 2134 месяца назад
This video explain all Relational Algebra operations under various categories. Unary Relational Operations SELECT ( (sigma)) PROJECT ( (pi)) RENAME ( (rho)) Relational Algebra Operations From Set Theory UNION ( ), INTERSECTION ( ), DIFFERENCE(- ) CARTESIAN PRODUCT ( x ) Binary Relational Operations JOIN (Natural join, equi join) DIVISION Additional Relational Operations OUTER JOINS AGG...
DBMS architecture and DBA
Просмотров 1164 месяца назад
Complete DBMS architecture , Database administrator and DBA functions
DBMS: Mapping of EER to Relational model
Просмотров 8425 месяцев назад
This video explain about how to convert EER model to relational model. ie. specialization/ generalization , union to relational schema.
Mapping ER model to relational model
Просмотров 3205 месяцев назад
This video contains , Case study, problem statement, ER diagram and mapping. Seven steps in detail of mapping of ER model to relational model.
DBMS: Introduction of Database concepts : part3
Просмотров 925 месяцев назад
This video contains following topics Data Abstraction, Data independence & Database application Architecture #dbms #education #computerscience
DBMS: Introduction of database concepts part2
Просмотров 855 месяцев назад
In this video I have covered topics like File system, Database system characteristics and File system vs database system.#dbms #dbmstutorials
DBMS: Introduction of database concepts part 1
Просмотров 1145 месяцев назад
In this video, you can study basic concepts and applications of database system.#dbms #education
DBMS: Entity Relationship Data Model
Просмотров 3125 месяцев назад
This video explains notations used in ER diagram.#dbms #dbmstutorials
DBMS: How to draw ER diagram & Relational schema eg. company database
Просмотров 203 тыс.6 лет назад
This video explains how to draw ER diagram for company database and mapping to the Relational Schema.#dbms
how to map inheritance (tree structure) ?
but mam,in the 8c method , the super class already has a attribute that is "jobtype".....then how did you add the "job type" as a type attribute in the scema....
The type (or discriminating) attribute whose value indicates the subclass to which each tuple belongs. This option works only for a specialization whose subclasses are disjoint. In this example job_type is also the attribute of superclass. So the same you can use as a flag attribute For example if the Bank Account is of two types 1. Saving Account & 2. Current Account ; so in this case you can use aacount_type as a type attribute.
🙏 'PromoSM'