Database Design Process

DBMS: Database Design Process
Topics discussed:
1. Overview of the database design process
a. Requirements Collection & Analysis.
b. Functional Requirements.
c. Conceptual Design.
d. Logical Design/Data Model Mapping.
e. Physical Design.
2. Weak Entity Types.
3. Symbols used in ER Diagram.
4. Sample Database Application (COMPANY).
5. Initial Conceptual Design of COMPANY Database.
Follow Neso Academy on Instagram: @nesoacademy(bit.ly/2XP63OE)
Contribute: www.nesoacademy.org/donate
Memberships: bit.ly/2U7YSPI
Books: www.nesoacademy.org/recommende...
Website ► www.nesoacademy.org/
Forum ► forum.nesoacademy.org/
Facebook ► goo.gl/Nt0PmB
Twitter ► / nesoacademy
Music:
Axol x Alex Skrindo - You [NCS Release]
#DBMSByNeso #DBMS #DatabaseDesignProcess

[@gabrielorville5334]

This was good in that it provided an example to contextualize the information, but I found I could use more of it regarding the descriptions of the Design Process and, in explaining Entity Types both text and their symbols should be used. Please keep the Data Base content coming.

[@oluwaseunolusola4155]

God bless you for this explanation!

[@sripravallika2428]

Please post the remaining videos I'm preparing for exams by seeing ur videos daily

[@quorawilliams1850]

great vid i will put this word for word in my powerpoints along with bbc bitesize

[@dhaneshpt8641]

Great work.. Thank you..

[@Maria_farah]

thankfull for this lecture.

[@sdvvoraman5919]

Hi neso I really love your channel actually i learn c programming from your channel is make understand more than my class in my university and other thing I have to say is your slide demonstrates in videos is perfect is make comfortable with that. But i have suggestions if in the future hope u make Python course bcow I want to learn that course and I think if u make that course I think is really good bcoz your demonstrate videos is really awesome 👌 I found many channel python course too but some of them I don't like style of teachings but for me I like your style teaching that why I suggest u if u can make that course. Good luck

[@listen_learn_tz]

nice loud and clear :)

[@MeghanayadavU]

Thank u mam/ sir it is very helpful for me 😊

[@Benedict_Miriti]

Quite informative really! Not all heroes wear capes.

[@sachinsudaraka6397]

Thank you...

[@agbovic]

Today's exams at 2pm😂😂😂😂

[@makara2711]

Just hundreds of more videos to go and Neso will be on its way to compete with Khan Academy :D That's a long way though, unless they really boost their uploads ;)

[@premshahu9321]

Nicely explained plzz upload compleye dbms course

[@astonmargolis4391]

thank you!

[@rforrana12]

Thank you

[@danielamare2685]

subscribed!!!!!

[@nicolas5540]

great video! thanks!!

[@tGoldenPhoenix]

Thanks.

[@viciwo3396]

thanks!

[@jacobcollins4140]

Great

[@mariamawitworku9521]

Tnxs soooo much

[@zulekha8809]

When will you complete full dbms course

[@sumitnegit]

2022

[@LearnWithBahman]

Link of the course ?

[@rnjnmhta.catomato]

6:38 company database

[@WorldTop-rl3py]

nice

[@Tkdanso]

Y’all need python playlist please and artificial intelligence data science.

[@biscotto]

I must be misunderstanding. You stated that during the logical design phase you start the implementation of your database, but from what I have read (Connolly & Begg, 2016) this part is still independent of physical implementation.

[@amanta6675]

Yes, it is independent. This phase simply transforms a high level data model to an implementation data model.

[@vahepanch1737]

Hello. What does it mean a decentralized database? Does it mean all the computers of the network are not connected to one server and all the info is stored within that computers? I need to design a decentralized DBMS, but don`t know from where to start. Thanks!

[@dancinglazer1628]

Decentralization is a rabbit hole in it's own right, would be unfair to say a decentralized database is just another database. We are more specifically referring to a distributed database system that through chunking and paging distrubutes the load of performing CRUD equally among the machines used within the system

[@asifuzzamanbappy1297]

hello, a quick question, how is "DEPENDENT" aka "Weak Entity" is going to be uniquely identified by "EMPLOYEE" entity, from given example in this video? thanks

[@karunyareddy1458]

Firstly DEPENDENT is a Weak Entity because none of its attributes can uniquely identify a dependent uniquely there we know that dependent is always associated with an employee and we can uniquely identify an employee therefore using an attribute from employee (i.e SSN) we can uniquely identify a dependent.

[@zulekha8809]

Provide full vidoe

[@Salma_xx]

8:40 diagram

[@continnum6540]

❤❤❤

[@Winning_shorts_]

✅

[@AnkitaSubedi-xp8up]

"khampani"

[@poojapoojadhapte1430]

Today 2pm exams

[@aurangdivya296]

Same

[@abusufiankayal682]

Your got a fake accent 😂😂

[@chandrashekar316]

Please use gender instead of sex fr god's sake

[@marvhartigan3677]

don't use this channel then

[@espio3364]

How about you change your thoughts and grow up

[@wayln2591]

Bruh shut up. Get your mind out of the gutter.

[@chandrashekar316]

@@marvhartigan3677 lmaoo alright

[@chandrashekar316]

hahaha okay