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
Homework Answers
Add Answer to:
Draw a Design Class Diagram based on the
following database requirements as provided by a book...
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...
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),...
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...
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...
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher,...
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...
Programming Assignment This is a database course using Open Office Database. Assume that you have been...
Programming Assignment This is a database course using Open Office Database. Assume that you have been given the task of creating a system for a library to keep track of their books, the borrowers of the books, and the books that are currently lent out. Your first step will be to create the relations necessary for this system. Book will need information such as a unique identifier for each book, title, author, ISBN number, date of publication, cost. Borrower will...
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, 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...
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 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), 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...
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...
Most questions answered within 3 hours.
-
Why [M(CN)6] is not organometallic even it has metal
to carbon bond too
asked 1 minute from now -
mstar electric has a bond issue outstanding that has a 20 year
life, a $1,000 par...
asked 5 minutes ago -
This is a Business Writing Question:
Common Types of Faulty Sentence Logic:
A. Mixed constructions
B....
asked 6 minutes ago -
Skinner asserts that science, and the common view of science, has
been tarnished. Explain his evidence...
asked 9 minutes ago -
Question 3 (1 point)
Fill in the blank. Speed Car Rental company found that the tire...
asked 9 minutes ago -
An short-seller in Tesla is worried the latest management
earnings forecast is too aggressive and the...
asked 9 minutes ago -
A grocery store's receipts show that Sunday customer purchases
have a skewed distribution with a mean...
asked 15 minutes ago -
A 0.035 mol sample of a weak acid, HA, is dissolved in 437 mL of
water...
asked 27 minutes ago -
a sample of Ar gas has a volume of 6.30 L with an unknown
pressure. the...
asked 27 minutes ago -
The
serum cholesterol levels of a population of kids follow a normal
distribution with mean 155...
asked 47 minutes ago -
han discusses the racist practice of badlands, a bar
in the Castro
district of San Francisco,...
asked 59 minutes ago -
A sample of final exam scores is normally distributed with a
mean equal to 25 and...
asked 1 hour ago