I am designing my first database for my mother’s daycare business. I liked the idea of separating the Orders from the Products, but I don’t know if I that’s how I should create the classes in my database. I have a table with classID and location and capacity. Then I have a Student Table and a Teacher Table. Right now I have tacked on to each the Student and Teacher tables a field called ClassID where you can plug in the ClassID to which they belong at the moment. But then That personID can either be a TeacherID or a StudentID so that the table would reflect every person tied to that particular class. I’m double thinking my design.

--

--

--

Writer. Speaker. Entrepreneur I am a diarist and write story to reflect my thoughts.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Akshay Prasad

Akshay Prasad

Writer. Speaker. Entrepreneur I am a diarist and write story to reflect my thoughts.

More from Medium

How many push-ups before you get a good one

What is a fun way to learn multiplication tables?

OVERCOMING MY FAILURES

5 Qualities the Best People in the GoHighlevel Review Industry Tend to Have