Hey guys am in real need of help here i need to create a single Entity-Relationship diagram for the following:
StaffNo
Staff_Start_Date
First_Name
Last_Name
DOB
Home_Address
Home_Tel
MobileNo
WorkNo
Gender
NatInsNo
Staff_Salary
Course_Name
CourseNo
Course_Start
Course_End
Staff_ID, First_Name, Surname, DOB, Address, Tel, Mobile_No, Work_No, Gender, National_Insurance, Salary,(CourseNo, Course_Name, Course_Start, Course_End))
Personal = (StaffID, First_Name, Last_Name, DOB, Address, Tel, Mobile, Gender, NatInsNo)
Contact = (First_Name, Last_Name, Address, Tel, Mobile,)
Course = (CourseNo, Course_Name, Course_Start, Course_End)
Salary = (NatInsNo, First_Name, Last_Name, Address)
To simplify the diagram, it says only show entities, relationships, primary and foreign key attributes,Identify the main relationships between entities described in part represent each relationship in your ER diagram, clearly labelling each relationship.State the degree of each of the relationships described in part Decompose any many to many relationships, replacing them with new entity types and relationships
i just don't know were to start though
any help would be great
