Create a complete ER diagram to represent the data used by a library. The library provides books to borrowers. Each book is described by title, edition, and year of publication and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book, and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may borrow one or many books and the date each book is loaned out and is returned is recorded. A loan number uniquely identifies each book loan.

Create a complete ER diagram to represent the data used by a library. The library provides books to borrowers. Each book is described by title, edition, and year of publication and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book, and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may borrow one or many books and the date each book is loaned out and is returned is recorded. A loan number uniquely identifies each book loan.

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

A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)
An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
Requirement analysis: Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth. For each course, the courses contain course id, course name and credit. Each student can take many courses. For each Instructor, the instructors contain id, name and email. Each instructor can instruct many courses. For each section, the sections contain section id, year and semester. Students are able to evaluate the current courses. ER-diagram: Please complete the ER diagram using Microsoft word. Instructor ID Full name Email Student ID Full name Email Phone number Address Date of birth Course ID Course title Description Credit Section ID Year Semester Please Complete the diagram on MS word.
Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERD
pls help me : Draw an ER diagram according to the following requirements:Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients):- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department- The patient when he comes to the doctor will be created a patient record if it is the first visit- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any- Patients can buy medicine in the hospital pharmacy or buy it outside
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-33 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) FIGURE 2-33 Sample Data for Regional Labs A. ProjectID 100-A 100-A 100-B 200-A 200-B 200-C 200-C 200-D Employee Name Eric Jones Donna Smith Donna Smith Eric Jones Eric Jones Eric Parks Donna Smith Eric Parks Employee Salary 64,000.00 70.000.00 70,000.00 64,000.00 64,000.00 58,000.00 1. ProjectID → Employee Name 2. ProjectID EmployeeSalary 3. EmployeeName → EmployeeSalary 4. EmployeeSalary → ProjectID 5. EmployeeSalary → (ProjectID, EmployeeName) 70,000.00 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE
Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored. Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years). A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…
Instructions: Write your answers by replacing the blue lines. Explain your answers if necessary. REGIONAL LABS CASE QUESTIONS Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectID à EmployeeName _______ ProjectID à EmployeeSalary _______ EmployeeName à EmployeeSalary _______ EmployeeSalary à ProjectID _______ EmployeeSalary à (ProjectID, EmployeeName) ______ What is the primary key of PROJECT? ________________________________ Are all the non-key attributes (if any) dependent on the primary key? ____________________________________________…
Instructions: Write your answers by replacing the blue lines. Explain your answers if necessary. REGIONAL LABS CASE QUESTIONS Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectID ->EmployeeName _______ ProjectID ->EmployeeSalary _______ EmployeeName -> EmployeeSalary _______ EmployeeSalary -> ProjectID _______ EmployeeSalary -> (ProjectID, EmployeeName) ______ What is the primary key of PROJECT? ________________________________ Are all the non-key attributes (if any) dependent on the primary key?…