Тёмный

Creating Logical models using SQL Developer Data Modeler 

BHARAT KHANNA
Подписаться 622
Просмотров 82 тыс.
50% 1

In this video, I will show you how to create Logical, Relational and Physical Model using Oracle SQL Developer Data Modeler with ER diagram as input. I will also show you how to create sub/super-types .

Опубликовано:

 

15 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 32   
@marekmaly5610
@marekmaly5610 7 лет назад
Thank you very much! Very helpful. Greetings from Prague (Czech Republic). Not easy to find similar video on youtube. Great job :)
@ezequielghione6423
@ezequielghione6423 8 лет назад
The best tutorial I found after couple of hours of research.
@sd568
@sd568 8 лет назад
Very nice video. Thank you for your super review of Oracle Data Modeler. Very helpful!
@PabloMore
@PabloMore 7 лет назад
Great walk thru presentation, thank you very much.
@user-jp1xs3wm3d
@user-jp1xs3wm3d Год назад
Дякую тобі ти єдиний ,хто це зміг пояснити я думав ,що то тільки в польських вузах таку фігню вчать . МУЖИИИК!!!
@cj.marecek
@cj.marecek 8 лет назад
thanks a lot for this video I have a test tomorrow from this and it really helped. I can just suggest to continue with this series and add that transaction relation which you didn't as well as you could show how to add records or write into DDL script how to add or delete attributes or even records.. :)
@sturanovicms
@sturanovicms 6 лет назад
you are a legend! thank you sooo much. I didn`t understand this at all until now !
@mahenderdbaaccount5081
@mahenderdbaaccount5081 5 лет назад
Data modeling
@JD-xd3xp
@JD-xd3xp 5 лет назад
very helpful & informative, good job. if you can do end to end, that will be great.
@jagadeeshdora5987
@jagadeeshdora5987 3 года назад
I have more than 100 tables so how to select all entities and resize it in logical data model? And is thr any option to split the pages like 1, 2, 3 etc.
@Mohamed-uf5jh
@Mohamed-uf5jh 7 лет назад
Thank you, Very helpful, good explain
@user-pi7cm4xt8c
@user-pi7cm4xt8c Год назад
Hii, I think when you are choosing the "optional" for source and target sides for building relationship. you chose it wrongly, should be opposite based on your assumption( for example the relationship between customer and account). Just a kind reminder. Correct me if i'm wrong :)
@patrickmeakins4449
@patrickmeakins4449 8 лет назад
Fantastic, good work...
@BHARATKHANNA
@BHARATKHANNA 8 лет назад
Thanks Simon for your comment and suggestion, I shall surely add some more content to it in upcoming videos.
@pavelwolfovichpetliura7169
@pavelwolfovichpetliura7169 7 лет назад
Can i generate database code from this diagram in DataModeler?
@cuba2401
@cuba2401 8 лет назад
thanks for video!!
@barringtonmorris90
@barringtonmorris90 6 лет назад
Thank you! Great job.
@studentaccount5430
@studentaccount5430 8 лет назад
Thanks for the tutorial.
@ruben7346
@ruben7346 3 года назад
Thank you very much!
@roastytoasty8815
@roastytoasty8815 3 года назад
THANK YOU THANK YOU THANK YOU!!!
@fabricejoeythibaut8534
@fabricejoeythibaut8534 17 дней назад
How to create the physical data model on Oracle data modeler?Also where is the part for physical model?
@skyasterism
@skyasterism 8 лет назад
you saved a day. tx.
@gerardosilver3524
@gerardosilver3524 7 лет назад
Such a great tutorial really appreciated, just got one question, what is the right setting on data type for the identifier? thanks in advance.
@jessicasnowden351
@jessicasnowden351 5 лет назад
This is so good
@rajeshmanivannan5313
@rajeshmanivannan5313 2 года назад
Thank you so much for making this video, this is very clear and easy to understand. I'm new to oracle sql developer data modeler tool - I have one clarification here - When I create subtype and supertype as shown in this video in the logical model, after selecting the accounts as supertype I'm not getting that line between accounts and checking_account. Also between accounts and savings_account. I'm using oracle data modeler v21.4. Instead of line, I could see the checking_account entity and savings_account entity inside accounts entity in the logical model. Is this normal in this version? please advise. When I converted logical model to physical, I could see subtype and supertype as shown in the this video without any issues.
@rajeshmanivannan5313
@rajeshmanivannan5313 2 года назад
Okay..I found the resolution - In the logical model, by going to notation unchecked "Box in box presentation", by doing that I could see the line between subtype and supertype entity
@abdallahalmawajdeh716
@abdallahalmawajdeh716 8 лет назад
Thank you, Very helpful, I have a a question please, when i try to get the relational model of a many to many relationship (Engineer to relational model)like a course-student relationship in your video, SQL Developer doesn't delete the original relationship like in your video, it keeps the many to may relationship and create the intersection table ?! I am using SQL Developer4.1.3.20,
@rajeshmanivannan5313
@rajeshmanivannan5313 2 года назад
I have one question - In the same data model file if I want to create multiple relational model by reusing the existing tables, is that possible to create separate workspace for each relational model ? Please advise
4 года назад
Thanks! :-D
@roudiolding8023
@roudiolding8023 Год назад
Muchas gracias señor, estamos agradecidos. ¿Precio?
@joseluisbernalzambrano8906
@joseluisbernalzambrano8906 7 лет назад
Do you know how to implement Composite Primary Key? stackoverflow.com/questions/1350990/how-to-add-composite-primary-key-to-table
@mt.everest5587
@mt.everest5587 3 года назад
one of the worse..... just like passing the times
Далее
SQL Developer Data Modeler  Just what you need
1:03:20
Просмотров 40 тыс.
Conceptual, Logical & Physical Data Models
13:45
Просмотров 473 тыс.
Creating graphical interface using Oracle Forms
9:29
Reverse Engineering
13:57
Просмотров 4,6 тыс.
Oracle SQL Developer: You're Doing it Wrong
17:12
Просмотров 59 тыс.