1 answer

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.


Answers

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

Users Name tPK) firstName lastName nickname yearofBirth Posts O..n Uploads 1..1 Content PK) Comments Date Mentors City suburb name Profile job family tvProgram 1..n Video Title (PK) duration description fileType 0..1 Has 1..n IlInesses doctorName(PK) degree(1-5) condition duration Health Practioners doctorNamePK) address phoneNumber Treated by 1.n

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);

.

Similar Solved Questions

1 answer
5. What are the implications for failure to comply with CDC?
5. What are the implications for failure to comply with CDC?...
1 answer
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...
2 answers
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)#?...
1 answer
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...
1 answer
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 ...
1 answer
In our TLC system, which compound is more likely to be at the solvent front: 1 or 2. CH3CH2CH2CH=O CH3CH2CH2...
In our TLC system, which compound is more likely to be at the solvent front: 1 or 2. CH3CH2CH2CH=O CH3CH2CH2CH3...
2 answers
Which of the following accounts would be closed out with a debit?
a.Salesb. Sales Returns and Allowancesc. Cost of Goods Soldd. Operating Expensese. Sales Discounts...
1 answer
Che Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot...
Che Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit: selected balance sheet amounts at December 31, 2016, were inventory, $55,900; total assets, $249,400; common stock, $80,000, and retained e...
2 answers
Generally how does a male animal realize that the female is receptive to copulation?
Generally how does a male animal realize that the female is receptive to copulation?...
1 answer
You are pulling on a rope attached to the outer radius of a pulley with a...
You are pulling on a rope attached to the outer radius of a pulley with a moment of inertia I = 3.3 kg middot m^2 as shown. The tension force of you on the pulley is. A pack of mass 25.5 is attached to the pulley's inner radius as shown. If the inner radius of the pulley is 0.44 m and the outer ...
1 answer
A. What is its after-tax operation income (NOPAT)? b. What is its free cash flow?
a. What is its after-tax operation income (NOPAT)? b. What is its free cash flow? Fiesta Co. Ltd's income statement is given below: 15,000,000 6,000,000 9,000,000 4,000,000 5,000,000 1,500,000 3,500,000 1,400,000 2,100,000 Sales Operating costs excluding D&A EBITDA D&A EBIT Interest EBT ...
1 answer
An electromagnet consists of an iron core with an air gap as shown below. The core...
An electromagnet consists of an iron core with an air gap as shown below. The core is square shaped with a side length of and has a relative permeability of and a cross-sectional area of A. The air gap has a length of , and = ( - )/2. The coil has N turns. Derive a formula for the magnitude of th...
1 answer
A) Address one of the posts (#1,#2 below) by identifying which of the nursing interventions listed...
A) Address one of the posts (#1,#2 below) by identifying which of the nursing interventions listed would be the most effective. B) Please provide a rationale for your assessment of their interventions. #1) Identify clients likely to fall by placing a “fall precaution” sign on the doorway...
1 answer
KIMP Hotel has an expected return on equity of 15% and an after-tax cost of debt...
KIMP Hotel has an expected return on equity of 15% and an after-tax cost of debt of 6%. What debt-equity ratio (i.e., D/E) can produce a WACC of 12%? 0.50 0.67 0.75 0.33...
1 answer
Find the compound methylene chloride on the internet. a) Why do you think the name starts...
Find the compound methylene chloride on the internet. a) Why do you think the name starts with the prefix “meth”? How does it relate to the structure of the compound? b) List any other names you found for methylene chloride c) What are the similarities between the names? d) Methylene chl...
1 answer
The first answer is correct, I just don't know how to get the second part. Please...
The first answer is correct, I just don't know how to get the second part. Please help me Suppose the maximum safe average intensity of microwaves for human exposure is taken to be 2.00 W/m^2. If a radar unit leaks 10.0 W of microwaves (other than those sent by its antenna) uniformly in all dire...
1 answer
College Coasters is a San Diego–based merchandiser specializing in logo-adorned drink coasters. The company reported the...
College Coasters is a San Diego–based merchandiser specializing in logo-adorned drink coasters. The company reported the following balances in its unadjusted trial balance at December 1. Cash $ 9,800 Accounts Receivable 1,900 Inventory 500 Prepaid Rent 540 Equipment 660 Acc...
1 answer
A 17.0 kg monkey hangs from a cord suspended from the ceiling of an elevator. The cord can withstand a tension of 220 N and breaks as the elevator accelerates. What was the elevator minimum acceleration (magnitude and direction)?
A 17.0 kg monkey hangs from a cord suspended from the ceiling of an elevator. The cord can withstand a tension of 220 N and breaks as the elevator accelerates. What was the elevator minimum acceleration (magnitude and direction)?...