PLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships.

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter11: Advanced Inheritance Concepts
Section: Chapter Questions
Problem 3PE
icon
Related questions
Question

PLZ help with the following:

  1. Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships.

For the following:

The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication.
 

For each author, the library records the author ID, first and last name and year of birth. Because all faculty andstudents in the department are given accounts at the online library, the client ID, first and last name and client type need to be stored. Finally, checkout out date, checkout due date and checkout in date for each book must be tracked.

Starting from this general description, do the following initial steps in your database design process. However, you are free to make any reasonable assumptions that will help you to develop your ERD diagram.

ERD diagram should look like the picture 
Marks
Subjects
mark id
integer
H subject id
integer
student id
integer
title
varchar
subject id
integer
date
date/time
mark
integer
Students
Subject/teacher
H Student id
integer
subject id
integer
first name
varchar
teacher id
integer
last name
varchar
group id
integer
group id
integer
Groups
| group id
integer
name
varchar
Transcribed Image Text:Marks Subjects mark id integer H subject id integer student id integer title varchar subject id integer date date/time mark integer Students Subject/teacher H Student id integer subject id integer first name varchar teacher id integer last name varchar group id integer group id integer Groups | group id integer name varchar
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT