Answered: PLZ help with the following: Create a…

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

Related questions

Concept explainers

Question

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.

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

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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