Modified Design Summary
Mark Bone
CIS 111
Brain Smith
Strayer University
October, 29 2017
Modified Design Summary
Database design
The case study required the following dimensions to be catered.
· Record of students with more details
· Record of courses
· Record of teachers with more details
· Record of teachers taking specific courses
· Record of teachers eligible to teach a course
· Record of students taking what courses and by what teachers
For the above-mentioned requirements, I have developed the attached database diagram which consists of the following entities to cater the business needs.
· Student table
· Teacher table
· Course table
· Student-Course-Teacher table
· Course-Teacher table
· Qualification table
The above-mentioned list of tables caters all the data storage requirements of the case study put forward, and it uniquely identifies each attribute tuple to be stored in the database through their ID’s and other identifiers.
Till now, according to the case study, all the data is being captured and the database is well suited to answer every question to be put forward in the respective domain. The database is now complete and shall only need amendments if further requirements are to be fulfilled which were not listed before.
Assumptions and Dependencies
The database requirements were quite simplified so there was no need of any assumptions or dependencies to be taken.