I have been given the task of designing a database for a volutery organsiation and i have been give the following information as basis to design the database.The following information below is example of a paper record
Services provided by volunteer
05 Wheel Chair pushing
09 Baby sitting
client no client name date required hours required service code
004 Lee Wong 19/01/08 2 01
004 Lee Wong 02/02/08 1 05
006 Sara Plat 04/02/08 3 09
007 Jay Palin 04/02/08 05
Assume also that additional details are kept for clients, including address, telephone numbers and next of kin. Clients who have pets have information stored on these as well (pet number, pet name, and description). Clients who have children and require baby sitting have the following information: child number, name, date of birth, sex.
Can anyone help me produce an Entity-Relationship diagram for this organsiation
secondly convert that ER daigram into relational model by specifying the primary and foreign keys, mapping any one-to-one relationships into relations, and decomposing any many-to-many relationships
A relation diagram and ERD diagram for the above organization
To be honest with ya'all i dont know where to start can someone guide me to enlightment by making a relation diagram and ERD diagram for the above organisation
I really appreciate you help and will be grateful for any help.