This information needs to be done in visio, I will attach a document that the layout of the boxes need to be the same way with connectors.

You are starting to be able to build your database, which is usually half the battle. The other half is getting people to use it (and use it correctly). Generally, it is the fault of the user but us being the great technologist that we are, need to find a way to fool proof our system a bit more. That way it is even more their fault than ours 😊. So how do we do this? Documentation.

Right now, you have a relatively well created set of tables in your schema. We need make sure that others can easily navigate your schema. A common industry product for doing this is Visio. There are countless others (and I mean countless). But generally, if you are using a windows system at work, you can almost count on most users being somewhat comfortable seeing Visio Diagrams.

Your diagram should consist of the following –

-Tables

-Primary Keys

-Foreign Keys

-Cardinality – 1:1, 1:M, M:N – Please use Chen style – https://www.smartdraw.com/entity-relationship-diagram/

To get you started, please find the attached Visio document and build off of that.

COURSE	FACULTY	LOCATION	SECTION	STUDENT
CourseNumber CreditHours CourseID Description CourseName Status	Experience WorkPhone Status FacultyID HomePhone Email MI FirstName Zip LastName Address City State	PIN City Building Room State Address Status LocationID Capacity Zip	EndTime Days SeatsAvailable Status SectionID CourseID SectionNumber StartTime LocationID	StudentID DOB LastName Rank WorkPhone Status FirstName MI CellPhone Address City State Zip