Mwendwa Posted January 17, 2023 Share Posted January 17, 2023 Hello, I am Michael. I am teaching myself mysql and php. I need assistance to create a school database. Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/ Share on other sites More sharing options...
requinix Posted January 17, 2023 Share Posted January 17, 2023 Step 1: What actual data do you need to store, and what are the relationships between the different pieces? Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/#findComment-1604748 Share on other sites More sharing options...
Mwendwa Posted January 17, 2023 Author Share Posted January 17, 2023 I need to record student details, teachers details, be able to generate exam report card, teachers to only enter marks for subject they teach only. I need advise on which tables to create and how they would relate. Given for example, a class can have many students but a student can only belong to one class, a student can take many subjects and a subject is enrolled by many students, a teacher can teach many subjects but a subject is taught by one teacher. Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/#findComment-1604754 Share on other sites More sharing options...
Solution Barand Posted January 17, 2023 Solution Share Posted January 17, 2023 The SQL tutorial link in my signature may help to get you started. Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/#findComment-1604757 Share on other sites More sharing options...
Mwendwa Posted January 17, 2023 Author Share Posted January 17, 2023 Thank you Sir for you assistance. Now how do I prepare its fronted side, such that I would be entering data and retrieving it from HTML side? Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/#findComment-1604775 Share on other sites More sharing options...
Barand Posted January 17, 2023 Share Posted January 17, 2023 I'd have to write a book to answer that question. Quote Link to comment https://forums.phpfreaks.com/topic/315809-school-database/#findComment-1604776 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.