Kindly go through this. The database development starts with the requirements analysis. There are many sources for gathering requirements. One of the important sources for requirements is “user interview”. During these interviews, users are asked about what kind of a system they need. Then requirements gathered from the interviews are transformed into a data model. Assume that a database designer made an interview and created an E-R diagram as above. Write a scenario that the user described requirements as in the Library Management System case study in Chapter 3.3 of Sharma et al. (2010, p. 77) during the interview - 3.3 A case study involving a Library Management System - This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: "The system will manage author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." Requirements described in this interview could be transformed into the above E-R diagram. After writing the scenario, you should also describe the cardinalities in the attached diagram.
Kindly go through this.
The
Assume that a database designer made an interview and created an E-R diagram as above.
Write a scenario that the user described requirements as in the Library Management System case study in Chapter 3.3 of Sharma et al. (2010, p. 77) during the interview - 3.3 A case study involving a Library Management System -
This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms:
"The system will manage author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address and e-mail.
New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue."
Requirements described in this interview could be transformed into the above E-R diagram. After writing the scenario, you should also describe the cardinalities in the attached diagram.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 8 images
