• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1663
  • Last Modified:

database Normalization

Hello everyone,

I am working in my final project module. The project will be a self support  Web site, the target is to let the students enquiry about a location, a room or theater for instance, within a campus or about a particular person, such as a lecturer, tutor or a dean as well. in case the student could not be able to find the answer, he will send an email to a person that he think will help...

any way, my question is: is the Entity Relational diagram in the attachments is a full normailzed, in other word, do you think any of the 1st, 2nd or 3ed normal form has been violated.

if yes, could help.
if no, any more suggestions.

Thanks,
coDev
ERD.jpg
0
CoDEV
Asked:
CoDEV
  • 4
  • 4
1 Solution
 
Steve BinkCommented:
That looks proper to me.  Did you have a specific area you wanted to ask about?
0
 
CoDEVAuthor Commented:
is the relation between the entities 'modules' and 'staff' correct. it would be possible to have a teacher that teach more than one module and a module that has more than one teacher, thus, the relation is 'many to many', to solve this issue i added a new entity and called it module_staff. is this process solve the problem?  is there a problem if i made it many to many relationship?

thanks
0
 
Steve BinkCommented:
That is the correct way to resolve the issue.  Many-to-many relationships are generally described by two one-to-many relationships with a middle-man table, so to speak.  Modules_Staff suits that purpose, and does not break any forms that I am of aware of.  The semantics for the relationships look backwards on the picture, but you have the right idea.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
CoDEVAuthor Commented:
Backwords???
What do we mean if we say a relationship look backword? I mean technically...
0
 
Steve BinkCommented:
I mean the relationship between Modules and Modules_Staff, for example, is a one-to-many.  The connecting line between them shows the 'many' side of the relationship on the Modules table instead of Modules_Staff.
0
 
CoDEVAuthor Commented:
Ok, I  got it now. I changed the relationship between both modules and staff with module_staff.
Could you check the changes I made, please?

Thanks a lot, :0)
ERD.jpg
0
 
Steve BinkCommented:
That looks fine to me.  Good structure.
0
 
CoDEVAuthor Commented:
Thanks mate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now