Untitled document (14)

please note (The diagram should adhere to compressed Chen notation) overview:a website about the cutest pet competition. a person registers on the website and then decides to be either a voter or has a competing pet. If he registers as a competitor, he creates a profile for his pet, then chooses to classify his pet, whether it is a dog or a cat, and then displays pictures of his pet on the website to people. If he registered as a voter, he enters the site and then chooses the classification, dog or cat. After choosing, pictures of competing pets are shown to him, and he chooses the cutest and gives it a like as he can also write a comment in the comment section of that picture . after that, when the competition ends you can see the leaderboards page to see the best pets scores Do the following ER Diagram please : The model should be relevant and appropriate in the context of the specification. The diagram should adhere to compressed Chen notation and should give data types for the…

Schema  Patient (patientNo, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noOfBeds) Contains (patientNo, wardNo, admissionDate) Drug (drugNo, drugName, costPerUnit) Prescribed (patient No, drugNo, unitsPerDay, startDate, finishDate) List the detailed information about drugs that have been prescribed more than 100 times since  the year 2014. Create a view of all patient details (patient, ward, drugs) for all patients who are 70 years old or older, excluding ward number and number of beds.

Q_5

Before I deliver my PowerPoint presentation to my professor, please double-check all of my references and APA citations.

Do what is asked