Film, Media & TV0 min ago
DBA
1 Answers
As a DBA, one of the responsibilities is to detemine the proper placement of fields as well as defines data relationships.
use a relational database model to design a database for a school to keep track of student records.
for the answer, you have to create at least 3 tables with some data and you must show the relationalship between different tables.
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by nanna. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Three tables could be Students (holding StudentID, firstname, lastname, TutorID), Tutors (holding TutorID, Firstname, Lastname, ClassroomID) and Classrooms (holding ClassroomID, ClassroomCode and ClassroomLocation).
Relationship between Students and Tutors would be many-to-one based on TutorID and the relationship between Tutors and Classrooms would be one-to-one (if the tutor only taught in one classroom) based on ClassroomID.
As for the data, make it up!
Only 1 answer
