DBA

[nanna]

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.

[OBonio]

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!