Here is a situation where storing some information in a database might be useful. Read the description, and then do the entity-relationship modelling, see below. Once upon a time, in the tiny village of Hatley, there was a library, where people could borow books. It worked like this: 1. You found a book on the shelves. 2. You took it to the Librarian, sitting at an ornate desk crafted by Jean, an excellent local woodworker. 3. The librarian took a card out of the book (or made a new card if necessary), stamped the date due on it and a slip at the back of the book, then put the card in a pocket with your name on it (unless you already had 3 unreturned books) 4. If you returned a book, this process was basically undone. Books need to be identified by title, possibly year, and author. (In case of multiple authors, this attribute can hold the first author, or both, for example, 'Kernighan & Ritchie'). As the "computer guy" I was asked to "put all this on the computer" (A Bishop's discard.) I declined. Today, I might do it, using database software. (The larger village of North Hatley now uses a computer for this.)

Here is a situation where storing some information in a database might be useful. Read the description, and then do the entity-relationship modelling, see below. Once upon a time, in the tiny village of Hatley, there was a library, where people could borow books. It worked like this: 1. You found a book on the shelves. 2. You took it to the Librarian, sitting at an ornate desk crafted by Jean, an excellent local woodworker. 3. The librarian took a card out of the book (or made a new card if necessary), stamped the date due on it and a slip at the back of the book, then put the card in a pocket with your name on it (unless you already had 3 unreturned books) 4. If you returned a book, this process was basically undone. Books need to be identified by title, possibly year, and author. (In case of multiple authors, this attribute can hold the first author, or both, for example, 'Kernighan & Ritchie'). As the "computer guy" I was asked to "put all this on the computer" (A Bishop's discard.) I declined. Today, I might do it, using database software. (The larger village of North Hatley now uses a computer for this.)

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

You are required to design and implement a database system for a pharmacy shop with only one branch. The following is the description from the manager, Mr. Seth Akoto. “here, medicines that require prescriptions are sold only to people that have prescriptions. It is the pharmacy attendant that serves customers when they enter the pharmacy. Usually, people walk in and either give the prescription or mention the medicine they wish to purchase. The worker then searches to see if the medicine is in stock. If in stock, worker accepts payment from customer and gives the medicine and a receipt to the customer. “ 1. Determine all the entities from the description given by Mr. Akoto. 2. Assuming Mr. Akoto only wants a database system that would keep records of medicine{name of medicine, amount in grams in stock} and purchases{medicine bought, amount in grams bought, who attended to customer, when it was sold, contact and name of customer that bought the medicine} a. Draw and ER diagram with…
Create a sample data flow diagram of a database: For example, a residents filling out the form (personal information) and an admin updating/accessing the records of the residents. (Name, address, contact #, family members).
Draw and explain the use-case diagram, activity diagram, interaction diagram for the following: Consider developing a desktop-based framework to assist people in preparing for a certification exam like "SE@exam". A user can ask the system to create a quiz for them. The machine selects a group of questions from its database and assembles them into a quiz. It assigns a score to the user's responses and provides hints if the user needs them. We have helpers that give hints in addition to users. And also examiners who must certify questions to make sure they are not too trivial. Work out some of your use cases since we don't have real stake holders here, you are free to fill in details you think is required for this example.
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
Your Division Head's point of view is as follows: "Pictures are stored in a database, and the basic design/structure we chose includes some very sensitive driver information." What if we placed it in its own folder, out of reach of people who shouldn't have access to it? What would your stance be, or, more precisely, which strategy would you prefer? It is necessary to present justification.
Quiz 2/III Draw the use case model and write main scenario and extensions for the following: student online registration in a computer college : a student enters his information in the college website and receives a registration code to his email . then login the email to complete the process and get a message that he is being added to the student database if his degrees are under the average the system will redirect the record to another college.
Create an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…
Computer science
Question Draw and explain the use-case diagram, activity diagram, interaction diagram for the following: Consider developing a desktop-based framework to assist people in preparing for a certification exam like "SE@exam". A user can ask the system to create a quiz for them. The machine selects a group of questions from its database and assembles them into a quiz. It assigns a score to the user's responses and provides hints if the user needs them. We have helpers that give hints in addition to users. And also examiners who must certify questions to make sure they are not too trivial. Work out some of your use cases since we don't have real stake holders here, you are free to fill in details you think is required for this example.
Draw an ER model; An author writed a book . Every book has a title, ISBN, year, and price. each book may be authored by one or more author and each author may write one , or more than one book. For authors the database keeps the name, address and URL of their homepage. Each book has a publisher. The database keeps the name, address , and phone number adn the URL of their wedbsite. Each publishers publishes one or more books and each book is published by exactly one publisher. The warehouse stocks several books. Each warehouse has a code, address and phone number. The database records the number of copies stocked at various warehouse.
Create an ER model for a restaurant. The specifications are as follows: The customer has an id, name, address and telephone number. The customer can reserve a table before arrival. Each reservation has a unique key and includes the date and time of reservation and the number of seats. Upon arrival, the customer places an order. Each order has a unique order number and includes one or more food items. Each food item is distinguished by an id and has name and price. We also keep track of the cashier who settle the payment with the customer before he leaves the restaurant. The cashier has an id and name.
Draw the EER dia