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.)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Every weak entity set can be converted to a strong entity set by simply adding theappropriate attributes. Why, then, do we have weak entity sets?
I have a HW that is asking me to draw on ERD diagram for a simple purchasing system that has order with order id, customer id, and date; order consists of one or more items; items consist of item id, description and price, and customers list customer id, name, and address. Can you help?
Question 2 Draw an activity Diagram in draw.io and screenshot it for me. Scenario Each subject has 1 lecture class and 4 tutorial classes. Each lecture class can have a maximum of 80 students only and each tutorial class can have a maximum of 20 students only. From the system, the faculty will generate a list of subjects that have registered students. Then the list of academicians for the faculty is displayed. For each academician, the faculty can assign either 1 lecture class or 3 tutorial classes. The faculty will keep assigning duty to the academicians until there are no more lecture or tutorial classes.
Transform into relational model (relations). IMPORTANT: The diagram needed for the second part uses a different notation for cardinality constraints. You can deduce the notation from the following: Each employee can work for exactly one department, and each department can have at least one employee. Each department has exactly one manager, and each employee manages at most one department. Each employee has at most one supervisor, and each supervisor can have several supervisees.
It is requested to draw an entity relationship diagram (ERD) for a real estate agency management system. Information about the subject are given below. The clients contain ID, name, surname, and email. Staff have ID, name, surname, username, and password. Properties have ID, price, status, and description. Each staff can serve one or more clients. Each client should be served by one staff. Each staff can handle one or more properties. Each property can be handled by one or more staff.
Draw an ER diagram for the following scenario: A designer has a store of designer dresses both for male and female. People can buy as well as take dresses on rent from the store. Each dress in the designer's store, is identified by unique ID. A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc. The designer maintains the name, phone number of people who have taken dresses on rent. The designer also maintains the name, phone number, and address of people who have bought dresses from the store. The designer also collects feedback from the people who have bought or taken dresses on rent from the store. Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.
Quiz-2 Section C 1. What is the purpose of activity diagram? Give a situation where you should use the forking concept. [4] 2. Draw an activity diagram for the following case [16] A swimline diagram for the following scenario to withdraw money from an ATM. Use only this description (do not make up your own information!). The customer inserts the ATM card and then enters their pin number. The Bank system then validates the pin. If the pin is invalid, the ATM machine ejects the card, the customer takes the card, and the scenario ends. Assuming the card pin was valid, the customer enters an amount to withdraw. The bank checks the account balance. If the balance is less than the amount to withdraw, the ATM shows the balance, and then ejects the card. Once ejected the customer then takes the card and the scenario ends. Assuming the amount is available, the customer takes money from the slot and at THE SAME TIME the bank debits the account. Once the customer has taken money and the account…
It is possible to can convert any weak entity set to a strong entity set by simply addingappropriate attributes. Why, then, do we have weak entity sets?
Describe how the composite attribute of an E-R diagram is transformed into relations
MAKE AN ER DIAGRAM FOR THE FOLLOWING PROMPT: Various physicians are working for a clinic and these doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician’s specialty and rank are captured. Every physician serves as a primary care physician for at least one patient; however, no more than 20 patients are allotted to a physician. Every patient is assigned one physician for primary care. Data for patients include: patient number (the unique identifier of a patient), name, gender, date of birth, blood type and the code and name of allergies, if any. Physicians may prescribe medications to patients; thus, it is necessary to capture which physician(s) prescribe(s)s what medication(s) to which patient(s) along with dosage and frequency. In addition, no two physicians can prescribe the same medication to the same patient. If a physician leaves the clinic, all prescriptions written by that physician…
Can you tell me if there is any mistakes in this diagram?? thats its requirenments: During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC’s manager gives you the following description of the business: TEC has a file of candidates who are willing to work. If the candidate has worked before, that candidate has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a BBA degree or a Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft Network Certification.) TEC offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, TEC does not…
Choose a real-world scenario with several possible Venn diagram solutions. Justify your selection of a Venn diagram for this task. Explain why it's crucial for the various groups to intersect and merge.