Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Match the numbers to traditional ER Diagram lines. ielect all that are true for the ER Diagram: A Payment could be for a single Bill.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Match the numbers to traditional ER Diagram lines. ielect all that are true for the ER Diagram: A Payment could be for a single Bill. A Bill could be for one Doctor. A Payment could be for multiple Bills. A Bill could be for multiple Doctors. According to the ER Diagram below, select all that are true. Figure 7 - ERD Diagram for Hotel Grand Lionne A Room can be reserved by two Guests. A Guest can reserve one Room. A Guest can reserve three Rooms. A Room can be reserved by one Guest. According to the ER Diagram below, select all that are true. Figure 7 - ERD Diagram for Hotel Grand Lionne A Room must be reserved by only one Guest. An Invoice must be processed by only one Staff. A Room must be owned by only one Hotel. A Staff must work at only one Hotel. jelect all that are true for the ER Diagram: A Bill relates to a specific Doctor. A Bill relates a specific Doctor and a specific Payment. An Appointment relates to a specific Patient and a specific Doctor. A Bill relates to one or more Payments. jelect all that are true for the ER Diagram: Doctors can have the same Salary. Doctors are not allowed to have the same name. Doctors have a unique id (Doctorid). Doctors can have a different Salary. According to the ER Diagram below, select all that are true. Figure 7 - ERD Diagram for Hotel Grand Lionne A Guest can pay for one Invoice. An Invoice can be paid by two Guests. An Invoice will be paid by only one Guest. A Guest can pay two Invoices. According to the ER Diagram below, select all that are true. An Event involves only one Fish. A Tank can have multiple Fish. A Tank can have no Fish. A Event can involve many Fish. According to the ER Diagram below, select all that are true. Figure 7 - ERD Diagram for Hotel Grand Lionne A Hotel employs at least on Staff. An Invoice will specify both a specific Staff and a specific Guest. A Hotel does not have to have any rooms. Staff only work for a single Hotel. According to the ER Diagram below, select all that are true. Figure 7 - ERD Diagram for Hotel Grand Lionne Staff must have unique names. Staff must have unique Phone numbers. Staff must have a unique Salary. Staff have a unique id (Staff_ID)

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions