HomeworkLib
Question

Draw a Design Class Diagram based on the following database requirements as provided by a book...

Draw a Design Class Diagram based on the following database requirements as provided by a book publisher

A. For each author, the book publisher would like to keep track of the author’s ID number, name, and contact number.

i. IC number is unique for each author

ii. First Name

iii. Last Name

iv. email

B. For each book, the book publisher would like to keep track of the book’s ISBN (International Standard Book Number) and name

i. ISBN is unique for each book

C. Authors write books

i. An author writes zero or more books

ii. A book is written by one or more authors

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

please find the attachment below

0 0
Add a comment
Know the answer?
Add Answer to:
Draw a Design Class Diagram based on the following database requirements as provided by a book...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • In MySQL: - Display the Editors’ first and last name, as well as the Book’s title...

    In MySQL: - Display the Editors’ first and last name, as well as the Book’s title sorted by Book’s title first and the Editor’s last name second for all Books that were published on September 26, 2006. - Display the Author’s first and last name, as well as their ID, and the Book title and number of pages for all of the books they have written that have more than the average number of pages for all of the books...

  • Author(name, address, URL) Book(ISBN, title, year, price,         publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL)...

    Author(name, address, URL) Book(ISBN, title, year, price,         publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL) Warehouse(code, phone, address) Stocks(ISBN, WH_code, number) Shopping-Basket(basketID, email) basketContains(ISBN, basketID, number) Customer(email, name, address, phone) Referring to the relational model in slide 15 in"ER-mapping" (about author, publisher, shopping-basket, provide the algebraic pressing for the following queries Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is Mark Smith" Q2: For each customer,...

  • Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information,...

    Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish 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...

  • Database Design The State of Connecticut has contracted you to build a database for their bookstores....

    Database Design The State of Connecticut has contracted you to build a database for their bookstores. The State of Connecticut operates twelve Community College Bookstores where they currently store information about the Colleges, Publishers, Authors, and Books. You have been given the task of automating the antiquated process that the bookstores currently use. Each one of the twelve Community Colleges has a unique College ID, a College Name, College Address and Bookstore Employees. After talking with the bookstore employees and...

  • Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and...

    Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. ‘Prentice hall’). Publishers have a name (key),...

  • In the Book class you created in Exercise 4a, overload the Object class Equals() method to...

    In the Book class you created in Exercise 4a, overload the Object class Equals() method to consider two Books equal if they have the same ISBN. Create a program that declares three Books; two should have the same ISBN and one should have a different one. Demonstrate that the Equals() method works correctly to compare the Books. Save the program as BookDemo2. c. Write an application that declares two Book objects and uses an extension method named DisplayTitleAndAuthor() with each....

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • The primary keys are underlined. The foreign keys are denoted by asterisks (*). Description of the...

    The primary keys are underlined. The foreign keys are denoted by asterisks (*). Description of the schema: • person — keeps track of the people who borrow books from the library. The attributes contain personal and contact information. • author — keeps track of personal information about authors. • publisher — keeps track of the publisher information. To keep it simple, most of the attributes have been truncated in the sample database. 1 trivial dependencies are things like X→X or...

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish 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...

  • Design an ER diagram for a library management system. The library manages books, members, and books...

    Design an ER diagram for a library management system. The library manages books, members, and books borrowed by members.  The library has several branches around the city. Each branch has a name and address and is identified by a branch ID.  Each book in the system is identified by a unique ISBN along with its title, author(s), and publisher.  A publisher is identified by its name, address, and phone. Note that publishers may be based anywhere around...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT