Question

can someone please make a relational model and an ER diagram for the following scenario. P.s last person who made it, i couldnt read the words. I NEED IT AS SOON AS POSSIBLE PLEASE.

Lets first start with the scenario, users register into the system and shares his some information as mentioned in the que. Some more information about themselves in their profile: what sort of job they do, something about their family, and what they like to watch on TV.  they can also upload one videointroducing themselves, which will be stored on the system at a specific location. They should include the video title and a description. The system will also record the duration of the video. The filetype must be either AVI, MOV, MP4, WMV or FLV.

they are invited to share about their illness(es): they choose their condition from a pre-defined set ofillnesses, noting how long they have experienced the illness and to what degree (using a 5-point scale, 1 being low and 5 being extreme).

For each illness, they also indicate whichhealth practitioner they are seeing on a regular basis and must provide the practitioners contact information (name, physical address, up to three contact phone numbers). Health practitioners can be doctors, physiotherapists or dieticians.

Users can also write posts on a message board within the system. When users post a message, the content, date and time of the message is also recorded.

Now we will design the ERD for the system, in this the entity types: Users, Videos, Health practitioners, Illnesses and Posts.

Answer 1

If you have any doubts, please give me comment...

Users(Name, firstName, lastName, nickName, yearofBirth, City, suburb,name, Profile, job, family, tvProgram, MentorName, PostContent);

Posts(Content, Comments, Date);

illnesses(doctorName, degree, condition, duration);

Video(Title, duration, description, fileType);

HealthPractioners(doctorName, address, phoneNumber);

UsersHasIllnesses(UserName, doctorName, VideoTitle);