Structured Query Language (SQL)

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.