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.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 3TD

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?
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.
database
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 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…
Please draw an Entity-Relationship diagram for the given below MOVIE database. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies.
Case 3: Create a sequence diagram based for Belle's Grocer Automated Checkout System. Belle's Grocer is developing its own automated checkout counter. When customers come up to the counter, they will first scan their membership code if they have one or skip this step if they don't. If they have their membership, the screen will show their membership details such as name, membership ID and membership expiry date based on their members database. Customers will then scan their own items, where item info and price will be pulled from the database. The system then calculates total grocery amount and factor in membership discount to generate the end total. Customers check the items and total before checking out. Customer can choose payment of cash or card. Card payment will require customer digital signature. If cash, the system will receive input cash and confirm cash amount with the customer before proceeding to return balance. The Classes involved: 1. Membership 2. Input grocery items 3.…
Use the Information below and create a sequence diagram for the use case. Name: Buy Parts Actor: Customer/Store Associate Description: This use case describes the process used to buy parts at the auto parts dealer. Successful Completion: 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is available and customer pays cost 4. Customer receives part and stock is adjusted 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is not available and customer selects to order part or no part 4. Customer receives part and stock is adjusted (if alternate part ordered) or customer leaves with no part Alternative: Pre-Condition: Customer wants to purchase part Post-Condition: None Assumptions: None
Draw an Entity Relationship Diagram (ERD) based on the flat files that have been supplied. Your ERD must incorporate all the entities and attributes supplied, as well as establishing the relationships between the entities
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, Employee Name, EmployeeSalary) ProjectID 100-A 100-A FIGURE 2-33 Sample Data for Regional Labs 100-B 200-A 200-B 200-C 200-C 200-D EmployeeName 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 70,000.00 58,000.00
Design: An (ER) and (relational Diagram) by showing as I am an owner of a car rental company website describing the following domain: I am the owner of the website, and I see the registered customers records I have through different car types and car rental Every rental operation has a start or end by day or KM Every car has a different price depending on its year production and model We have three rental types( Per Kilometers, monthly, daily) in different prices even though it was the same car Any one can enter his 'id' which includes ( Name, age, gender, address, city, Civil id), and this 'id' is the primary ket to all entities He would proceed to register for renting a car per his choice Then he will send the registrations form that I will analyze and contact him Every customer can rent only one car This choice has one car rental type based on the available listed cars in the registration The owner of that website has the "id" records and the registration database running its…
Draw the Mapping for the following diagram

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Principles of Information Systems (MindTap Course…

Computer Science