• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1656
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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