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
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post database assignment2 1 appeared first on Custom Nursing Help.