1 vodafone AU e-90% @ 3:49 pm aims.cqu.edu.au 4 of 15 Page 2 of 34 Term 3 Standa

Question

1 vodafone AU e-90% @ 3:49 pm aims.cqu.edu.au 4 of 15 Page 2 of 34 Term 3 Standard Examination 2017 Information System Analysis & Design-COIT20248 Question 2 8 Marks Clients borrow videos from the Video Library. The Library has many DVD's, when clients come to the library they can request a DVD to be issued. Staff check the ibrary catalogue to see i the DVD is available and not on hold for another client. Ithe DVD is not on hold it is issued to the client for a period of 2 or 7 days. Clients pay for borrowing the video after it is returned to the ibrary. Represent this situation of Video Library with an E-R diagram. Answer:- Page 3 of 14

Explanation / Answer

Answer:

Entity-Relationship Diagram:

      Explanation:

       Step 1: The client will request for the DVD.

       Step 2: The issuer will check for the availability of DVD.

       Step 3: If the DVD is available, it will be issued.

       Step 4: If it is on hold, then the DVD will not be issued.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.