# Can someone please make a relational model and an ER diagram for the following scenario. P.s...

###### 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.

#### Similar Solved Questions

##### 5. What are the implications for failure to comply with CDC?
5. What are the implications for failure to comply with CDC?...
##### Who is FDA and what role does this organization have with regards to medications? Phases of...
Who is FDA and what role does this organization have with regards to medications? Phases of drug development Phase 1 Phase 2 Phase 3 Post Phase 3 Phase 4...
##### How do you use the quotient rule to differentiate y=(2x^4-3x)/(4x-1)?
How do you use the quotient rule to differentiate y=(2x^4-3x)/(4x-1)?...
##### Just need letter A and C done. Thank you!! 9.76 An important quality characteristic used by...
Just need letter A and C done. Thank you!! 9.76 An important quality characteristic used by the manufac- turer of Boston and Vermont asphalt shingles is the amount of moisture the shingles contain when they are packaged. Customers may feel that they have purchased a product lacking in quality if the...
##### Please answer both of the following questions. A perfectly competitive firm is maximizing profits in the...
Please answer both of the following questions. A perfectly competitive firm is maximizing profits in the short run. This implies that the firm is earning the most economic profits possible, which o can be positive, negative, or zero. O exist at the point at which price equals total cost. O must be ...