Given these words:
Student, Teacher, Course, Enrollment, Major, Minor
Your task is to:
Create a well-formed DM using the information above to assist you.
If the word is entity, then you can add appropriate attributes to it
otherwise it could be used as an attribute.
If your design establishes a weak entity, then you can add appropriate attributes to it
Goal:
This exercise is intended to give you practice in forming DMs for a small database. You should take the time to look at each entity, attribute,
relationship and identifier confirming that they are syntactically correct and that they mean what you want them to mean.
Grading Criteria:
·Neat, well-formed design, sensible decisions and assumption
·Drop a soft copy of your work
NOTE:
A. you need to draw the diagram using Visio or Lucid chart.
B. Make sure to state your assumptions very clearly for me to understand how you are viewing the design
C. Well-formed design
1) All entity name should be unique
2) All entity name should be singular
3) All entity name should be meaningful
4) Every entity should have identifier/primary key. Identifier could be single attribute or composite attributes
5) All attribute within one entity should have a unique name
6) All attribute within one entity should have a meaningful name
7) All attribute names should be singular
8) All attribute names should not be calculable
9) All attribute names should not be aggregate name (Address is an aggregate name. it should be broken down to street address, city,
state, and zip code)
10) Relationship between two entities should be many-many. It should be one-one or many-one
11) More than one relationship between two entities should have label