Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A zoom user has a name, and a zoomid. Zoom users are unique by their zoomid. A zoom meeting has a meetingid, a passcode, meetingname,

image text in transcribed
image text in transcribed
A zoom user has a name, and a zoomid. Zoom users are unique by their zoomid. A zoom meeting has a meetingid, a passcode, meetingname, and number of attendees which can be calculated. Meetings are unique by meetingid Users attend zoom meetings. A user doesn't have to attend any zoom meeting, and may attend many. A zoom meeting doesn't have to have any attendees, but may have multiple people attending. Users also host a zoom meeting. A zoom meeting must have a user as the host, and it can only have one. A user may host multiple zoom meeting, or none. A calendar account has a calid, and a name. It is unique by calid. Calendar account is also unique by name A user can integrate to a calendar account. A user can integrate 0 or 1 calendar accounts, and a calendar account has to be integrated to a single user. Create the Chen ER Diagram A hospital wants to build a database for COVID testing. A patient has a first name, last name, address, gender, and patientid. They are unique by patientid. An address is composed of street, city, state and zip A test has a FDAid, a mfr, a mfrnumber, a description. It is unique by FDAid. It's also unique by the mfr and mfrnumber combined. This is not an individual test item, it is a brand. Tests also have ingredients, and can have multiple ingredients. A patient takes a covid test. A patient may have multiple covid tests done but must have at least one. A test can be administered to multiple people and can also be given to none. That relationship has a testdate, and a result. Create the Chen ER Diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning C# 5.0 Databases

Authors: Vidya Vrat Agarwal

2nd Edition

1430242604, 978-1430242604

More Books

Students also viewed these Databases questions

Question

what are the provisions in the absence of Partnership Deed?

Answered: 1 week ago

Question

1. What is called precipitation?

Answered: 1 week ago

Question

1.what is dew ?

Answered: 1 week ago

Question

Proficiency with Microsoft Word, Excel, PowerPoint

Answered: 1 week ago

Question

Experience with SharePoint and/or Microsoft Project desirable

Answered: 1 week ago