A library wants to build a simple online recommendation system for a summer reading programme. The system involves people reading and recommending books and authors. • Readers (people) have a screen name as well as a real name and contact information, including an unknown number of phone numbers they can be contacted at. • Books have a title, ISBN, genre and reading level. • An author has a name and nationality. They can write zero or more books. • Assume that Books are written by only one author. • The database records what books a reader has read. • Readers can “like” books. • Readers can “like” authors independent of the books the author has written. Create a hand-drawn, conceptual entity relationship diagram (like the last lab, except that you’re including attributes) describing this circumstance for a database designer.

In Chapter 3 of Sharma et al. (2010), you will be introduced with a case study:    "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 the 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." (Sharma, et al., 77).  Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…

But what does it mean to have wide and consistent rules?

Activity: Interaction Models Consider the university system. Departments offer courses. Professors teach courses. Students can declare majors and are admitted to university departments if they meet minimum requirements. Students and professors have schedules based on courses they take/teach. Courses have rosters, scheduled times, and instructors. Courses may get full. Students can request to sign up for courses, and if the course is not full and they meet pre-requisites, the course is added to their schedule and the course will have them as a student in that course. Students can also drop courses. Students should be informed of the consequences such as change of status from full-time to part-time, loss of scholarships, and delays in graduation. Perform the following: 1. Create a use-case diagram for this university. Make your use-case diagram as complete as you can. 2. Pick two use cases from your use case diagram, CourseAdd and CourseDrop, and describe these use cases in the standard…

A decision table makes it easier to link conditions to actions. explain?

Draw level 1 DFD for the context diagram below Main function for the health tracker: - User management such as register, login, logout - User information such as height, weight, BMI, gender, age, activity level, goal weight, suggested calorie intake, bedtime (to manage/control the diet intake based on the lifestyle) - Diet management such as suggested food menus, calories intake, water intake (glass) for a day. (based on user input informations) - Exercise diary such as type of workout preferred, duration, daily steps, calorie burnt, meditation (based on the user informations input)    - Progress such as start weight, current weight, achievement, weight loss, date

Draw a Use Case Diagram for Patient management system Vic’s hospital has a patient management system. A patient must register with the hospital before start of the treatment. Once registered, a doctor is assigned to the patient. The patient must be provided with an appointment date based on the urgency. A doctor meets the patient and request tests to be performed by labs. When the lab results are ready, a new appointment is set with doctor. Doctor meets the patient again and prescribe medicines and treatments/rehabilitation.

When it comes to analyzing people's feelings, what kinds of situations often call for it?

An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum. A traveling show is described by a show ID (identifier), the city in which the show is currently appearing, and the start and end dates of the show. Many of the museum works may be part of a given show, and onlyactive shows with at least…

Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…