Entity-Relationship Diagrams: Simple student registration system example

In this example, I show how to create an entity-relationship diagram for a simple student registration system
This playlist is used in two of my books:
1. Introduction to Information Systems
Contents: app.myeducator...
Purchase: app.myeducator...
2. Data-Mining Projects and Database Essentials
Contents: app.myeducator...
Purchase: app.myeducator...
To request an instructor copy, email me at [e-mail]

[@novahunicorn1817]

God Bless. You made me a better engineer

[@luqmanooo5402]

what engineer?

[@notahamster333]

Data Engineer, I guess. If there is even such a thing...

[@Deiadara]

@@notahamster333 software, computer, cyber secuirty engineers etc need basic database knowledge and have it in their curriculum, you dont need to be a 'data engineer' to know how to use SQL, set up a database for your site, avoid sql injections etc. And ER diagrams are the foundation of all of these

[@loriculberson7886]

This is the video I will tell all of my bootcamp students to watch! Great job!

[@darylcheung2027]

Thanks for making everything clear. Love your video, keep it up!!

[@MarkKeith]

Thanks!

[@danielbelesm]

thank you for the video. It is simple and understandable.

[@AliTaj5610]

Great example, easy to understand...Thank you!

[@puneetpatel3305]

Amazing video, thanks Just one thing I'd point out - the student would be able to register for 2 sections of the same course, something we wouldnt want

[@mosesnandi]

This was amazing! The Excel example made it super clear! What if you needed to show grades and their progress over the years?

[@mademoisellechoko]

You make awesome videos!

[@Bleu-en2bf]

Excellent. Thank you! 👍

[@londekamsani1726]

Easy to understand thank you. But how do you create a work breakdown structure for a student registration system?

[@katharinerubin812]

What if you wanted to add a 'department' class. For example, instructors teach under a particular department and departments offer certain courses. Could you simply add that class and connect it to course and instructors?

[@MarkKeith]

Good question...well, it depends on what rules you want to follow. For example, can an instructor teach in multiple departments? If you want to just keep things simple, I would connect the department class to "Course" since a course is likely to below to only one department. Then you have a simple one-to-many from department to course. Depending on what rules you need to follow, you could also connect department to the instructor class. But, then you need to find out if instructors are allowed to belong to multiple departments. If not, then it's just another one-to-many from department to course. If they are, then you'll need another one of those "association classes" or "linking tables" (whatever your instructor wants to call it) between department and instructor. Good luck!

[@Forestlincoln]

wow! awesome er diagram. what's the name of the app you use to draw the er diagram?

[@MarkKeith]

Lucidchart.com

[@Engycation]

Nice video of ERD

[@clentargerototing7318]

why is that other ERD are like flowchart? is it the same as you did? because your ERD is table to table... thanks by the way.

[@jacobnotte3699]

Thank you!

[@hellwalker8602]

wont it be 1 to many in case of registration to section

[@tyanthem3966]

Awesome video! Can anyone explain the number row please?

[@madhumithaelango1460]

Thanks for explaining. I have doubt .. what if the student register for the same student register for the same section twice ? like student Mickey can get registered to the Section 1 for 2 time by mistake . will it not create a redundancy ? I am just confused..

[@MarkKeith]

That’s true; it all depends on the rules you want to enforce and whether the DBMS will allow that or not.

[@subinivi]

could please show the normalisation for this tables

[@wesleybarnes5376]

Thanks for this, would you say this is a conceptual, logical or physical model?

[@abimbolasheriff454]

Logical ERD

[@AllInOne-ro4vb]

Hi,I want ER diagram of smart hackathon systems

[@aseelba5166]

I need a program like this to design a blueprint related to the stages of student registration at the university. Can you give me the name of this program or something similar, please?

[@MarkKeith]

Yep, this is lucidchart.com. I like it because you can also export the SQL CREATE scripts to generate the database. Many programs will do that though

[@aseelba5166]

@@MarkKeith Thanks u 🤍

[@cookieusmc]

Mark what program are you using for this database

[@MarkKeith]

I’m using lucidchart.com to generate the diagram

[@fitfirst4468]

you using full premium Luchid chart ?

[@MarkKeith]

No, just the free education account

[@neon256]

What does pk stands for?,

[@MarkKeith]

Primary key - the unique identifier of teach row in the table

[@bizimunguantoine9752]

hello my dear! l want you to help me for making ERD and Physical model of student report management system and student displine.thanks

[@hythamhussein-o1f]

is this example normalized

[@MarkKeith]

Mostly, but not completely. I probably could have removed classroom and date/time into their own tables. There are 5ish or so normal forms and usually we find a balance between not normal and fully normal. Generally speaking, most would say this example is “normalized”

[@মজানেও]

software name

[@ZenAzou]

It's a website. google Lucidchart

[@Rendon_Official]

@@ZenAzou THANK YOU MA FRIEND .

[@joeysfather2723]

The stupid "professor" won't help....KZbin to the rescue